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 to have 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)
3 Replies
dineshkumar
New Contributor III

Re: Percentage calculation by Set Analysis

hi martha,

   its actually showing in proper manner. if there is any sub category of your dimension it is possible , share your qvw.

Re: Percentage calculation by Set Analysis

This question is duplicated (and possibly answered) here: Percentage calculation by Set Analysis

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.