Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
L_Hop
Creator
Creator

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
Champion
Champion

Hi,

take a look at this, you have multiple solution

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

zebhashmi
Specialist
Specialist

try this

Dim

=ValueList('Total')

Measure

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

L_Hop
Creator
Creator
Author

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
Specialist
Specialist

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

zebhashmi
Specialist
Specialist

=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
Creator
Creator
Author

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