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

total value

onur yilmaz Mar 7, 2018 8:23 AM

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.

Re: total value

youssef belloum Mar 7, 2018 8:34 AM (in response to onur yilmaz)

Hi,

take a look at this, you have multiple solution

how to show total bar as first bar in bar chart in qlikview
Like Show 1 Like (1)

Actions
Re: total value

Jahanzeb Hashmi Mar 7, 2018 8:51 AM (in response to onur yilmaz)

try this
Dim
=ValueList('Total')
Measure
if(Valuelist('Total') = 'Total',Sum(G)+Sum(NG))
Like Show 0 Likes (0)

Actions
- Re: total value
  
  onur yilmaz Mar 7, 2018 9:19 AM (in response to Jahanzeb Hashmi)
  
  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.
  
  Like Show 0 Likes (0)
  
  Actions
  - Re: total value
    
    Jahanzeb Hashmi Mar 7, 2018 9:37 AM (in response to onur yilmaz)
    
    I think you can show all three have you given a try?
    
    Like Show 0 Likes (0)
    
    Actions
    - Re: total value
      
      Jahanzeb Hashmi Mar 7, 2018 9:39 AM (in response to Jahanzeb Hashmi)
      
      =ValueList('Total','G','NG')
      if(Valuelist('Total','G','NG') = 'Total',Sum(G)+Sum(NG),if(Valuelist('Total','G','NG') = 'G',Sum(G),Sum(NG))
      
      Like Show 1 Like (1)
      
      Actions
      - Re: total value
        
        onur yilmaz Mar 7, 2018 9:55 AM (in response to Jahanzeb Hashmi)
        
        Many thanks for the prompt reply, this worked perferctly for me.
        
        Like Show 0 Likes (0)
        
        Actions

Go to original post