Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
March 11, 2PM EST: Do More with Qlik - Getting Started wtih Qlik Sense SaaS - Redux. REGISTER NOW
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

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

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