topic Re: Bar Chart Analysis in QlikView

Bar Chart Analysis

gfisch13 — Thu, 18 Feb 2016 19:01:09 GMT

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

Re: Bar Chart Analysis

satishkurra — Thu, 18 Feb 2016 19:19:25 GMT

Try Using 4th expression as

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

Thanks

Satish

Re: Bar Chart Analysis

gfisch13 — Thu, 18 Feb 2016 19:25:25 GMT

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!

Re: Bar Chart Analysis

Anonymous — Thu, 18 Feb 2016 19:44:45 GMT

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.

Hope this clarify better with an image.

Re: Bar Chart Analysis

satishkurra — Thu, 18 Feb 2016 19:46:00 GMT

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

Re: Bar Chart Analysis

maxgro — Thu, 18 Feb 2016 19:49:03 GMT

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

Re: Bar Chart Analysis

gfisch13 — Thu, 18 Feb 2016 19:57:10 GMT

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!