Nested condition doesn't work

[hillrunner]

Hello ! 

I am a beginner in Qlikview and I was searching how to do a nested condition in a dimension of a graph. 

The condition is : 

=if(IsNull(Spécialité),'step 1',if(IsNull([Group Sanguin]),'step 2','step 3'))

So this condition  with these data : 

should, according to me, for each person ( Nom et prénom is First Name and Last name ), indicates me or Step 1 or Step 2 or Step 3 

And for example Mr. Joseph Paris has null in the column spécialité so it should show step 1
Madam Sarah Frisc should show step 2  because " group sanguin " is empty 

And Laurent Blanc " step 3 " 

But it doesn't work, instead of step 1 it shows null : 

 

( according to the links i checked it should work... for example : https://community.qlik.com/t5/QlikView-App-Development/how-to-write-multiple-if-conditions/td-p/4331... ) 

If someone can say me why it doesn't work 

thanks for reading ! 

[MayilVahanan]

Hi @hillrunner 

Try like below

=if(Len(trim (Spécialité))=0,'step 1',if(IsNull([Group Sanguin]),'step 2','step 3'))

[hillrunner]

Thanks for response ! 

but it doesn't work neither, doesn't understand why, it does the same, nothing when it should be written step 1 

I tried another possibility : =if(Len(Spécialité)>0,if(Len([Group Sanguin])>0,'step3','step2'),'step1') 

( in reverse direction ) but it doesn't work neither, really doesn't understand why

[MayilVahanan]

Hi @hillrunner 

Can you provide the sample data to verify further.

[hillrunner]

For sure thanks !

I post two responses because i can only post 3 files at the same time

[hillrunner]

And the 2 other  excel files 

[MayilVahanan]

Hi @hillrunner 

PFA

[edwin · Accepted solution]

move the calculated dimension to the expression instead and it will give you what you want

[edwin]

[QFabian]

Hi!, you should probably thibnk in a script solution, try always to avoid calculated dimensions.

greetings!