Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlikview general Left Join issue

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.

Labels (1)
1 Reply
erichshiino
Partner - Master
Partner - Master

Go to your chart -> Properties ->Dimensions.

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