topic Problem with Set Analysis in QlikView

Problem with Set Analysis

Fri, 18 Feb 2011 16:08:52 GMT

Hi all,

I would like to use a set analysis, which deactivates 4 selection fields, so that neither of them does impact the chart results.

I am using the following syntax:

(sum({$<Year =,[Region]=,[Area]=, [Country]=>}_revenue) .

It works for Year, Region & Area, but it is not applied for country.

Would be great if you could help me out on this one.

Thanks,

Adi

Fri, 18 Feb 2011 16:13:14 GMT

How works this one?

{<Year=, Region=, Area=, Country=>}

Fri, 18 Feb 2011 16:29:14 GMT

Hi,,

infact, it gives me the same problem, it works for the first three, but not for the country 😞

Any other ideas?

alboreal — Fri, 18 Feb 2011 17:41:12 GMT

Only about 'Country'? And if you change the order?

Fri, 18 Feb 2011 18:26:21 GMT

Yes, only for country. I tried to change the order and it does not work either.

Then I thought it might be related to the fact that I have modified the field to exclude some countries from the selection box:

= if([Reporting Entity] <>'AUT' and [Reporting Entity]<>'ESPT' ,[Country])

Label = Country

but I am doing a similar modification in the selection box for region and area and it still works....

Fri, 18 Feb 2011 23:13:08 GMT

It Seems, that the issue is really linked to the fact, that I am using an if condition

= if([Reporting Entity] <>'AUT' and [Reporting Entity]<>'ESPT' ,[Country])