Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

display value as of parent column total in table

Hi,

I have a table with 2 columns, one dimension and one measure.

I'd like to display the values of the measure column in % of the column total instead of absolute values.

Can you please help?

Thanks!

3 Replies
ogster1974
Honored Contributor II

Re: display value as of parent column total in table

This should do it.  You just need to use Total in your Sum of value to bring through total value.  From there it is straightforward to derive the percentage.  See attached.

Not applicable

Re: display value as of parent column total in table

Andy, thanks a lot!

is there any way that I can have the % as the second column? Alternatively, can I hide the two columns before (Value by Country, Total Value) used for the calculation?

ogster1974
Honored Contributor II

Re: display value as of parent column total in table

Hi Tamas

You can remove the other columns if you want I just added them so you could see how the calculation was built. Please mark the question as answered if this has been useful

Regards

Andy

Sent from my iPad

Community Browser