Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Finding the median of the max daly result per month

Hi,

I would like to have a bar chart that shows the monthly result of the Median of the Maximum daily results.

I.e Consider I have data that that have the time stamp and the performance resut. First, I would like to calculate the max for each day, then I would like to know the monthly median of all these daily max. These "monthly median of the daily max" are to be plotted in a chart or a table.

Can I use set analysis for this? I have been cracking my brains and trying to search online but to no avail. I would really appreciate the help.

Thank you all in advance.

Tags (1)
1 Reply
Not applicable

Re: Finding the median of the max daly result per month

I know how to do it using SQL scripts, but how do i do that in qlik sense?

Community Browser