Count number of cases

[sergio0592]

Hi all,

I'am facing the following problem. I have as input a pivot chart with date and num of hour as dimeniosn and Number of events as expression. The expected output is another chart that counts the number of cases with X events. 

But the difficulty is that i have a field for each num of hour, so 24 differents fields!!

Input:

Ouput:

Any idea about how to achieve this??

Thanks

[dplr-rn · Accepted solution]

looks like you need to do cross table on the input data.

https://community.qlik.com/t5/Qlik-Design-Blog/The-Crosstable-Load/ba-p/1468083

[sergio0592]

Of course, i forgot the famous Cross table statement !! I will try it.