topic Re: Calculate Partial Max, Average in Pivot table in QlikView

Calculate Partial Max, Average in Pivot table

Sun, 05 Jun 2011 15:54:38 GMT

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

nagaiank — Sun, 05 Jun 2011 19:58:03 GMT

Expressions to arrive at the numbers desired by you are in the attached qvw file.

There may be other solutions also.

Hope this helps.

Tue, 07 Jun 2011 01:46:55 GMT

I have edited the expresson from Max({$<RefID={"1","2","3","4","5"}>} Price) to:

=Max ({$<RefID-={"STD"}>}Price)

in order to support user's selection.

I hope someone can tell me a method to merge those result chart tables into a one pivot table.

thanks