Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Pivot Table Total Error

i

Spoiler
Hi

I am getting error in pivot table and trying to use below formula but getting 0 value. Please help me where i am getting wrong.

(-sum(Aggr(Sum (Distinct ([QUANTITY] * [Unit Cost])),(distinct {< [SOURCE]={'Move order'}>}))))

+

(-sum(Aggr(Sum (Distinct ([QUANTITY] * [Unit Cost])),(distinct {< [SOURCE]={'Account alias'}>}))))

+

(-sum(Aggr(Sum (Distinct ([QUANTITY] * [Unit Cost])),(distinct {< [Transaction Type]={'HP Move Order Return'}>}))))

+

(-sum(Aggr(Sum (Distinct ([QUANTITY] * [Unit Cost])),(distinct {< [Transaction Type]={'HP Issue Expired Items'}>}))))

+

(-sum(Aggr(Sum (Distinct ([QUANTITY] * [Unit Cost])),(distinct {< [Transaction Type]={'HP Miscellaneous Issue'}>}))))




1 Reply
Highlighted
Partner
Partner

You have a sample app?

AGGR() parameters should be :

aggr(<measures>,[<dimension1>,<dimension2>,etc])