Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Go to your chart -> Properties ->Dimensions.
Set 'Show all values' for the dimension you want.