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: 
iahmadmca1
Contributor III
Contributor III

Calculate the top 10 value

Hi Team,

I am using the expression for calculating the count for a percentage.

The below expression is working fine.

=if([Rolling_7_days.File Date1]='$(VRollCurrentday)',

Rangemax((Sum(Rolling_7_days.Counts)-above(TOTAL sum( Rolling_7_days.Counts ) ))/above(TOTAL sum( Rolling_7_days.Counts ) ),'#,##0.00',0))

but I need top 10 value based on the above expression could you please add the logic in my expression, so that i can get top 10 value in the below screenshot.

TGB.jpg

Thanks,

Irshad Ahmad

0 Replies