help needed to derive flag in script

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I need to create flags for a column "Customer" in script.

Requirement is like if the "Customer" column is null in current year then the current year null flag =1 else 0

Similarly i need to look check for previous Year means if the "Customer" name is null in previous year then the previous year null flag will be 1 else 0.

I have to derive these flags to use in other field derivation in script.

Can somebody help me on this.

Thanks in advance

Regards,

Nani

Re: help needed to derive flag in script

vinieme12 — Mon, 09 Jan 2017 12:30:28 GMT

if Customer and Year field both are in the same table then

if(len(trim(Customer))<1,1,0) as Flag

, else please post a sample

topic help needed to derive flag in script in QlikView

help needed to derive flag in script

Re: help needed to derive flag in script