topic Re: if nested statement in QlikView

if nested statement

Sat, 09 Nov 2013 19:42:29 GMT

hi i am trying to complete the following logic in my application.

however, either one statement works or the other but not together.

the logic is that where one of the values is missing take the other.

for example

works!

if([Master_Item.Product Group] ='x',[Product Group]

works!

if([Master_Item.Product Group] ='x',[Cost_Center_Mapping.Product Group])

Does not work.

if([Master_Item.Product Group] ='x',[Product Group],

(if([Master_Item.Product Group] = 'x' and [Product Group] = '',

[Cost_Center_Mapping.Product Group])))

any help is greatly appreciated. i have attached application for further analysis if needed,

Best

Brad

Re: if nested statement

giakoum — Sat, 09 Nov 2013 20:05:00 GMT

try

=if([Master_Item.Product Group] ='x' and [Product Group] <> '',[Product Group],

(if([Master_Item.Product Group] = 'x' and [Product Group] = '',

[Cost_Center_Mapping.Product Group])))

but I noticed that [Cost_Center_Mapping.Product Group] is null when any [Product Group is selected

Re: if nested statement

Sat, 09 Nov 2013 20:42:17 GMT

Hi,

Try hereunder

if([Master_Item.Product Group] ='x',[Product Group],

if([Master_Item.Product Group] = 'x' and [Product Group] = '',

[Cost_Center_Mapping.Product Group], 'not found'))

Now the syntax is ok. Not sure about your data.

Regards,

Gerrit

Re: if nested statement

rustyfishbones — Sun, 10 Nov 2013 14:11:38 GMT

Hi,

I don't think you need to have a parentheseis around the 2nd IF Statement

Please see the attached

Regards

Re: if nested statement

israrkhan — Sun, 10 Nov 2013 14:21:29 GMT

try this one:

if([Master_Item.Product Group] ='x',[Product Group],if([Master_Item.Product Group] = 'x' and [Product Group] = '',

[Cost_Center_Mapping.Product Group], Null))

Re: if nested statement

Sun, 10 Nov 2013 15:13:58 GMT

Try Below one: Please use LEN function while comparing the space in the fields.

if(LEN(TRIM([Product Group]) = 0 AND [Master_Item.Product Group] = 'x' , [Cost_Center_Mapping.Product Group] ,

IF ([Master_Item.Product Group] = 'x' , [Product Group] , 'Not Found')) AS FIELDNAME