Filed based on Date condition

[Anonymous]

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]

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]

Hi Robin,

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

-Jai

[sasiparupudi1]

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]

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