Thanks for the comment Nawaaz - this was a good video to make as it answered so many of the questions I had when I started with Set Analysis - stay well.
Great video.. you make things easily understandable. I was in fact looking for dynamic functions in qliksense and you explained one. Could you please provide list of all dynamic functions for rolling 5 weeks, rolling 7 days as well..
Great video, thanks. Just a pity it does not seem possible to do set analysis on fractiles, eg. fractile(sales_price,0.25). Or is there a way to do it?
I would love to see a video on manipulating between dates for example sum or count a row with a value in a between calculated dates) also dealing with null values. Thanks!
Hi Elizabeth - that is perfect for the Qlik Community, please join the community community.qlik.com/ and post your thread there that way myself and others can better support your request.
Great video and helped me so much. Would you be able to post a video on date interval based on functions? For example, I would like to restrict sales data based on today's month and next 2 months, in order to check orders that are still open. Thanks again!! :)
+Luiz Henrique de Paula - Hi Luiz - I have a few planned, looking at doing one on AGGR next. Note - we don't always check the comments in YT, it is best to post these types of questions in the qlik community. community.qlik.com
Great Video! Very useful. One question though, at the end you do the year/today function, what about the poor label? Would it be possibly to that to update to display the year, or month even to remove all doubt that it is the date you'd picked?
Good Question Mike - currently it seems that the label property does not allow dynamic functions yet, but you could use the Appearance->General properties and dynamically create a subtitle, title, and footnote. Please note - its better to also join the Qlik Community and open discussions there as we are better equipped to help you there.
Hi Avishek - thanks for the comment - QlikView videos are here: community.qlik.com/docs/DOC-1986 Qlik Sense videos are here: th-cam.com/channels/FxZPr8pHfZS0n3jxx74rpA.html and also some others in the Qlik Community: community.qlik.com/docs/DOC-6932 - please join us in the Qlik Community where we are better equipped to assist you and answer your questions.
Hey thank you for your amazing videos! How can I make a pie chart with the sales of all years but dividing them into 2. 1st set is Sales of 2015, 2nd set is Sales of other years (total of them).
Hi Berrin - thanks for your question - questions like this are best for the Qlik Community - please look for the New to Qlik Sense forum and post there - and one of our valued community members and Qlik experts can help you.
Hi Michael, this was very helpful. Is there a way to link the conditional value in an expression based on a filter pane's value? Ex - Let's say - i have a filter that selects two values 'A' and 'B'. I have a bar chart that sums values based on the following : Sum({} Sales) /Sum(Sales)). can i make the var A dynamic based on a value i select from a filter pane? Thanks
+malvika sahu Hi Malvika - thanks! Note that we don't always check the comments in YT, it is best to post these types of questions in the qlik community. - community.qlik.com see you there.
+Alexandre Zacarias Hi Alex - I have a few planned, looking at doing one on AGGR next. Note - we don't always check the comments in YT, it is best to post these types of questions in the qlik community. community.qlik.com
Hi There - thanks for your question - it is best to post stuff like this in the Qlik Community so myself and other members can better assist you. Have you searched the community yet - if not I did find something that may help: community.qlik.com/thread/264112 - if you open a discussion thread we can better help you. Let us know how you do.
I was trying to create a MAP of US states with corresponding sales figure..How can I use Set Analysis in this case , or Do i need to use some other function.
Hi. Is there a way to get the legend titles within the chart. For example Country on the X-axis, values on the Y-axis and the name of the legend(babywear, sportwear) on the charts.
Hi Chirayu - first if you can post questions like this in the Qlik Community forums - community.qlik.com, that would be best as we are better prepared and can reply to you much quicker as the entire Qlik community is available to you. In reply to your question - yes - you need to have both dimensions in the char - , Category, Country then group the chart presentation as stacked and then color by Category - this will give you the country values along the X-axis and the stacked colors for each category will be in the bars - and the legend will reflect those colors. If this is not what you are looking for, please post in the Qlik community - tag me by typing @michael_tarallo and select mto from the list and I will be notified and I can further assist. Thanks!
Hi Jr - best place for questions like this is the Qlik Community - however check out this community document and video - it covers dimension limits - which provides the similar functionality you are looking for: community.qlik.com/docs/DOC-7006
Hello!! thanks for the video. Im trying to upload the dashboard always using the last date of the database. I have tried using max (date) function but the result is always cero (in fact the result is a "-"). What cant i do. Is is possible in Qlik Sense Desktop?
Hello Alejandra - thanks for your question - I would suggest posting this topic in the Qlik Community forums - community.qlik.com/welcome - we'll see you there.
Hey Mike, could you tell me where is the problem with this formula? I ve tried a lot and it doenst work, i need to see the results in the year before. sum({$}importe_tarj), thanks a lot i m a very beginer here.
Hi Calzalindo - thanks for your question - it's best to post these types of questions in the Qlik community because I can attach samples and screen shots etc. Looking at this - you are missing the $ in the dollar expansion example - see from 13:32 and let me know how you do. :-)
my selection never worked. Transactions: Load * Inline [ transaction_id, transaction_date, transaction_amount, transaction_quantity, customer_id, size, color_code 3750, 20180830, 23.56, 2, 2038593, L, Red 3751, 20180907, 556.31, 6, 203521, m, orange 3752, 20180916, 5.75, 1, 5646471, S, blue 3753, 20180922, 125.00, 7, 3036491, l, Black 3754, 20180922, 484.21, 13, 049681, xs, Red 3756, 20180922, 59.18, 2, 2038593, M, Blue 3757, 20180923, 177.42, 21, 203521, XL, Black ](delimiter is ','); set vColorCode = "Red"; where I am doing wrong in set analysis at measure I put under the expression sum({$}color_code) following results I am getting. I think I should get Red row only. Please help. color_code sum({$}color_code) Red 0 Blue 0 Orange 0
Hi Deepali - in short - the $ expansion syntax $(= function()) enables you to use a formula / function / expression as a parameter / argument to resolve to a value - so it can be used in a Set Analysis Expression - so - would take in the current year for today's date and resolve to 2018 - let me know if you need more information.
![ไลฟ์สุ่ม iPhone 295 บาท... โกงมั้ย?[ โกงมั้ยครับ ep.97 ] | DOM](http://i.ytimg.com/vi/gdstHEE4UUE/mqdefault.jpg)
Thank you for this detailed and easy to follow tutorial, I feel more confident now in set analyses.
Thanks for the comment Nawaaz - this was a good video to make as it answered so many of the questions I had when I started with Set Analysis - stay well.
Great Video! Michael you have a gift of making everything you say easy to understand and learn!
+antonio +1 - thanks Antonio
Seriously.. I have never seen anybody explaining set analysis so well!! Kudos!! Loved it!
Best video I have seen on Set Analysis. Thank you very much!!!
Hi Michael, i have learnt qliksense within 30days because of you only. ur awesome....
Superb videos Michael, You make it look so easy!! Please share more videos on functions and lookup capabilities of Qliksense
You are a MASTER EXPLAINER!...thanks for the videos. Great help.
Michael you have a great teaching skill. you are awesome.
Michael Thank u so much that was v informative learning and east understanding. please more elaborate on set Analysis and Extentions.Thanks
Super helpful and well made. Would love to see more. Thanks so much
Thank you - new to QS and needing easy to understand tutorials - your's are excellent - thanks
Great video..very helpful and easy to understand. Thanks Michael.
Great video.. you make things easily understandable. I was in fact looking for dynamic functions in qliksense and you explained one. Could you please provide list of all dynamic functions for rolling 5 weeks, rolling 7 days as well..
Good video! :) Thank you, these are very helpful!
(I have to say that on the notepad there was a misspelling: wlidcard)
Thank you for this video. Looking forward for more Qlik tutorial video for beginners like me. :)
Great video, thanks. Just a pity it does not seem possible to do set analysis on fractiles, eg. fractile(sales_price,0.25). Or is there a way to do it?
cool stuff.. very well explained.. Thank you Michael
Thank your for the video!
Is it possible to have a function like "year(today()) in the Label section?
I would love to see a video on manipulating between dates for example sum or count a row with a value in a between calculated dates) also dealing with null values. Thanks!
Hi Elizabeth - that is perfect for the Qlik Community, please join the community community.qlik.com/ and post your thread there that way myself and others can better support your request.
Excelente video, muy clara la explicacion lo utilice y salio perfecto.
Very helpful video, learned lots of tips.
Great video and helped me so much. Would you be able to post a video on date interval based on functions? For example, I would like to restrict sales data based on today's month and next 2 months, in order to check orders that are still open.
Thanks again!! :)
+Luiz Henrique de Paula - Hi Luiz - I have a few planned, looking at doing one on AGGR next. Note - we don't always check the comments in YT, it is best to post these types of questions in the qlik community. community.qlik.com
Awsome explanation! Thanks in Advance!
good job
Thank you - I had fun making this one - hard to believe it was over 5 years ago, stay well!
Nice video. You demystified $ expansion for me. Thanks
Very clearly explained, thanks !!
Clearly explained. Thank you so much for this! :)
Excellent vid. Thanks for sharing
Very good Explanation
Great Video! Very useful. One question though, at the end you do the year/today function, what about the poor label? Would it be possibly to that to update to display the year, or month even to remove all doubt that it is the date you'd picked?
Good Question Mike - currently it seems that the label property does not allow dynamic functions yet, but you could use the Appearance->General properties and dynamically create a subtitle, title, and footnote. Please note - its better to also join the Qlik Community and open discussions there as we are better equipped to help you there.
Nice and helpful video. Can i know, where i can find all your Qlikview related video libraries.
Hi Avishek - thanks for the comment - QlikView videos are here: community.qlik.com/docs/DOC-1986 Qlik Sense videos are here: th-cam.com/channels/FxZPr8pHfZS0n3jxx74rpA.html and also some others in the Qlik Community: community.qlik.com/docs/DOC-6932 - please join us in the Qlik Community where we are better equipped to assist you and answer your questions.
Hey thank you for your amazing videos! How can I make a pie chart with the sales of all years but dividing them into 2. 1st set is Sales of 2015, 2nd set is Sales of other years (total of them).
Hi Berrin - thanks for your question - questions like this are best for the Qlik Community - please look for the New to Qlik Sense forum and post there - and one of our valued community members and Qlik experts can help you.
Omg, that's clarify everything to me.
Hi Michael, this was very helpful. Is there a way to link the conditional value in an expression based on a filter pane's value?
Ex - Let's say - i have a filter that selects two values 'A' and 'B'. I have a bar chart that sums values based on the following :
Sum({} Sales) /Sum(Sales)). can i make the var A dynamic based on a value i select from a filter pane?
Thanks
+malvika sahu Hi Malvika - thanks! Note that we don't always check the comments in YT, it is best to post these
types of questions in the qlik community. - community.qlik.com see you there.
I have posted my query on the community but haven't got any response so far. :(
did you find an answer to this?
i just had this question too and i found a way at community.qlikview.com/thread/59477
but by changing : {"
Hi Michael could you do a video about intervalmatch and agregation?
+Alexandre Zacarias Hi Alex - I have a few planned, looking at doing one on AGGR next. Note -
we don't always check the comments in YT, it is best to post these
types of questions in the qlik community. community.qlik.com
thank you for video ! but where are others videos?
Hi Justice - can you elaborate on this question so we can further assist?
Nice video.. Please help in creating a 12-month rolling chart so that whenever I look at it, it shows previous 12 months
Hi There - thanks for your question - it is best to post stuff like this in the Qlik Community so myself and other members can better assist you. Have you searched the community yet - if not I did find something that may help: community.qlik.com/thread/264112 - if you open a discussion thread we can better help you. Let us know how you do.
I was trying to create a MAP of US states with corresponding sales figure..How can I use Set Analysis in this case , or Do i need to use some other function.
Clearly explained...
thank you Michael!
awesome tutorial! thanks.
Hi! how can I use the % symbol or do calculated fields in Qlik. I want to calculate % contribution but I cant.
Excelente me ha servido mucho.
Hi. Is there a way to get the legend titles within the chart. For example Country on the X-axis, values on the Y-axis and the name of the legend(babywear, sportwear) on the charts.
Hi Chirayu - first if you can post questions like this in the Qlik Community forums - community.qlik.com, that would be best as we are better prepared and can reply to you much quicker as the entire Qlik community is available to you. In reply to your question - yes - you need to have both dimensions in the char - , Category, Country then group the chart presentation as stacked and then color by Category - this will give you the country values along the X-axis and the stacked colors for each category will be in the bars - and the legend will reflect those colors. If this is not what you are looking for, please post in the Qlik community - tag me by typing @michael_tarallo and select mto from the list and I will be notified and I can further assist. Thanks!
Hello..Can you show an example about a Top 10 of sales? I need to show a top1000 of bigdata about banking..
Hi Jr - best place for questions like this is the Qlik Community - however check out this community document and video - it covers dimension limits - which provides the similar functionality you are looking for: community.qlik.com/docs/DOC-7006
Good information Thank you !
Hello!! thanks for the video. Im trying to upload the dashboard always using the last date of the database. I have tried using max (date) function but the result is always cero (in fact the result is a "-"). What cant i do. Is is possible in Qlik Sense Desktop?
Hello Alejandra - thanks for your question - I would suggest posting this topic in the Qlik Community forums - community.qlik.com/welcome - we'll see you there.
Hey Mike, could you tell me where is the problem with this formula? I ve tried a lot and it doenst work, i need to see the results in the year before. sum({$}importe_tarj), thanks a lot i m a very beginer here.
Hi Calzalindo - thanks for your question - it's best to post these types of questions in the Qlik community because I can attach samples and screen shots etc. Looking at this - you are missing the $ in the dollar expansion example - see from 13:32 and let me know how you do. :-)
Amazing even to the experts!
Great. Thanks a lot
Nice and Thank You..
thanks very useful!
hi there,
how do i Abbreviate money labels (i.e. $10,000,000,000,000 -> $10T) ?? on qlik sense.
Hello +Nazu Mcnaz - please post questions such as these on the Qlik Community. community.qlik.com
my selection never worked.
Transactions:
Load * Inline [
transaction_id, transaction_date, transaction_amount, transaction_quantity, customer_id, size, color_code
3750, 20180830, 23.56, 2, 2038593, L, Red
3751, 20180907, 556.31, 6, 203521, m, orange
3752, 20180916, 5.75, 1, 5646471, S, blue
3753, 20180922, 125.00, 7, 3036491, l, Black
3754, 20180922, 484.21, 13, 049681, xs, Red
3756, 20180922, 59.18, 2, 2038593, M, Blue
3757, 20180923, 177.42, 21, 203521, XL, Black
](delimiter is ',');
set vColorCode = "Red";
where I am doing wrong in set analysis at measure I put under the expression
sum({$}color_code)
following results I am getting. I think I should get Red row only. Please help.
color_code sum({$}color_code)
Red 0
Blue 0
Orange 0
From the tutorial I think it should be:
Sum({$}color_code)
Didn’t understood the use of $ expansion
Hi Deepali - in short - the $ expansion syntax $(= function()) enables you to use a formula / function / expression as a parameter / argument to resolve to a value - so it can be used in a Set Analysis Expression - so - would take in the current year for today's date and resolve to 2018 - let me know if you need more information.
Thank you for this video. Looking forward for more Qlik tutorial video for beginners like me. :)