if statement

[bharatkishore]

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

[ogautier62]

may be this ?

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

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

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

[bharatkishore]

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..

[isingh30]

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

[ogautier62]

this is to concatenate in the same field comment

& concatenates two strings

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

[bharatkishore]

Sorry Ishtdeep getting error

[bharatkishore]

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..

[isingh30]

Can you share data in excel format?

[vvira1316]

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

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

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?

[isingh30]

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