Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

how to show the proportion when I click USA of the Region ?

Hi ,All. From the char sales per region,We can see that USA is 26.9%,but when i click USA in the Region ,it shows100%.How to make it shows 26.9%? Thanks!

cc.png

dd.png

4 Replies
MVP
MVP

Re: how to show the proportion when I click USA of the Region ?

Hi

Try this expression

=Sum(Sales)/Sum({<Region=>} TOTAL Sales)

Hope this helps you.

Regards,

Jagan.

Not applicable

Re: how to show the proportion when I click USA of the Region ?

Hi,I try ,but it doesnot work

MVP
MVP

Re: how to show the proportion when I click USA of the Region ?

Hi,

When you hover it will show 26.9 %.  If you want to test, check it in a Text object.

Regards,

Jagan.

ankitaag
Contributor III

Re: how to show the proportion when I click USA of the Region ?

Hi,


What expression you are using.

If you filter something then obviously for a particular region it will show 100%.

You need to ignore the filter selection for this particular chart. You can use {1} but this will ignorre all the other filter selection also. If you want just 1 filter selection i.e., Region filter to be ignored, then kindly write the exporession you are using.

Thanks and Regards,

Ankita