topic Re: Double 'if' condition in load script? in QlikView

Double 'if' condition in load script?

Mon, 23 Feb 2015 16:25:32 GMT

Hi,

I was wondering if you could help me.

I have a large dataset from which I would like to load into my QV only observations for which EITHER of the following two fields equals to 10: Home_location or Work_location.

While I've thought of other ways to extract only the data needed, I'm wondering whether it's possible to use a condition in the load script to load only data where either Home_location=10 or Work_location=10. I need to keep both these fields in the data.

I would greatly appreciate any suggestions. I've attached a sample data, actual dataset is much bigger.

Many thanks in advance,

Marketa

Re: Double 'if' condition in load script?

robert_mika — Mon, 23 Feb 2015 16:31:35 GMT

LOAD WorkerID,

Home_location,

Work_location,

Hours

FROM

(ooxml, embedded labels, table is Sheet1)

WHERE Home_location=10 OR Work_location=10

Re: Double 'if' condition in load script?

Anonymous — Mon, 23 Feb 2015 16:32:24 GMT

Add one line to your script:

LOAD WorkerID,
Home_location,
Work_location,
Hours
FROM

(ooxml, embedded labels, table is Sheet1)
WHERE Home_location=10 OR Work_location=10;

Re: Double 'if' condition in load script?

Mon, 23 Feb 2015 16:37:12 GMT

Wonderful, thank you both! I knew there must have been some simple solution....

Thanks!

Re: Double 'if' condition in load script?

robert_mika — Mon, 23 Feb 2015 17:58:58 GMT

You are welcome.

Thanks for feedback

Re: Double 'if' condition in load script?

Anonymous — Tue, 24 Feb 2015 02:19:09 GMT

WHERE 10 in (Home_location,Work_location)