topic Re: Sales vs Recommended Sales in QlikView

Sales vs Recommended Sales

dmac1971 — Mon, 25 Jan 2016 10:06:18 GMT

Have what should be a simple scenario that I may need a little direction on.

Lets say I have 3 data sets, sales of cars, sales of spares, and a list of what we expect sales to be, ie recommended parts sales.

I have these loaded into a QV document and want to be able to show all spares sales by country etc. This is of course very easy. I then want to show what I expect the sales to be for the car population, again easy, however when I filter by country the expected list shortens, I want to show all spares regardless if they have sold or not, or if the car has sold in that country or not etc.

Any pointers gratefully accepted!!!

Re: Sales vs Recommended Sales

swuehl — Mon, 25 Jan 2016 10:10:46 GMT

Something like attached? Using Car and Rec Part as dimensions in a chart and as expression

=Sum({1}[Qty Per Car])

Re: Sales vs Recommended Sales

sunny_talwar — Mon, 25 Jan 2016 10:11:00 GMT

You have all table boxes in your attached qvw, are you trying to do this in a table box object? I think you might be better off doing this in a straight table by using set analysis for spares' expression. Something like this:

Only({<Country>} Spares)