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

Announcements
Join us in Toronto Sept 9th 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))