Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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