topic Re: Difference in Count of Synthetic Key Values in QlikView

Difference in Count of Synthetic Key Values

chiranjivdas — Tue, 22 Jan 2013 16:56:14 GMT

I have data from two sources:

File Name: Production

File Name: Sales

(please see attached)

I uploaded them and the synthetic Key is Model. In Production, there are 9 values under Model where as in Sales there are only 4. I want a chart to count only 4 Models and not 9. What script should I use in the Expression field?

Thanks,

Re: Difference in Count of Synthetic Key Values

swuehl — Tue, 22 Jan 2013 17:52:16 GMT

Maybe create another field in the Sales table:

LOAD

Model,

Sales,

autonumber(Model) as SalesModelNum

FROM Sales.xlsx;

Then do a count(distinct SalesModelNum) in your chart expressions.

Re: Difference in Count of Synthetic Key Values

rwunderlich — Wed, 23 Jan 2013 07:01:31 GMT

Stefan's advice is spot on. You should ever count key fields as the results will be unpredictable.

-Rob