Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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.

1 Reply
erichshiino
Partner - Master
Partner - Master

Go to your chart -> Properties ->Dimensions.

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