topic Re: if statement in QlikView

if statement

bharatkishore — Fri, 25 May 2018 13:30:30 GMT

Hi All,

I am writing the below if condition,

if(IsNull(Modality),'Null Modality',Modality),

if(IsNull(District),'Null District',District),

if(IsNull(Norm),'No Norm',Norm) as comment

Can you please help me bec the else condition is not passing is it because i am closing the brace at Modality and Distrcit.

Thanks,

Bharat

Re: if statement

ogautier62 — Fri, 25 May 2018 13:37:11 GMT

may be this ?

if(IsNull(Modality),'Null Modality',Modality) & '/' &

if(IsNull(District),'Null District',District) & '/' &

if(IsNull(Norm),'No Norm',Norm) as comment

Re: if statement

bharatkishore — Fri, 25 May 2018 13:39:56 GMT

Hi Olivier,

Thanks for your reply.. Can you pleas tell me what does & '/' & do and why we need to specify..

Is it not possible to do without this..

Re: if statement

isingh30 — Fri, 25 May 2018 13:41:49 GMT

if(IsNull(Modality),'Null Modality',Modality and

if(IsNull(District),'Null District',District and

if(IsNull(Norm),'No Norm',Norm)))

or replace is null with Modality = 0

Re: if statement

ogautier62 — Fri, 25 May 2018 13:42:49 GMT

this is to concatenate in the same field comment

& concatenates two strings

so comment could be : 'Null Modality/District num/No Norm'

Re: if statement

bharatkishore — Fri, 25 May 2018 13:47:56 GMT

Sorry Ishtdeep getting error

Re: if statement

bharatkishore — Fri, 25 May 2018 13:55:04 GMT

Thank you,

But i need if first condition is not satisfied then only second condition and else

if(IsNull(Modality),'Null Modality',Modality),

if(IsNull(District),'Null District',District)

Please let me know if you need anything more..

Re: if statement

isingh30 — Fri, 25 May 2018 14:01:46 GMT

Can you share data in excel format?

Re: if statement

vvira1316 — Fri, 25 May 2018 14:02:45 GMT

if( IsNull(Modality), 'Null Modality' , Modality)

if(condition , then , else) https://help.qlik.com/en-US/sense/April2018/Subsystems/Hub/Content/Scripting/ConditionalFunctions/if.htm

It will never work with the way you have written. Also not understanding what you are trying to achieve. is it in chart or script?

Re: if statement

isingh30 — Fri, 25 May 2018 14:02:58 GMT

Did you try this - or replace is null with Modality = 0??

Re: if statement

bharatkishore — Fri, 25 May 2018 14:05:37 GMT

Yes Ishtdeep..

Re: if statement

isingh30 — Fri, 25 May 2018 14:05:52 GMT

if(Modality = 0,'Null Modality','Modality' and

if(District = 0,'Null District','District' and

if(Norm = 0,'No Norm','Norm')))

Re: if statement

bharatkishore — Fri, 25 May 2018 14:07:17 GMT

Hi Vijay,

I am trying to acheive if (condition , then ,else then lf else) is it possible or is there any way.. can you please tell me

Re: if statement

bharatkishore — Fri, 25 May 2018 14:09:48 GMT

thanks ishtdeep but is there any chance that i can include o as isnull. And should be in else part

Re: if statement

vvira1316 — Fri, 25 May 2018 14:12:33 GMT

can you please explain your need in words with your sample data rather than with if statement you have provided.

Please advise what is the output expected from your data and we can try to provide you the syntax. Are you trying to do in script or in chart?

Re: if statement

bharatkishore — Fri, 25 May 2018 14:24:29 GMT

Hope this will help:

case when Modality is NULL then 'NULL Modality'

when District is NULL then 'NULL District'

when (Norm is NULL or Norm = 0) then 'NO norm'

else 'Include' end as comment

Re: if statement

vvira1316 — Fri, 25 May 2018 14:37:33 GMT

In above case statement you don't have if Modality is null then "'Null Modality" else value of field Modality and then you were checking for District and Norm in the statement to come up with Comment field like you have in original question.

Try following

If(IsNull(Modality), 'NULL Modality',

If(IsNull(District), 'NULL District',

If((IsNull(Norm) or Norm='0'), 'NO Norm', 'Include'))) as Comment

Re: if statement

bharatkishore — Fri, 25 May 2018 14:38:07 GMT

Will this script anything will help?

case when Modality is NULL then 'NULL Modality'

when District is NULL then 'NULL District'

when (Norm is NULL or Norm = 0) then 'NO norm'

else 'Include' end as comment

i need to write in qlikview

Re: if statement

bharatkishore — Fri, 25 May 2018 14:56:55 GMT

Thank you..