Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
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
Highlighted
Not applicable

Percentile calculation for every month

Hi Amar,

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

Highlighted
Valued Contributor

Percentile calculation for every month

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

Thanks.