Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have a bar graph where my dimension is the following to make 30 min time buckets create_time
My measure is
Which will give me the totals for each time bucket and it works.
Now I want to display the highest total using the KPI chart type and for the life of me can't figure out the formula I need.
I suggest creating this in the script
LOAD class(create_time,60*30) as create_time_class
and then this
View solution in original post
We're hoping to avoid that and use class as its more flexible and we could adjust the size of the buckets with out re-loading the data.
Would you be able to share a sample to play around with?
I'm new to this. It's an internal application and I'm unsure of other ways to share a sample.
Mock up data which is close to your real scenario
Oh. Very simply broken down the following table has create time in seconds.
It should results in a graph that has 2 in the first column, 1 in the second and 3 in the third.
The KPI should display the maximum count for those buckets in this case 3.