topic Re: Max and min value from pivot table in QlikView

Max and min value from pivot table

Mon, 05 Jan 2015 13:54:07 GMT

Hi everybody! I need calculate the max and min value of a pivot table.

For example:

Date Import

02/02/2020 200

03/03/2020 0

04/04/2020 50

05/05/2020 500

06/06/2020 0

Import is an expresión: sum(Sales)

In this case:

max: 500

min: 50 (without zero)

I tried with differents expresións but it don't work.

Thank you!!

Re: Max and min value from pivot table

alexandros17 — Mon, 05 Jan 2015 13:56:19 GMT

Could you send an example document?

Re: Max and min value from pivot table

rubenmarin — Mon, 05 Jan 2015 13:59:35 GMT

Hi andres, where you want to show your max and min values?

In example, for a text box it can be:

Max Value: =Max(Aggr(Sum(Import), Date))

Min Value: =Min(Aggr(If(Sum(Import)>0, Sum(Import)), Date))

Re: Max and min value from pivot table

ecolomer — Mon, 05 Jan 2015 14:01:43 GMT

See this example

You can see the max and the min value for each branch

Re: Max and min value from pivot table

Mon, 05 Jan 2015 14:13:12 GMT

Max Value: =Max(Aggr(Sum(Import), Date)) ---> It shows all in zero

Min Value: =Min(Aggr(If(Sum(Import)>0, Sum(Import)), Date)) ------> It shows all with "-"

I want to show the max and min values in the pivot table, as an expresión.

I attached the file qvw.

Re: Max and min value from pivot table

rubenmarin — Mon, 05 Jan 2015 14:17:44 GMT

Hi Andres, those expressions were to put in a text box.

You want to show max and min values in the same pivot table? how? a column with the min and other with the max? only show the dates with the min and the max values?

Re: Max and min value from pivot table

Mon, 05 Jan 2015 14:22:33 GMT

I need to show max and min values in the same pivot table. One column with the min and other with the max

Re: Max and min value from pivot table

rubenmarin — Mon, 05 Jan 2015 14:27:50 GMT

Not sure if this is what you want, please check attachment

Re: Max and min value from pivot table

Mon, 05 Jan 2015 15:00:23 GMT

Great! It work now! Thank you!!