Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

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

1 Solution

Accepted Solutions
nagaiank
Valued Contributor III

Re: Calculate Partial Max, Average in Pivot table

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

There may be other solutions also.

Hope this helps.

2 Replies
nagaiank
Valued Contributor III

Re: Calculate Partial Max, Average in Pivot table

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

There may be other solutions also.

Hope this helps.

Not applicable

Re: Calculate Partial Max, Average in Pivot table

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