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?

       

      TextCalculation
      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)