Set Analysis - Part 2 - Cool Stuff You can Do: Qlik Sense and QlikView

[@zambokid89]

Best video I have seen on Set Analysis. Thank you very much!!!

[@nawaazr5388]

Thank you for this detailed and easy to follow tutorial, I feel more confident now in set analyses.

[@GuyInaQ]

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.

[@rambabubollipalli661]

Hi Michael, i have learnt qliksense within 30days because of you only. ur awesome....

[@italianblood23]

Great Video! Michael you have a gift of making everything you say easy to understand and learn!

[@QlikOfficial]

+antonio +1 - thanks Antonio

[@jaspreetsran6681]

Seriously.. I have never seen anybody explaining set analysis so well!! Kudos!! Loved it!

[@shinimannan]

Superb videos Michael, You make it look so easy!! Please share more videos on functions and lookup capabilities of Qliksense

[@riteshkothari1647]

You are a MASTER EXPLAINER!...thanks for the videos. Great help.

[@RandallPorter03]

Super helpful and well made. Would love to see more. Thanks so much

[@ramchandrapai4228]

Michael you have a great teaching skill. you are awesome.

[@tarunak613]

Great video..very helpful and easy to understand. Thanks Michael.

[@mikerajput159]

Michael Thank u so much that was v informative learning and east understanding. please more elaborate on set Analysis and Extentions.Thanks

[@JamesWilliams-ww6si]

Thank you - new to QS and needing easy to understand tutorials - your's are excellent - thanks

[@ManoharSingh-ht5vs]

cool stuff.. very well explained.. Thank you Michael

[@nobomopo]

Good video! :) Thank you, these are very helpful! (I have to say that on the notepad there was a misspelling: wlidcard)

[@hbuhrmann]

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?

[@hemalathab3944]

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..

[@sharmaineebuenga9264]

Thank you for this video. Looking forward for more Qlik tutorial video for beginners like me. :)

[@maximilianmb485]

Thank your for the video! Is it possible to have a function like "year(today()) in the Label section?

[@philipmeric8659]

good job

[@GuyInaQ]

Thank you - I had fun making this one - hard to believe it was over 5 years ago, stay well!

[@adanyoshimoto7504]

Awsome explanation! Thanks in Advance!

[@Jenicek25]

Very clearly explained, thanks !!

[@amarendrasahoo8482]

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.

[@247365v]

Hi! how can I use the % symbol or do calculated fields in Qlik. I want to calculate % contribution but I cant.

[@aliakhan3185]

Very helpful video, learned lots of tips.

[@mikedodds1321]

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?

[@GuyInaQ]

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.

[@hk3172]

Excellent vid. Thanks for sharing

[@luizhenriquedepaula6791]

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!! :)

[@QlikOfficial]

+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

[@sarahelaine0714]

Clearly explained. Thank you so much for this! :)

[@avishekbhattacharya9833]

Nice and helpful video. Can i know, where i can find all your Qlikview related video libraries.

[@GuyInaQ]

Hi Avishek - thanks for the comment - QlikView videos are here: community.qlik.com/docs/DOC-1986 Qlik Sense videos are here: kzbin.info/door/FxZPr8pHfZS0n3jxx74rpA 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.

[@KayYesYouTuber]

Nice video. You demystified $ expansion for me. Thanks

[@justice3171]

thank you for video ! but where are others videos?

[@QlikOfficial]

Hi Justice - can you elaborate on this question so we can further assist?

[@oscarob58]

Excelente video, muy clara la explicacion lo utilice y salio perfecto.

[@ElizabethHirsch]

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!

[@GuyInaQ]

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.

[@sahumalvika]

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

[@QlikOfficial]

+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.

[@sahumalvika]

I have posted my query on the community but haven't got any response so far. :(

[@vladionescu]

did you find an answer to this?

[@apaczuski]

i just had this question too and i found a way at community.qlikview.com/thread/59477 but by changing : {"

[@AshokKumar-so4th]

Very good Explanation

[@silvaa66]

Hi Michael could you do a video about intervalmatch and agregation?

[@QlikOfficial]

+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

[@chirayuchaudhari1990]

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.

[@GuyInaQ]

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!

[@berrinnazonsiper]

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).

[@QlikOfficial]

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.

[@alejandraalvaradoalegria7839]

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?

[@GuyInaQ]

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.

[@aquabestindian]

Nice video.. Please help in creating a 12-month rolling chart so that whenever I look at it, it shows previous 12 months

[@GuyInaQ]

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.

[@davydwes]

Omg, that's clarify everything to me.

[@jjrdiazu]

Hello..Can you show an example about a Top 10 of sales? I need to show a top1000 of bigdata about banking..

[@GuyInaQ]

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

[@anilkumarrai6913]

Clearly explained...

[@NaamaMoo]

thank you Michael!

[@Vlfkfnejisjejrjtjrie]

awesome tutorial! thanks.

[@1davidbe]

Good information Thank you !

[@alexsandoval7636]

Excelente me ha servido mucho.

[@calzalindo]

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.

[@GuyInaQ]

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. :-)

[@HappySoaringParaglidingTour]

Great. Thanks a lot

[@Tyrexzdeh5432]

Nice and Thank You..

[@silvaa66]

Amazing even to the experts!

[@anant1236]

thanks very useful!

[@nazumcnaz1207]

hi there, how do i Abbreviate money labels (i.e. $10,000,000,000,000 -> $10T) ?? on qlik sense.

[@QlikOfficial]

Hello +Nazu Mcnaz - please post questions such as these on the Qlik Community. community.qlik.com

[@deepalisharma1327]

Didn’t understood the use of $ expansion

[@GuyInaQ]

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.

[@AkhileshKumar-cc8qq]

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

[@nawaazr5388]

From the tutorial I think it should be: Sum({$}color_code)

[@sharmaineebuenga9264]

Thank you for this video. Looking forward for more Qlik tutorial video for beginners like me. :)