topic Re: If / and in script not working in QlikView

If / and in script not working

jagjivvt — Wed, 25 Nov 2020 16:16:04 GMT

Hi Please help.

i am using multiple if / and in script and the result is not correct. see below

" if([Formula Code]= 'Entityonly' and Len_Correct_Site='N' and Len_Select_legal_Entity='N' and Len_WE='N', 'Hold' ,

if([Formula Code]= 'EntityPO' and Len_Latest_PO_Number2='N' and Len_Correct_Site='N' and Len_Select_legal_Entity='N' and Len_WE='N', 'Hold' ,

if([Formula Code]= 'EntityWork' and Len_Correct_Site='N' and Len_Select_legal_Entity='N' and Len_WE='N' and Len_Worker='N', 'Hold' ,

if([Formula Code]= 'IFS' and Len_Correct_Site='N' and [Len_IFS Business Unit]='N' and Len_WE='N', 'Hold' ,

if([Formula Code]= 'SiteWE' and Len_Correct_Site='N' and Len_WE='N', 'Hold' ,

if([Formula Code]= 'Wname' and Len_Correct_Site='N' and Len_WE='N' and Len_Worker='N', 'Hold' ,

if(isnull([Formula Code])= -1, 'Hold' ,

if([Formula Code]= 'Done on a different Report', 'Hold',

'Release')))))))) as Action,"

thanks

vijay

Re: If / and in script not working

Anil_Babu_Samineni — Fri, 01 Dec 2017 15:23:33 GMT

Try this?

if([Formula Code]= 'Entityonly' and Len_Correct_Site='N' and Len_Select_legal_Entity='N' and Len_WE='N',

if([Formula Code]= 'EntityPO' and Len_Latest_PO_Number2='N' and Len_Correct_Site='N' and Len_Select_legal_Entity='N' and Len_WE='N',

if([Formula Code]= 'EntityWork' and Len_Correct_Site='N' and Len_Select_legal_Entity='N' and Len_WE='N' and Len_Worker='N',

if([Formula Code]= 'IFS' and Len_Correct_Site='N' and [Len_IFS Business Unit]='N' and Len_WE='N',

if([Formula Code]= 'SiteWE' and Len_Correct_Site='N' and Len_WE='N',

if([Formula Code]= 'Wname' and Len_Correct_Site='N' and Len_WE='N' and Len_Worker='N',

if(isnull([Formula Code])= -1,

if([Formula Code]= 'Done on a different Report', 'Hold','Release')))))))) as Action

Re: If / and in script not working

jagjivvt — Fri, 01 Dec 2017 15:29:46 GMT

Hi,

that did not return any Action.

vijay

Re: If / and in script not working

Anil_Babu_Samineni — Fri, 01 Dec 2017 15:32:55 GMT

So, What you got currently.

Re: If / and in script not working

jagjivvt — Fri, 01 Dec 2017 15:34:29 GMT

The result should be either Hold or Release and when i apply the change you provided it does not do any of the 2.

thanks

vijay

Re: If / and in script not working

Anil_Babu_Samineni — Fri, 01 Dec 2017 15:38:53 GMT

Not mine, i am talking about yours. You said that "Values returning wrong" Can you show image where it wrong? Better if you provide samples

Re: If / and in script not working

jagjivvt — Fri, 01 Dec 2017 15:56:10 GMT

Hi i have attached the qvw

Re: If / and in script not working

tamilarasu — Fri, 01 Dec 2017 16:06:46 GMT

Hi Vijay,

Which lines are wrong? Also can you let us know what you want to see?

Re: If / and in script not working

jagjivvt — Fri, 01 Dec 2017 16:10:22 GMT

Hi, if you look at EnityPO, if there is N in the Len_Latest_PO_Number, then the result should he Hold, but its putting Release .

thanks

vijay

Re: If / and in script not working

Anonymous — Fri, 01 Dec 2017 16:23:12 GMT

if (([Formula Code]= 'Entityonly' and Len_Correct_Site='N' and Len_Select_legal_Entity='N' and Len_WE='N')

OR ([Formula Code]= 'EntityPO' and Len_Latest_PO_Number2='N' and Len_Correct_Site='N' and Len_Select_legal_Entity='N' and Len_WE='N')

OR ([Formula Code]= 'EntityWork' and Len_Correct_Site='N' and Len_Select_legal_Entity='N' and Len_WE='N' and Len_Worker='N')

OR ([Formula Code]= 'IFS' and Len_Correct_Site='N' and [Len_IFS Business Unit]='N' and Len_WE='N')

OR ([Formula Code]= 'SiteWE' and Len_Correct_Site='N' and Len_WE='N')

OR ([Formula Code]= 'Wname' and Len_Correct_Site='N' and Len_WE='N' and Len_Worker='N')

OR (isnull([Formula Code])= -1)

OR ([Formula Code]= 'Done on a different Report'), 'Hold'

, 'Release') AS Action

,'Solution2' AS Solution

Re: If / and in script not working

tamilarasu — Fri, 01 Dec 2017 16:29:33 GMT

Have a look at the attached file.

Re: If / and in script not working

johnca — Fri, 01 Dec 2017 16:45:35 GMT

For starters, and based on the available data for EntityPO there is a 'Y' in the Len_Correct_Site field, among others. Hence the expression evaluates as false and returns 'Release'.

if([Formula Code]= 'EntityPO' and Len_Latest_PO_Number2='N' and Len_Correct_Site='N' and Len_Select_legal_Entity='N' and Len_WE='N', 'Hold'

Perhaps another look at your logic for 'Hold' and 'Release'?

Re: If / and in script not working

jagjivvt — Mon, 04 Dec 2017 10:17:52 GMT

thanks, that worked perfectly

vijay

Re: If / and in script not working

jagjivvt — Mon, 04 Dec 2017 10:53:16 GMT

thanks this worked perfectly