Qlikview general Left Join issue

Mon, 18 Apr 2011 10:03:55 GMT

Hello,

Just the general issue that may be it is not an issue right now but so far I really have problem to displaying Qlikview result in the manner of left join. Say I have 10 customers which bought from us in 2010, if I would like to breakdown Turnover quarterly base Q1 - Q4 and displaying them in Pivot Table, Dimension are Customer and Quarter, Expression is Sum (Turnover), if customer A just bought on Q1 and Q3 and selection is done only this customer then I will see result set only Q1 and Q3, the Q2 and Q4 will gone off from result.

Is there a way to see all Quarter regardless of whether or not the customer bought in that period?

Thanks a lot for any suggestion.
Utis.

Qlikview general Left Join issue

erichshiino — Mon, 18 Apr 2011 11:25:01 GMT

Go to your chart -> Properties ->Dimensions.

Set 'Show all values' for the dimension you want.

topic Qlikview general Left Join issue in QlikView

Qlikview general Left Join issue

Qlikview general Left Join issue