Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
nikhilgarg
Specialist II
Specialist II

Error in Script !!

HEy,

I want Sum Of values for customers whose values is greater than 1000.

I ahve used following expression , but nothing comes in starightt able.

What to do ??

Sum({<Customers = {"=rank(Sum(Values),4)>= 1000"}>}Values)

Thanks

13 Replies
maleksafa
Specialist
Specialist

the interactive sort will allow the user to change the sort by double clicking on the column name, in your case the sorting is done based on total sales ascending order, now if the interactive sort is checked you can go to your chart and double click on the sales column (on the label name) and you will see that the sorting will change from ascending to descending. if you want to disable this feature you should uncheck the interactive sort option.

nikhilgarg
Specialist II
Specialist II
Author

Hey ,

Thanks. Got the point.

Are you on Linkedin ?

maleksafa
Specialist
Specialist

sure, Malek safa from lebanon.

nikhilgarg
Specialist II
Specialist II
Author

Hey thanks and on whatsapp?