topic Re: Script problem in if condition in QlikView

Script problem in if condition

Anonymous — Wed, 20 Jan 2016 03:48:46 GMT

Hi,

I have columns like Linkid,state,end1,end2.

Linkid contains numbers like 1...10.

state contains 0,1,2 ,1,0,1,1,0,2,1

end1 contains Yes,No like repetitively upto 10 rows

end2 also contains Yes,No upto 10 rows.

Now my requirement is i need to divide state into 4 stages based on state,end1,end2.

Stage0 =total count of linkid.

Stage1=selection of state(0,1)

Stage2=selection of state(0,1) and end1(Yes)

Stage3=selection of state(0,1) and end1(Yes) and end2(Yes)

The above i have created in script like

if(state=0 and state=1,'Stag1',

if(state=0 and state=1 and end1='Yes','Stag2',

if(state=0 and state=1 and end1='Yes' and end2='Yes','Stag3'))) as Newstate,(I haven't included Stage0 could you please check)

After reloading i haven't got any data for newstate showing empty.May be i have done wrong in script part of if condition.

Please check attachment of excel data and qlikview file below.

Could you please help me on that with including Stage0?

Thanks,

Kanna

Re: Script problem in if condition

engishfaque — Wed, 20 Jan 2016 04:06:12 GMT

Dear Rajesh,

I have checked your if else condition,

I think you need to use OR Operator instead of AND Operator between state =0 and state =1

This is not possible to use AND Operator on the same field such as you have done, state field either be 0 or 1.

How the same field can be 0 and 1 at the same time?

Kindly find attached file.

Kind regards,

Ishfaque Ahmed

Re: Script problem in if condition

Anonymous — Wed, 20 Jan 2016 04:10:35 GMT

If I am including both we need to put AND only na..OR we use of either this

or another.

Re: Script problem in if condition

engishfaque — Wed, 20 Jan 2016 04:15:57 GMT

Dear Rajesh,

Here is the AND Operator output,

state	state1	output
0	0	0
0	1	0
1	0	0
1	1	1

Here is the OR Operator output,

state	state1	output
0	0	0
0	1	1
1	0	1
1	1	1

Then how can be possible that you are saying state = 0 and state = 1 ?

You can apply AND Operator in that way state = 0 AND state1 = 1.

Kind regards,

Ishfaque Ahmed

Re: Script problem in if condition

Anonymous — Wed, 20 Jan 2016 04:21:59 GMT

Thanks for your response.

Here 1 and 0 are not Boolean values ..I can also take 1 and 2 also any

numbers that time not possible.

Re: Script problem in if condition

engishfaque — Wed, 20 Jan 2016 04:30:23 GMT

Dear Rajesh,

Here is your excel file data,

linkid	state	end1	end2
1	0	Yes	Yes
2	1	Yes	No
3	1	No	No
5	2	Yes	Yes
6	1	No	No
4	2	No	Yes
3	0	Yes	Yes
4	1	Yes	No
6	0	No	Yes
4	0	Yes	Yes
3	2	No	Yes

state is a field where you are applying AND Operator. So I'm telling you this is not possible at the same time state contain 0 and 1. state either be 0 or 1 at a time.

Solution: create one more state1 field where you put your 1 or 2 values and then perform AND operation in IF else condition. Such as I illustrated in previous post.

Kind regards,

Ishfaque Ahmed

Re: Script problem in if condition

Anonymous — Wed, 20 Jan 2016 04:36:23 GMT

Can you please help me on writing sample data to load including state2 and

also script part with stages I have asked in requirement, that should be

very helpful for me.

Thanks,

Rajesh

Re: Script problem in if condition

engishfaque — Wed, 20 Jan 2016 04:55:25 GMT

Dear Rajesh,

Sure, please share me your desired output.

Kind regards,

Ishfaque Ahmed

Re: Script problem in if condition

PradeepReddy — Wed, 20 Jan 2016 05:00:00 GMT

try like this...

IF((State=0 or State=1) and end1='Yes' and end2='Yes','Stage3',

IF((State=0 or State=1) and end1='Yes' ,'stage2',

IF((State=0 or State=1),'stage1'))) as NewState

Re: Script problem in if condition

engishfaque — Wed, 20 Jan 2016 05:08:55 GMT

Dear Rajesh,

Kindly find attached App, I hope you are looking for that one solution.

Kind regards,

Ishfaque Ahmed

Re: Script problem in if condition

Anonymous — Wed, 20 Jan 2016 05:24:10 GMT

Thanks for your help..I have 18000 records like that i can't create new stage for all

Re: Script problem in if condition

engishfaque — Wed, 20 Jan 2016 05:34:29 GMT

Dear Rajesh,

Then I think you need to use listed below IF else condition,

if(state=0 or state1=1 and end1='Yes' and end2='Yes','Stag3',

if(state=0 or state1=1 and end1='Yes','Stag2',

if(state=0 or state1=1,'Stag1'))) as Newstate

Kind regards,

Ishfaque Ahmed

Re: Script problem in if condition

Anonymous — Wed, 20 Jan 2016 05:46:35 GMT

I tried that but it is loading only stage1 after reloading..it's not taking

stage2 and stage3.

Re: Script problem in if condition

PradeepReddy — Wed, 20 Jan 2016 05:56:47 GMT

try like this...

IF((State=0 or State=1) and end1='Yes' and end2='Yes','Stage3',

IF((State=0 or State=1) and end1='Yes' ,'stage2',

IF((State=0 or State=1),'stage1'))) as NewState

Re: Script problem in if condition

engishfaque — Wed, 20 Jan 2016 05:59:58 GMT

Dear Rajesh,

Have you tried this expression as I share you in last post,

if(state=0 or state1=1 and end1='Yes' and end2='Yes','Stag3',

if(state=0 or state1=1 and end1='Yes','Stag2',

if(state=0 or state1=1,'Stag1'))) as Newstate

I have checked and found that it was working fine, reference screenshot is attached with this post. Please check.

Kind regards,

Ishfaque Ahmed

Re: Script problem in if condition

ahmar811 — Wed, 20 Jan 2016 06:43:21 GMT

Hello

rajeshlingutla1257

you cant write AND between two condition which have same field like in your script

state=0 AND state=1

try this expression in you load script

if(state=0 OR state=1,'Stag1',

if((state=0 OR state=1) AND end1='Yes','Stag2',

if((state=0 OR state=1) AND (end1='Yes' OR end2='Yes'),'Stag3'))) as Newstate

hope this help you

Thanks & Regards

Ahmar Ansari