topic Multiple conditions in QlikView

Multiple conditions

dseelam — Sat, 16 Nov 2024 04:25:04 GMT

Hello All,

attached Qvw and written inline source below

am trying to create close out field using below statement but failing

if(len(trim(date([BeginDate])))=0 and len(trim(date([EndDate])))=0 , this means if both BeginDate & EndDate are null consider item 12 as close out

if(len(trim(date([Begin Date])))>0 , starting this date item 1234 falls under close out

if(len(trim( date([Begin Date] and date([End Date]>0)))),'Closeouts','Excl Closeout'))) as Closeout

between this dates item 12345 should fall under this criteria

all other scenarios like item 123 should fall under Excl Closeout

Source

load*
inline

[Item,BeginDate, EndDate
12, ,
123,-1, ,
1234,02/15/2018,
12345,02/17/2018,05/16/2018];

Please help

thanks,

Re: Multiple conditions

Nicole-Smith — Mon, 18 Feb 2019 17:44:35 GMT

I think the following meets your criteria:

between this dates item 12345 should fall under this criteria
all other scenarios like item 123 should fall under Excl Closeout

Script:

Source:
load *, 
	if(len(trim([BeginDate]))>0 and len(trim([EndDate]))>0,'Closeouts','Excl Closeout') as Closeout 
inline [
Item,BeginDate, EndDate
12, ,
123,-1, ,
1234,02/15/2018,
12345,02/17/2018,05/16/2018
];

Output:

Item	BeginDate	EndDate	Closeout
12			Excl Closeout
123	-1		Excl Closeout
1234	2/15/2018		Excl Closeout
12345	2/17/2018	5/16/2018	Closeouts

Re: Multiple conditions

dseelam — Mon, 18 Feb 2019 19:49:33 GMT

Hello Nicole,

This scenario worked only for Item 12345, except 123 with -1 begin date everything should fall under closeouts.

Example:

Thanks,

Re: Multiple conditions

Nicole-Smith — Thu, 28 Feb 2019 16:25:44 GMT

Can you please give what you want the final table to look like? I can help write the code for it, but only if I can understand what the final output should look like.