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