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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
joybratas1
Contributor II
Contributor II

Aggregation with Fractile in Chart Expression not working

Hi Community, 

I have been struggling in creating a logic for my table as well as Map expression. 

My expression looks somewhat like

sum(aggr({index= {"<=$(vIndex) >"} Fractile(hours, 0.95) ,index)) 

My aim is to sum the 95th percentile hours for each index that is greater than (vIndex) 

 

But this don't work. 

Please help me in this. 

Labels (1)
1 Reply
Mario_De_Felipe
Luminary
Luminary

The right format for your expression is: sum(aggr(Fractile({<index= {"<=$(vIndex)"}>} hours, 0.95) ,index))