topic Re: If Statement in Script in QlikView

If Statement in Script

ashishpalkar — Sat, 03 Oct 2015 06:12:12 GMT

Hi There

I have to create following if statement in Load Script

If(a=1,b=2,c=3,Y,N) as Data;

in above statement , a , b and c are coming from 3 different QVD's.

How to achieve this?

Thanks,

Re: If Statement in Script

petter — Sat, 03 Oct 2015 06:39:51 GMT

Where do you want your If statement - in a new load statement? Which file, database or QVD does this If draw it's data from? You give us too little information to be able to give you sound advice.

Re: If Statement in Script

petter — Sat, 03 Oct 2015 06:40:42 GMT

Re: If Statement in Script

PrashantSangle — Sat, 03 Oct 2015 06:42:03 GMT

Hi,

can you explain in simple statement.

if(a=1 AND b=2 AND c=3,'Y','N') as Data

if(a=1 OR b=2 OR c=3,'Y','N') as Data

Regards

Re: If Statement in Script

PrashantSangle — Sat, 03 Oct 2015 06:43:09 GMT

Re: If Statement in Script

qlikviewwizard — Sat, 03 Oct 2015 07:16:21 GMT

Data:

load * ,If(a=1 and b=2 and c=3,'Y','N') as If_Statement;

Load * inline [

a,b,c

1,2,3

4,5,6

7,8,9

];

Hope this will help you.

Re: If Statement in Script

jagan — Sat, 03 Oct 2015 09:08:23 GMT

Hi,

Try like this

QVTableName:

LOAD

If(a=1 AND b=2 AND c=3,Y,N) as Data

FROM DataSource;

Hope this helps you.

Regards,

jagan.

Re: If Statement in Script

Anonymous — Sat, 03 Oct 2015 09:30:22 GMT

hi ashish,

Table1:

Load ID,a

From a.qvd;

concatenate

Load ID,b

From b.qvd;

concatenate

Load ID,c

From c.qvd;

Table:

noconcatenate

Load *,

If(a=1 and b=2 and c=3,Y,N) as Data // or try If(a=1 or b=2 or c=3,Y,N)

Resident Table1;

Re: If Statement in Script

ashishpalkar — Mon, 05 Oct 2015 21:02:03 GMT

Thanks Neetha , your solution worked for me.

Re: If Statement in Script

jagan — Tue, 06 Oct 2015 02:37:42 GMT

Hi Ashish,

If you got the answer close this thread by giving correct answer, it helps others in finding answers easily.

Regards,

Jagan.