Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
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
Highlighted
MVP
MVP

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'

View solution in original post

1 Reply
Highlighted
MVP
MVP

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'

View solution in original post