Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

USage of TOTALfunction in Set analysis to calculate %ge

Hi Experts,

I have an expression like this...

Amount = sum({$<product_groupSector='DTC Assets'}>AMTSector)

I want to calculate the total%ge for above. I know about TOTAL() function but can any one write here how to use it in this expression.

Thank you

1 Reply
sunny_talwar

May be this:

Sum({$<product_groupSector='DTC Assets'}>AMTSector)/Sum(TOTAL {$<product_groupSector='DTC Assets'}>AMTSector)