QlikSense tutorial: How automatically select top-ranked values using buttons & sliders in QlikSense

[@thinkmetrics]

🎓 Get the Qliksense masterclass : www.thinkmetrics.se/masterclass
📕 Get the Formula CheatSheet: www.thinkmetrics.se/cheatsheet

[@thinkmetrics]

Sorry about the audio in the beginning. It gets better after minute 6. Thanks !

[@ekthajain]

I see that buttons r effective throughout d sheet..wat if I want to constrained buttons to particular chart or table

[@srinivaschowdaryraavi7790]

Thanks Kaushal... please keep on doing this...This will helps a lot.

[@thinkmetrics]

Thanks :)

[@ekthajain]

Thanks for video ...can you help us with video where I can give tooltips on vizlib bar charts

[@ekthajain]

And it would be helpful if you can upload a clear video..bz it's mostly seems to be blur

[@thinkmetrics]

👍

[@padmininagarajan5250]

Hi Kaushal, Great videos on qliksense. I have a question on how to deal with the rankings if two or more countries (in your example) have the same ranking?

[@thinkmetrics]

Thanks. Good question I need to check up on that. Should be alphabetical but will look into it.

[@mohddanial9655]

Thank you. A very good approach. However I have a problem with field value that have space in it. i.e customer name ‘Carlos Funde’. If I use ‘(‘………….’)’ the name that have space cannot be display.

[@thinkmetrics]

👍

[@harishkumarj5535]

for 1st time filtering works fine.Then, if I drag the slider to greater values(eg:10 to 12) and click the button. the previous selection is limiting (only upto 10) and not increasing without clearing the selections. Is this Expected?........And thanks for this video :)

[@rams_stuff]

Thanks Kaushal..

[@thinkmetrics]

👍🏻

[@Priyapandiyan2489]

Hi Kaushal, Excellent Videos. I have a question, how to limit names in the bar chart i am not talking about limiting with top 10 or bottom 10, If list of mixed names in the bar chart x axis for ex: carrot, apple, beans, potato, orange etc.. i want to show only fruits in the x axis. I dont want to use filter.

[@thinkmetrics]

Hmm interesting question. Maybe if you have another field which tells whether it's fruits or vegetables, then you can use a set expression in your measure saying show only fruits?

[@Purna_naidu]

What are the common errors that encounters while loading the data,how to resolve those.

[@kannekanti]

if rank is same on sum of sales ?

[@Purna_naidu]

Thanks kaushal,very usefull and interesting stuff.

[@thinkmetrics]

Thanks

[@Footy_chronicles]

Hi kaush i hae foolwed your tutorial it was smooth for the top but i am having a challenge with the bottom everytime i add my vaiable Vmaxrank it brings expression error: Nested agreegation not allowed, did anyone also experience this and what could be the problem be.

[@asavelam1458]

Hello Kaushal, I have a question I have a table with sales amounts per month for each year and for each year I want to highlight the maximum sales value

[@Footy_chronicles]

colour by expresion and say it should colour the maximum sales value

[@Purna_naidu]

Make a video on YTD & MTD using toggle button

[@sunithaathmuri4552]

Hey Kaush.Thanks for this video..great stuff .looking forward to more videos.
I am new to qliksense..I want to know how to fetch top 10 records and last 10 records in a table .(I have total 5000 records)

[@sunithaathmuri4552]

And there is no chance for aggr..

[@thinkmetrics]

@@sunithaathmuri4552 HI, You can use rank without an aggr as well. Let me know if it works or send me an email n i'll help out.

[@sunithaathmuri4552]

@@thinkmetrics finally got first 10 records ..using your top 5 formula excluded aggr as u said..='('&concat(distinct {} ID, '|')&')' .Thank you so much for your inputs.

[@thinkmetrics]

Great that it worked

[@pareshrahool3048]

Thank you so much 💌

[@thinkmetrics]

🙏

[@Purna_naidu]

Please make more videos on scripting.just a request.

[@thinkmetrics]

Will do