Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

chiranjivdas
Not applicable

Difference in Count of Synthetic Key Values

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,

CD

1 Solution

Accepted Solutions
swuehl
Not applicable

Re: Difference in Count of Synthetic Key Values

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.

2 Replies
swuehl
Not applicable

Re: Difference in Count of Synthetic Key Values

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.

rwunderlich
Not applicable

Re: Difference in Count of Synthetic Key Values

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

-Rob