7 Replies Latest reply: May 29, 2012 8:35 AM by swuehl RSS

Stack graph not showing all values [with Dimension limits]

agopals22

Stack graph with 2 dimesions say year and product. One expression say sum(amount).

 

Data:

Year     Product     Amount

2010     A               1

2011     A               2

2010     B               3

2011     C               4

2010     D               5

2011     D               6

 

Dimension limits is set to top 2 using sum(amount) as expression.

Sorting is set to Year Desc, Amount Desc

 

a. Year selection = 2010, graph correctly shows:

2010     D               5

2010     B               3

 

b. Year selection = 2011, graph correctly shows

2011     D               6

2011     C               4

 

c. Year selection = 2011, 2010, graph shows

2011     D               6

2010     D               5

2011     A               2

2010     A               1

 

 

It shows only the interesection values. Whereas it should've been -

 

2011     D               6

2010     D               5

2011     C               4

2010     C               0 --------- this should've been understood by Qlikview.

 

How to ensure that the chart displays the correct values - i.e. not just the intersection.

 

Regards,

Gopal