Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Using Fractile with a set modifier

Hi all,

I'm using the following expression to work out the upper quartile of my selection:

=Fractile(TOTAL Aggr(Sum(Actual_Utilized_Amount),County), 0.75)

If I select a county, I still want to calculate the upper quartile for all counties, rather than just the selected county. I've tried using a set modifier in my expression but it does not work:

= Fractile({<County = >} TOTAL Aggr(Sum( Actual_Utilized_Amount),County),0.75)

or

= Fractile(TOTAL Aggr(Sum({<County = >} Actual_Utilized_Amount),County),0.75)

What am I doing wrong?

1 Solution

Accepted Solutions
MVP
MVP

Re: Using Fractile with a set modifier

Have you tried

= Fractile({<County= >} TOTAL Aggr(Sum({<County = >} Actual_Utilized_Amount),County),0.75)

2 Replies
MVP
MVP

Re: Using Fractile with a set modifier

Have you tried

= Fractile({<County= >} TOTAL Aggr(Sum({<County = >} Actual_Utilized_Amount),County),0.75)

Not applicable

Re: Using Fractile with a set modifier

That did the trick nicely. Thank you

Community Browser