Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

paulyeo11
Valued Contributor II

Bar chart how to display sales amount and % contribution in QS

Hi All

I have a Bar chart , i like to display 1 Bar show the sales amount , and below the bar show the % contribution.

In QV i have use the same expression , just tick on relative. it will work.

But in QS i am unable to make it.

Paul

1 Solution

Accepted Solutions
Not applicable

Re: Bar chart how to display sales amount and % contribution in QS

Try:

Sum(MeasureName)/Sum(TOTAL MeasureName)


This should give the relative percentage split.

4 Replies
paulyeo11
Valued Contributor II

Re: Bar chart how to display sales amount and % contribution in QS

my QVF

Not applicable

Re: Bar chart how to display sales amount and % contribution in QS

Try:

Sum(MeasureName)/Sum(TOTAL MeasureName)


This should give the relative percentage split.

paulyeo11
Valued Contributor II

Re: Bar chart how to display sales amount and % contribution in QS

Hi Pravesh

Thank you very much for your help.

Now the % amount indicate in between the 2 Bar , it is possible to set so that % not display between the 2 Bar ? and % display below the % , so that all Bar can be close up and make my chart not so wide.

Paul

paulyeo11
Valued Contributor II

Re: Bar chart how to display sales amount and % contribution in QS

Hi Pravesh

In QV it mean set to "Text on Axis" text on axis.png