Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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))