Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

amars
Valued Contributor

Percentile calculation for every month

Hi everybody,

I have a database, in which I need to calculate the Percentile for every month's end date. I don't know how to do that. Please suggest how to do that?

Thanks in advance.

2 Replies
Not applicable

Percentile calculation for every month

Hi Amar,

Calculate day's up to last day of every month. Then apply calculation.

amars
Valued Contributor

Percentile calculation for every month

Fractile(Value, 0.95) in a group by clause did the thing.

Thanks.

Community Browser