topic Re: Understanding Script in QlikView

Understanding Script

AH — Sun, 20 Mar 2016 03:24:43 GMT

Hi,

I have a code in my script like this that somebody has written previously:

If(Sales> '0' or [Sales Flag] = 'Y', 'Y', 'N') as WarrantFlag

What is this code mean?

Is it like this? if sales is greater than zero or Sales flag = Y then Y otherwise N.

If i want to us these piece of code in where clause after the load statement then how should i write the code?

Thanks,

ahmed100

Re: Understanding Script

Chanty4u — Sun, 20 Mar 2016 03:29:55 GMT

hi,

the code mens

If(sales>0

[sales flag]= 'yes' the value of sales is more than " 0" or sales flag value is "yes" it will returns " yes" otherwise "No" by that it will create a flag.

hope this helps u

Re: Understanding Script

AH — Sun, 20 Mar 2016 03:35:04 GMT

Hi Chanty,

Thanks for the reply.

How can i use this code in where clause in the load script?

like this:

Load

---,

---

From xyx

Where-----------(how to use the code here?)

Thanks,

ahmed100

Re: Understanding Script

Chanty4u — Sun, 20 Mar 2016 03:42:19 GMT

load *,

....

......

where exists (sales>0 and/or flag='yes');

Re: Understanding Script

kkkumar82 — Sun, 20 Mar 2016 03:57:14 GMT

I think load .... ...... where (sales>0 or flag='yes'); is also fine Kiran Kumar

Re: Understanding Script

AH — Sun, 20 Mar 2016 04:05:26 GMT

Hi Chantu,

Is the exists functions is used when there is a table Already loaded and we are comparing the table we are currently loading?

Thanks,

ahmed100

Re: Understanding Script

kkkumar82 — Sun, 20 Mar 2016 04:21:42 GMT

Hi Ahmed,

Your are correct exists function is used to check if the value exists for previous loaded values, Is that what you want or while loading you want to check the condition then what I suggested would be fine.

Regards

Kiran Kumar

Re: Understanding Script

Kushal_Chawda — Sun, 20 Mar 2016 05:26:12 GMT

try this

WHERE Sales>0 or [Sales Flag]='Y'

Re: Understanding Script

Chanty4u — Sun, 20 Mar 2016 06:02:15 GMT

yes..

u can try

where sales>0 and [sales flag]='yes'

Re: Understanding Script

jagan — Mon, 21 Mar 2016 03:28:29 GMT

HI,

If you want to filter out those rows then use below script

Data:

LOAD

FROM DataSource

WHERE Sales> '0' or [Sales Flag] = 'Y';

Regards,

jagan.

Re: Understanding Script

avinashelite — Mon, 21 Mar 2016 05:23:25 GMT

LOAD *

;

from

table

where

Sales> '0' or [Sales Flag] = 'Y';

this should work

Re: Understanding Script

MayilVahanan — Mon, 21 Mar 2016 05:27:38 GMT

Your understanding is correct

if sales is greater than zero or Sales flag = Y then Y otherwise N.

Try like this

Load * where WarrantFlag = 'Y'; // Preceding Load

Load *, If(Sales> '0' or [Sales Flag] = 'Y', 'Y', 'N') as WarrantFlag

Your TableName;

Re: Understanding Script

ashwanin — Mon, 21 Mar 2016 05:32:25 GMT

You can use like this.

Load

------,

----,

---

from xyx Where Sales > '0' or [Sales Flag] = 'Y' ;