Count data

josielaidlaw — Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: Count data

tresB — Tue, 19 Mar 2019 08:14:42 GMT

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

- Uncheck 'Suppress zero-values' in presentation tab

- Check 'Show all values' in dimension tab

- Check 'Suppress when value is null'

topic Count data in QlikView

Count data

Re: Count data