Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
josielaidlaw
New Contributor II

Count data

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!

1 Solution

Accepted Solutions
MVP
MVP

Re: Count data

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

Capture.PNG

 - Uncheck 'Suppress zero-values' in presentation tab

 - Check 'Show all values' in dimension tab

 - Check 'Suppress when value is null'

1 Reply
MVP
MVP

Re: Count data

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

Capture.PNG

 - Uncheck 'Suppress zero-values' in presentation tab

 - Check 'Show all values' in dimension tab

 - Check 'Suppress when value is null'