topic Re: How to create a new column on basis of other columns string in App Development

How to create a new column on basis of other columns string

akshay_chavan — Mon, 14 Feb 2022 04:50:19 GMT

Hi All,

I want to create new Column which is based on one different fields

eg.

Table:

In the above table I want to create column closed date on the basis of,

if flag against Number Column is HUB then show date of Date 2 field

if flag against Number Column is NON HUB then show date of Date 1 field

How I can achieve this?

Thanks In advance!!!

#qlik sense

Regards

Vegar — Mon, 14 Feb 2022 05:39:35 GMT

Try an pick match approach for this. Like below.

pick(match(Flag,'HUB','NON HUB'),[Date 2],[Date 1])

akshay_chavan — Mon, 14 Feb 2022 07:19:09 GMT

Thanks for solution. dates are showing as required.

but In this I also want that if there is no date in Date1 or Date2 then show the todays date in the closed date column.

how to achieve this?

regards

Vegar — Mon, 14 Feb 2022 07:25:35 GMT

You could combine it with an alt() or coalesce() like this.

alt(pick(match(Flag,'HUB','NON HUB'),[Date 2],[Date 1]), today())

akshay_chavan — Mon, 14 Feb 2022 08:54:12 GMT

today date display like this - 2/14/2022

but I want it into this format - 2020-02-14 09:45:40.0000000

I tried it with Now(), but not get expected result.

Regards