Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Percentage calculation by Set Analysis

I have this

Percentage calculation.png

And the Mesure is calculated by

Sum(SaleAmount)/SUM(total SaleAmount)

But what I really want is that each category has its own 100%, and not the 100% of all the categories

Does anyone knows how to do it by Set Analisys?

Thanks

MAC

Tags (1)
2 Replies

Re: Percentage calculation by Set Analysis

Hi Martha, if the x-axis dimension is 'Category' you can use this expression:

Sum(SaleAmount)/SUM(total <Category> SaleAmount)

MVP
MVP

Re: Percentage calculation by Set Analysis

Hi,

Check this expression

Sum(SaleAmount)/SUM(TOTAL <Category> SaleAmount)


Note: Replace Category with your actual field name.


Hope this helps you.


Regards,

Jagan.

Community Browser