Count data

[josielaidlaw]

Hi! I have some data, and I would like to graph the instances something happens over time. However, I just want to count the instances, not what their actual data is.  The column has numbers, and zeros are the numbers I don't want to count. I have looked into adding a calculated dimension, but I don't really understand, because I think what I am trying to do is quite easy, but I cannot figure it out. I am using Qlikview Personal so I cannot attach my file, but here is a sample of the data below.

MonthYear                 AFT

Oct 2018                     15

Nov 2018                     0

Dec 2018                     2

Dec 2018                     6

Jan 2019                     4

Feb 2019                      0

So, the graph would have MonthYear along the bottom, and have 1 for Oct , 0 for Nov, 2 for Dec, 1 for Jan, 0 for Feb, etc

Thanks in advance!

[tresesco · Accepted solution]

Count({<AFT-={'0'}>}AFT)

 - Uncheck 'Suppress zero-values' in presentation tab

 - Check 'Show all values' in dimension tab

 - Check 'Suppress when value is null'