Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
MarioCenteno
Creator III
Creator III

Group repeated data in bar graph

I need to group how many times values ​​are repeated to zero in a client and show it in a graph. The period is from January to December, meaning that a customer can have a value at zero 1 to 12 months.

I want to show my dimension from 1 to 12 times in the year

Expression

COUNT({<[CSMO_ACTUAL]={0}>}CICLO)

Labels (2)
4 Replies
dwforest
Specialist II
Specialist II

should work with customer as dimension and Include zero values in Data Handling Add-Ons property of graph

MarioCenteno
Creator III
Creator III
Author

It is not what I need, in the dimension I want to show the N occasions that the value to zero is repeated.

dwforest
Specialist II
Specialist II

COUNT({<[ClientID]={"= [CSMO_ACTUAL]=0 and Previous([CSMO_ACTUAL]=0"}>} CICLO)
MarioCenteno
Creator III
Creator III
Author

It still does not work, I need to leave the graph as in the following image from 1 to 12 times.

qlik 2.pngQLIK.png