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.

[@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!

[@rambabubollipalli661]

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

[@riteshkothari1647]

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

[@shinimannan]

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

[@ramchandrapai4228]

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

[@RandallPorter03]

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

[@JamesWilliams-ww6si]

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

[@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

[@nobomopo]

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

[@ManoharSingh-ht5vs]

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

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

[@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?

[@sharmaineebuenga9264]

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

[@adanyoshimoto7504]

Awsome explanation! Thanks in Advance!

[@Jenicek25]

Very clearly explained, thanks !!

[@aliakhan3185]

Very helpful video, learned lots of tips.

[@philipmeric8659]

good job

[@GuyInaQ]

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

[@hk3172]

Excellent vid. Thanks for sharing

[@maximilianmb485]

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

[@AshokKumar-so4th]

Very good Explanation

[@sarahelaine0714]

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

[@KayYesYouTuber]

Nice video. You demystified $ expansion for me. Thanks

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

[@davydwes]

Omg, that's clarify everything to me.

[@oscarob58]

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

[@anilkumarrai6913]

Clearly explained...

[@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

[@NaamaMoo]

thank you Michael!

[@Vlfkfnejisjejrjtjrie]

awesome tutorial! thanks.

[@1davidbe]

Good information Thank you !

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

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

[@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 : {"

[@alexsandoval7636]

Excelente me ha servido mucho.

[@justice3171]

thank you for video ! but where are others videos?

[@QlikOfficial]

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

[@silvaa66]

Amazing even to the experts!

[@Tyrexzdeh5432]

Nice and Thank You..

[@HappySoaringParaglidingTour]

Great. Thanks a lot

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

[@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

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

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

[@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

[@anant1236]

thanks very useful!

[@247365v]

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

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

[@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!

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

[@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

[@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)

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

[@sharmaineebuenga9264]

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