2 Replies Latest reply: Jun 6, 2011 9:46 PM by garricklam RSS

    Calculate Partial Max, Average in Pivot table

      Hello all, I am new to QlikView. My dimensions are RefID, Product{A,B}, Action{Buy,Sell} 

      • I want to find the max, min, avg of each column (excluding RefID=std), should I use Aggr or SetAnalysis combine with If statment?
      • Besides, can I combine the Chart F(x) to Chart Price?

       

      Thank you so much

      sumtest.jpg