Discussion board where members can get started with QlikView.
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?
Go to Solution.
Maybe create another field in the Sales table:
autonumber(Model) as SalesModelNum
Then do a count(distinct SalesModelNum) in your chart expressions.
Stefan's advice is spot on. You should ever count key fields as the results will be unpredictable.