topic Re: Filed based on Date condition in QlikView

Filed based on Date condition

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

Hi All,

I need to create Status filter based on 3 date fields And conditions some thing like below

Clinical : IF Start Date between Clinical Date & Commercial Date

Commercial : IF Start Date > Commercial Date

Unknown : IF Start Date < Clinical Date

I have attached sample excel. Let me know if you need any other info.

-Jai

olivierrobin — Fri, 23 Mar 2018 08:04:00 GMT

hello

why don't you create these filters when loading your date ?

(for example and in a simplified syntax)

load

Product ID

,Start Date

.....

,if( IF Start Date between Clinical Date & Commercial Date,1,0) as Clinical

....

Anonymous — Fri, 23 Mar 2018 08:40:58 GMT

Hi Robin,

I guess Qlik don't have BETWEEN key word. If I meant somehing kindly elaborate more.

-Jai

sasiparupudi1 — Fri, 23 Mar 2018 09:04:54 GMT

If([Start Date]>=[Clinical Date] AND [Start Date]<=[Commercial Date],'Clinical',

If([Start Date]>[Commercial Date],'Commercial',

If([Start Date]<[Clinical Date],'Unknown')

)) As Status

Anonymous — Fri, 23 Mar 2018 09:11:18 GMT

Hi,

Use the below code

If([Start Date] >= [Clinical Date] AND [Start Date] <= [Commercial Date],'Clinical',

If([Start Date] >[Commercial Date],'Commercial',

If([Start Date] < [Clinical Date],'Unknown')

)) As Status_Filter

Thanks,

Venkata Sreekanth