topic IF-Statement does not show values in QlikView

IF-Statement does not show values

Thu, 01 Sep 2011 14:47:13 GMT

Dear all,

I've created an IF-Statement in a chart:

=if([cpa_Main Article Group Description]='Information Center',

(sum(aggr((sum({<[cpa_Main Article Group Description]={'NICU Monitoring'}>}[cpa_Net Value]*CurrencyRate)/

sum({1<[Old Product Number]={'M8105A','M8001A','M8002A','M8003A','M8004A','M8005A','M8007A','M8008A','M8010A','865240'}>}[cpa_Net Value]*CurrencyRate)*

sum({1<[cpa_Article Group]={1574}>}[cpa_Net Value]*CurrencyRate*0.5)),[cpa_Geo 4],[cpa_Fiscal Month Name],[cpa_Fiscal Year]))),

if([cpa_Main Article Group Description]='Measurements allocated',

(sum(aggr((sum({<[cpa_Main Article Group Description]={'NICU Monitoring'}>}[cpa_Net Value]*CurrencyRate)/

sum({1<[Old Product Number]={'M8105A','M8001A','M8002A','M8003A','M8004A','M8005A','M8007A','M8008A','M8010A','865240'}>}[cpa_Net Value]*CurrencyRate)*

sum({1<[cpa_Article Group]={'1582','1709'}>}[cpa_Net Value]*CurrencyRate*1.0)),[cpa_Geo 4],[cpa_Fiscal Month Name],[cpa_Fiscal Year]))),

sum([cpa_Net Value]*CurrencyRate))))

My Dimension is Year and Article Group.

If I do not select anything it shows me a different Revenue, than selecting the ArticleGroup in the IF-Statement.

Thank you very much for your help

IF-Statement does not show values

Thu, 01 Sep 2011 15:05:02 GMT

if I do not select any Main Article Group, it looks like this one above.

One of the Main Article Groups is missing.

If I do select this Main Article Group it is shown:

Where is the mistake?

IF-Statement does not show values

Thu, 01 Sep 2011 19:07:09 GMT

Can anybody help?

Re: IF-Statement does not show values

ToniKautto — Thu, 01 Sep 2011 20:20:54 GMT

Please look in the expression editor and you will see that there is a syntax error highlighted in line 7, related to usage of an unexisting field.

IF-Statement does not show values

Thu, 01 Sep 2011 20:25:38 GMT

Thanks for your help Toni,

do you mean this line?:

if([cpa_Main Article Group Description]='Medical Consumables and Sensors',

sum({<[cpa_Main Article Group Description]={'Medical Consumables and Sensors'}>}[cpa_Net Value]*CurrencyRate*[Perinatal Factor]),

It's ok, to leave this statement out. I just reduced the data, so it was still stored in. But if I take this partial if-statement out, the problem still exists.

Re: IF-Statement does not show values

johnw — Fri, 02 Sep 2011 00:45:33 GMT

This seems to work (addition in red):

=if([cpa_Main Article Group Description]='IntelliVue Information Center',
(sum(aggr((sum({<[cpa_Main Article Group Description]={'NICU Monitoring'}>}[cpa_Net Value]*CurrencyRate)/
sum({1<[Old Product Number]={'M8105A','M8001A','M8002A','M8003A','M8004A','M8005A','M8007A','M8008A','M8010A','865240'}>}[cpa_Net Value]*CurrencyRate)*
sum({1<[cpa_Article Group]={1574}>}[cpa_Net Value]*CurrencyRate*0.5)),[cpa_Geo 4],[cpa_Fiscal Month Name],[cpa_Fiscal Year]))),

if([cpa_Main Article Group Description]='Medical Consumables and Sensors',
sum({<[cpa_Main Article Group Description]={'Medical Consumables and Sensors'}>}[cpa_Net Value]*CurrencyRate*[Perinatal Factor]),

if([cpa_Main Article Group Description]='IntelliVue Measurements allocated',
(sum({<[cpa_Main Article Group Description]={'IntelliVue Measurements allocated'}>}
aggr((sum({<[cpa_Main Article Group Description]={'NICU Monitoring'}>}[cpa_Net Value]*CurrencyRate)/
sum({1<[Old Product Number]={'M8105A','M8001A','M8002A','M8003A','M8004A','M8005A','M8007A','M8008A','M8010A','865240'}>}[cpa_Net Value]*CurrencyRate)*
sum({1<[cpa_Article Group]={'1582','1709'}>}[cpa_Net Value]*CurrencyRate*1.0)),[cpa_Geo 4],[cpa_Fiscal Month Name],[cpa_Fiscal Year]))),

sum([cpa_Net Value]*CurrencyRate))))

Re: IF-Statement does not show values

Fri, 02 Sep 2011 05:07:16 GMT

Many Many Thanks! I take my hat of for your!