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.
Go to Solution.
I suggest creating this in the script
LOAD class(create_time,60*30) as create_time_class
and then this
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.