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?
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 :)
I was trying to follow your tutorial but seem to get stuck when I use the function for the button. It seems to only return customer names without spaces - which seperator should I use instead?
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.
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?
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
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.
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.
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)
@@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.
🎓 Get the Qliksense masterclass : www.thinkmetrics.se/masterclass
📕 Get the Formula CheatSheet: www.thinkmetrics.se/cheatsheet
Thanks Kaushal... please keep on doing this...This will helps a lot.
Thanks :)
Sorry about the audio in the beginning. It gets better after minute 6. Thanks !
I see that buttons r effective throughout d sheet..wat if I want to constrained buttons to particular chart or table
Thanks kaushal,very usefull and interesting stuff.
Thanks
Thanks Kaushal..
👍🏻
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?
Thanks. Good question I need to check up on that. Should be alphabetical but will look into it.
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 :)
I was trying to follow your tutorial but seem to get stuck when I use the function for the button. It seems to only return customer names without spaces - which seperator should I use instead?
Hi. Thats strange. Do you have other dimensions other than customer? That could be a reason.
Can you send me more info?
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.
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?
Thank you so much 💌
🙏
Thanks for video ...can you help us with video where I can give tooltips on vizlib bar charts
And it would be helpful if you can upload a clear video..bz it's mostly seems to be blur
👍
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
colour by expresion and say it should colour the maximum sales value
What are the common errors that encounters while loading the data,how to resolve those.
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.
👍
Make a video on YTD & MTD using toggle button
if rank is same on sum of sales ?
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.
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)
And there is no chance for aggr..
@@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.
@@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.
Great that it worked
Please make more videos on scripting.just a request.
Will do