Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

onur0707
New Contributor III

total value

Hello everyone,

I have a bar chart with the dimension of 'TO_GROUP_OF_THIRD_PARTY' which has two values;

G for Group companies

NG for Non-Group companies.

Requirement is they also want to see the total values of G + NG values in bar chart with G and NG values. How can I get a bar chart with dimension of 'TO_GROUP_OF_THIRD_PARTY' and with values 'G','NG','Total'

they want to see the below charts in single bar chart with the dimension of TO_GROUP_OF_THIRD_PARTY.


meausure is sum of quantity.

total.png

Please suggest me any solution if anyone of you gone through the same problem.

 

Please suggest any appropriate solution...

Thanks.

OY

6 Replies
YoussefBelloum
Esteemed Contributor

Re: total value

Hi,

take a look at this, you have multiple solution

how to show total bar as first bar in bar chart in qlikview

zebhashmi
Valued Contributor

Re: total value

try this

Dim

=ValueList('Total')

Measure

if(Valuelist('Total') = 'Total',Sum(G)+Sum(NG))

onur0707
New Contributor III

Re: total value

Hi Jahanzeb, thank you for your kind help.

As far as I understand, suggested code only shows the Total values, but I need all the values(G, NG, Total) in single bar chart.

zebhashmi
Valued Contributor

Re: total value

I think you can show all three have you given a try?

zebhashmi
Valued Contributor

Re: total value

=ValueList('Total','G','NG')

if(Valuelist('Total','G','NG') = 'Total',Sum(G)+Sum(NG),if(Valuelist('Total','G','NG') = 'G',Sum(G),Sum(NG))


onur0707
New Contributor III

Re: total value

Many thanks for the prompt reply, this worked perferctly for me.