Return MAX MIN AVG FROM PIVOT TABLE

[theboss-123]

Hello 

i have a technical question, i need to show the max ,min and average of data showed in pivot table is that possibe ?

[Oleg_Troyansky]

Hi! 

Everything is possible, but the specifics of getting it done might differ...

QlikView Pivot Table doesn't allow to modify the Total functions (like the Straight Table does), so you might have to get more creative - for example you could add extra columns and calculate your averages, minimums and maximums there, using an AGGR function.

For example, if the Chart shows 3 dimensions - Dim1, Dim2, Dim3, and you wanted to see averages of sum(Sales) by Dim1, you'd need to do something like this:

AGGR(

     Avg(

          AGGR(sum(Sales)

          , Dim1, Dim2, Dim3)

     )

, Dim1)

Cheers,

[theboss-123]

Hello i would like to thank you for your response ,tell me please where i can put 

AGGR(

     Avg(

          AGGR(sum(Sales)

          , Dim1, Dim2, Dim3)

     )

, Dim1)

  

[Brett_Bleess]

Here are some further links that should help:

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/ChartFunctions/...

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/ChartFunctions/...

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/ChartFunctions/...

https://community.qlik.com/t5/Qlik-Design-Blog/Average-Which-average/ba-p/1466654

https://community.qlik.com/t5/Qlik-Design-Blog/Dates-in-Set-Analysis/ba-p/1472511

Hopefully those will help.  If you wish to search the Design Blog area further, use  the following link:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Realized the following might be useful too:

https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822

Regards,
Brett