topic Re: Numbers In Charts are Not Corresponding in QlikView

Numbers In Charts are Not Corresponding

kaygee28 — Fri, 04 Mar 2016 09:49:19 GMT

Good Day

I have two charts which do not have similar values in them, one chart determines the number of unique values within three sheets and the other calculates total sales within a period

here are the expressions

Chart that displays total unique values per gender

count(distinct{$<[Contact ID] = >}[Contact ID])

the expression to calculate total sales

Count(DISTINCT{$<[Year Purchased]={"*"}-{'Unknown'},[Month Purchased]={"*"}-{'Unknown'}>}[Contact ID])

they should both display the same number of records since each sale is a record on its own

the first expression pulls 113 records and the second expression pulls 139.

How do I fix this?

Thanks in advance.

Re: Numbers In Charts are Not Corresponding

Gysbert_Wassenaar — Fri, 04 Mar 2016 17:22:58 GMT

Check your data. Perhaps there are records where either Year Purchased or Month Purchased is null or Unknown.

Re: Numbers In Charts are Not Corresponding

kaygee28 — Mon, 07 Mar 2016 07:37:03 GMT

Hi Gysbert,

Yes I do have null values in month purchased and year purchased hence I excluded them in both my expressions.

Thanks in advance, but I reckon both expressions should correlate each other from the looks of things.

Hence I'll just look at my data again.

Re: Numbers In Charts are Not Corresponding

Gysbert_Wassenaar — Mon, 07 Mar 2016 07:55:23 GMT

You do exclude them in your second expression but not in your first. That's why they return different results.

Re: Numbers In Charts are Not Corresponding

kaygee28 — Mon, 07 Mar 2016 08:18:17 GMT

I'll have a look at the data and see, but it still doesn't make sense at the moment.

Thanks a lot for your help!!