Calculate Partial Max, Average in Pivot table

[#1]

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 · Accepted solution]

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

There may be other solutions also.

Hope this helps.

[#3]

thank you krishnamoorthy,

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