topic Re: Fractile function in QlikView

Fractile function

Wed, 25 Nov 2020 16:16:04 GMT

Hello I have this expression

num(fractile(sum({<[Indicator ID]={236}>} Numerator/Denominator) /1000,'0.25),'##.00 %')

but I dont know why it is not working and I have made four others like it each with the previous column removed and the fractile changed for example 0.25 becomes 0.5 then 0.75 and sp on can anyone either explain this or help me solve this.

Thanks for any help

Re: Fractile function

sunny_talwar — Wed, 11 May 2016 17:58:19 GMT

fractile and sum are both aggregation functions and cannot be combined without an Aggr() function. May be provide a sample with expected output and we might be able to help you better

Re: Fractile function

Clever_Anjos — Wed, 11 May 2016 18:22:58 GMT

I can see a small apostrofe there just before 0.25, maybe this plus stalwar1‌ recommendation

num(fractile(sum({<[Indicator ID]={236}>} Numerator/Denominator) /1000,'0.25),'##.00 %')