Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Pivot table ,Unable to caluclate avg in pivot table

Dear all,

I have posted sample data i need pivot table as shown in the image posted here,

Thanks in advance

Vinod

Tags (2)
3 Replies
lvf
Not applicable

Re: Pivot table ,Unable to caluclate avg in pivot table

Hi Vinod

Hope this is still useful - Find attached.

I just build the Average and Total values as expressions.

Not applicable

Re: Pivot table ,Unable to caluclate avg in pivot table

Try this:

=avg( aggr(sum({$<Exports={'Exp2', 'Exp1'}>}Value),Exports,Week ))

Best,

Matt

Not applicable

Re: Pivot table ,Unable to caluclate avg in pivot table

Hi Vinod,

Both of the above solutions work. If you're using either can you mark one as correct and close the post?

Thanks!

Matt