topic where condition in a script in QlikView

where condition in a script

mario-sarkis — Wed, 22 Apr 2015 09:54:43 GMT

hey guyz please help

i have a field lets say

SEGMENT:

employee
Mass

Upper Mass

Loyal

i need to extact this field but in condition to be diffrent then employee and Mass

How can i write it in a script

PrashantSangle — Wed, 22 Apr 2015 09:56:53 GMT

Hi,

Can you explain in details??

Regards

jagan — Wed, 22 Apr 2015 09:59:13 GMT

Hi,

Try like this

LOAD

FROM DataSource

WHERE NOT WildMatch(SEGMENT, 'employee', 'Mass');

Hope this helps you.

Regards,

Jagan.

ashfaq_haseeb — Wed, 22 Apr 2015 10:00:21 GMT

Hi,

Try like this

Load * where not WildMatch(SEGMENT,'*employee*','*Mass*');

load * Inline

[

SEGMENT

employee

Mass

Upper Mass

Loyal

];

Regards

ASHFAQ

Wed, 22 Apr 2015 10:00:55 GMT

SEGMENT:

Load employee from tablename where employee <>'Mass'