1 Reply Latest reply: Mar 13, 2013 1:01 PM by sushil kumar RSS

    How to filter 1 column based another when creating a chart?

      Sorry for the basic questions - I am really new to Qlikview...


      I have a dataset which includes fields similar to the ones below.  I want to create a table that shows the the sum of the calculated column, but only where Text = 'A'


      Could anyone suggest a good way of doing this?


      A=if(Sum(X)=0,null, Sum(X)/Sum(y)
      A=if(Sum(X)=0,null, Sum(X)/Sum(y)
      B=if(Sum(X)=0,null, Sum(X)/Sum(y)