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: 
gfisch13
Creator II
Creator II

Bar Chart Analysis

Hi Everyone - I'm new to Qlikview and trying to do more advanced stuff than I probably should.  In the attached I have a summary of certain numeric fields by my 3 regions, Americas, EMEA, Asia.  I'd like to add a 4th Region that is an aggregation of all the regions, but I'm unsure how to set that up.  Any help would be appreciated!

Thanks,

George

1 Solution

Accepted Solutions
maxgro
MVP
MVP

sum(AMOUNT_AT_RISK_USD) + sum(AMOUNT_PREVENTED_USD) + sum(AMOUNT_RECOVERED_USD)

View solution in original post

6 Replies
satishkurra
Specialist II
Specialist II

Try Using 4th expression as

Expression 4 for all Regions: Expression 1 + Expression 2 + Expression 3

Thanks

Satish

gfisch13
Creator II
Creator II
Author

Hi Satish - that is what I want to do, but I'm confused as to how to add that expression and where.  If I try to add another expression, bringing up the Edit Expression box, I'm stumped on what to do next.  Like I said, I'm really new to Qlik, learning fast!

Thanks!

Anonymous
Not applicable

Hi George,

You have already created 3 expressions, each one have a name in QV so as Satish suggested you can just sum them.

See below a visual exemple: i have create 2 expresssions Vente & Marge

Then i create third one justing typing in my expression window: Vente + Marge and it just works.

ScreenShot007.png

Hope this clarify better with an image.

satishkurra
Specialist II
Specialist II

Please share your application. I will update and provide...

maxgro
MVP
MVP

sum(AMOUNT_AT_RISK_USD) + sum(AMOUNT_PREVENTED_USD) + sum(AMOUNT_RECOVERED_USD)

gfisch13
Creator II
Creator II
Author

Thank you - that worked  and I understand what I did.  Now I want to aggregate all three regions that I show above into separate bars called 'All Regoins' - would that be another dimension??  I'm not sure how to represent that.  Instead of 3 sets of bars I want to see 4...........Thanks!