Solved: Re: Create a New on basis existing column - Qlik Community

suhascool1 · ‎2024-02-28

Hi,

Existing Closed Date column on basis of this column we need to create new column Status.

Date value is available then status column Value shows Yes

if Date value is blank then status column value shows Not.

Closed_Date

01-02-2024

13-01-2024

14-01-2024

Final Result :

Closed_Date	Status
01-02-2024	Yes
	Not
13-01-2024	Yes
14-01-2024	Yes
	Not
14-01-2024	Yes

ali_hijazi · ‎2024-02-28

if you want to accomplish this in the script, then you need to write something like this:
if( not trim(Closed_Date) = '' and not isnull(Closed_Date), 'Yes','Not') as Status

I can walk on water when it freezes

View solution in original post

ali_hijazi · ‎2024-02-28

if you want to accomplish this in the script, then you need to write something like this:
if( not trim(Closed_Date) = '' and not isnull(Closed_Date), 'Yes','Not') as Status

I can walk on water when it freezes

suhascool1 · ‎2024-02-29

thank u

Pallav · ‎2024-03-01

If(Isnull(Closed_Date),'NOT','YES')

Create a New on basis existing column

General Question