topic Re: if condition in script in QlikView

if condition in script

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

hi all,

I want create a Yes/no through if condition how to create this?

logic is :

if(Act_start>PlanStart and ActEnd<=Plan_End )

timeformat : 2018-01-22 15:00:28.000

can anyone help on this?

Thanks

Sony

Anil_Babu_Samineni — Mon, 02 Apr 2018 12:53:10 GMT

If All fields are same format? Why not simply

if(Act_start>PlanStart and ActEnd<=Plan_End, 'Yes', 'No') as Flag

soniasweety — Mon, 02 Apr 2018 13:21:02 GMT

yes its all same.

I need one more also like is it correct or not? with multi values

if(code='Success' or code='Success With No Issues', 'EF','NotEF') as EF_Flag,

shiveshsingh — Mon, 02 Apr 2018 14:45:14 GMT

if(code='Success' or code='Success With No Issues', 'EF','NotEF') as EF_Flag

Yep it's perfect. You or putting 'OR' condition right.. if any of these conditions get fulfilled, you'll get 'EF' else NotEF

shiveshsingh — Mon, 02 Apr 2018 14:45:22 GMT

if(code='Success' or code='Success With No Issues', 'EF','NotEF') as EF_Flag

Yep it's perfect, if any of these condition fulfils then EF else NotEF

sasiparupudi1 — Mon, 02 Apr 2018 20:07:24 GMT

It looks fine but when you are comparing strings care should be taken with the case

another way of doing this especially with multiple values, use match function as it is a lot more neater and sometimes more efficient than if

if(Match(code,'Success' ,'Success With No Issues'), 'EF','NotEF') as EF_Flag,

MarcoWedel — Mon, 02 Apr 2018 20:53:06 GMT

please close your thread if your initial question is answered:

thanks

regards

Marco

Anonymous — Tue, 03 Apr 2018 06:57:50 GMT

if condition in qlikview is :

if(condition , then , else)

as per you requirement:

if (condition,'true','false') as flag

if condition is satisfied,expression returns true/yes else returns false/no.