total value

[L_Hop]

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.

Please suggest any appropriate solution...

Thanks.

OY

[YoussefBelloum]

Hi,

take a look at this, you have multiple solution

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

[zebhashmi]

try this

Dim

=ValueList('Total')

Measure

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

[L_Hop]

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]

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

[zebhashmi]

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

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

[L_Hop]

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