Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Not applicable

Pivot Table _ Total Price

Hi my friendsPivot.jpg.

i want to use this total price i another expression fo each group.

what can i do?

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Pivot Table _ Total Price

Use aggr( sum(Budget), Costnumber) to get the totals of sum(Budget) per Costnumber


talk is cheap, supply exceeds demand
2 Replies
MVP & Luminary
MVP & Luminary

Re: Pivot Table _ Total Price

Use aggr( sum(Budget), Costnumber) to get the totals of sum(Budget) per Costnumber


talk is cheap, supply exceeds demand
renjithpl
Valued Contributor

Re: Pivot Table _ Total Price

Use aggr() 

=sum(aggr(max(Value),CustNum))