topic Re: Max in pivot table in QlikView

Max in pivot table

Wed, 25 Nov 2020 16:16:04 GMT

Hi every one,

Cd Pid txt year Id max(sales)

E 1872 C 1 111 1000

E . 1872 C 1 222 20000

Above is pivot table. I need max(sales) from the above.

Result:

E 1872 C 1 222 2000

Thanks

miguelbraga — Wed, 25 May 2016 15:13:03 GMT

Hey there,

I guess there is a problem between your pivot table and your desired result.

Regards,

sunny_talwar — Wed, 25 May 2016 20:44:51 GMT

Where are you looking to get that row in? Pivot table itself or in a text box object?

May be like this in the pivot table:

If(Max(Sales) = Max(TOTAL Sales), Max(Sales))

Assuming Cd, Pid, txt, year, Id are all dimensions.