Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Charts: Sum Issue

Hello ,

I'm creating a chart based on the belwo data:

Region      Country         Rev

NAM          US               10

NAM          MEX               5

EMEA        GB                 6

EMEA        GER               9

The issue is that when some body searches the data based on the country the chart is showing the Rev data for that country. For ex: if user searches for Country 'US' the chart shows Rev. number 10,  whereas i alway want the chart to show data at Region Level, i.e it should show 15 for NAM.

How do i achieve this. My chart structure is

Region , Sum(Rev)

----------------------------

Thanks

P

1 Reply

Re: Charts: Sum Issue

HI

Try like this

=Sum({<Country=>} Rev)

it exclude the country selection