topic Re: Nested condition doesn't work in QlikView

Nested condition doesn't work

hillrunner — Wed, 11 Nov 2020 21:40:26 GMT

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/433113 )

If someone can say me why it doesn't work

thanks for reading !

Re: Nested condition doesn't work

MayilVahanan — Thu, 12 Nov 2020 00:25:45 GMT

Hi @hillrunner

Try like below

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

Re: Nested condition doesn't work

hillrunner — Thu, 12 Nov 2020 10:14:36 GMT

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

Re: Nested condition doesn't work

MayilVahanan — Thu, 12 Nov 2020 10:21:48 GMT

Hi @hillrunner

Can you provide the sample data to verify further.

Re: Nested condition doesn't work

hillrunner — Thu, 12 Nov 2020 10:32:04 GMT

For sure thanks !

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

Re: Nested condition doesn't work

hillrunner — Thu, 12 Nov 2020 10:31:34 GMT

And the 2 other excel files

Re: Nested condition doesn't work

MayilVahanan — Thu, 12 Nov 2020 16:49:22 GMT

Hi @hillrunner

PFA

Re: Nested condition doesn't work

edwin — Thu, 12 Nov 2020 16:57:40 GMT

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

Re: Nested condition doesn't work

edwin — Thu, 12 Nov 2020 16:58:29 GMT

Re: Nested condition doesn't work

QFabian — Fri, 13 Nov 2020 19:53:19 GMT

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

greetings!