topic Re: Script error in QlikView

Script error

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi ,

In The script i am trying to add the below expression but this is giving an error during reload process. load

Release,

if(not match(Status,'Defined','In Progress'),Release='Blank',Release) as RNUmber

Resident Test

Group by [Release],[Status];

how can i correct this

Thanks in advance

Re: Script error

ogautier62 — Tue, 28 Aug 2018 09:20:17 GMT

Hi,

maybe this :

if(not match(Status,'Defined','In Progress'),'Blank',Release) as RNUmber

remove : release=

regards

Re: Script error

smilingjohn — Tue, 28 Aug 2018 09:38:22 GMT

Hi Oliver,

Thanks this works ..

Actually i want to discard the whole content if there is Defined or in progress in it.

For which the above logic is not working ...

How do i achieve this

Re: Script error

ogautier62 — Tue, 28 Aug 2018 09:43:14 GMT

to have null :

if(not match(Status,'Defined','In Progress'),,Release) as RNUmber

if you want to skeep row :

add where match(Status,'Defined','In Progress') =0 in load

Re: Script error

gavinigovind452 — Tue, 28 Aug 2018 09:52:20 GMT

using above answer not getting error

[SalesPersonSales201806]:

LOAD * INLINE [

Short_ID, Month

1, AUG

2, SEP

3, DEC

4, SEP

5, SEP

6, OCT

7, JAN

8, AUG

];

Tab:

load Short_ID,

if (not match(Month,'AUG','SEP'),'Blank','YES') as tert

Resident [SalesPersonSales201806];

getting below result:

Short_ID	Month	tert
1	AUG	YES
2	SEP	YES
3	DEC	Blank
4	SEP	YES
5	SEP	YES
6	OCT	Blank
7	JAN	Blank
8	AUG	YES