topic Re: Fractile(aggr()) Statement in Script in QlikView

Fractile(aggr()) Statement in Script

shahafei2 — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

Can I use Fractile(aggr()) function as part of the load script?

I would like to have the following

Fractile(aggr(sum(Qty),Date),0.9)

When the sales table is grouped by the Item

The purpose is to understand the sales per item in 90% of the days in the data

techvarun — Tue, 13 Aug 2019 09:50:41 GMT

You can use Group by and Fractile combination

shahafei2 — Tue, 13 Aug 2019 10:25:08 GMT

how?

sunny_talwar — Tue, 13 Aug 2019 11:29:39 GMT

Provide some sample data and the output you expect to see from it within the script

shahafei2 — Wed, 14 Aug 2019 08:29:24 GMT

Thank you I succeded to do it by using a grouped table and then resident table