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: 
Not applicable

Hi,

   Hi,

I have 5 expressions,i want to show that 5 expressions in one chart by using cyclic or anything but 4 expressions should be largest 5 values and remaining 1 expression should be smallest 5 values.can any one explain the logic for this??  please do the needful..

Thanks & Regards,

Ramakrishna

2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Change your expressions to return the correct 5 values. You can use the rank function for this. Something like if(rank(sum(Value))<=5, sum(Value)) for the top 5 and for the bottom 5 if(rank(-sum(Value))<=5, sum(Value))


talk is cheap, supply exceeds demand
Not applicable
Author

Hi Gysbert,

     Thanks for the reply,

Best Regards,

Ramakrishna