Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
....
Hi Robin,
I guess Qlik don't have BETWEEN key word. If I meant somehing kindly elaborate more.
-Jai
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
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