6 Replies Latest reply: Mar 7, 2018 9:55 AM by onur yilmaz

# 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.

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

Thanks.

OY

• ###### 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

• ###### Re: total value

try this

Dim

=ValueList('Total')

Measure

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

• ###### 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.

• ###### Re: total value

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

• ###### 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))

• ###### Re: total value

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