topic Re: nested if in QlikView

nested if

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

hi,

i have a search box containing application name and technology.

when i expand application name in the search box, i should get that application name in that text box and when i click the technology , technology name should appear in the text box

i wrote the expression as

=if(Len(GetFieldSelections([Application name])) or len(GetFiledSelections(Technology)), Concat(distinct[application name], ','), 'Search for application or technology)

this isworking only for application name, but not technology..when i click on technology it is showing application name. please suggest.

i guess we have to use nested if's but unable to write the code.

Re: nested if

Anonymous — Wed, 21 Sep 2016 09:53:19 GMT

maybe like this

=if(Len(GetFieldSelections([Application name])), Concat(distinct[application name], ','), if (len(GetFiledSelections(Technology)),Technology)

check the brackets, I did not Count them

if you have only two states you may skip the second if

=if(Len(GetFieldSelections([Application name])), Concat(distinct[application name], ','), Technology)

maybe you Need to concat Technology as well

Re: nested if

Digvijay_Singh — Wed, 21 Sep 2016 09:58:35 GMT

something like this -

=if(

Len(GetFieldSelections([Application name])),

Concat(distinct [application name], ','),

if(Len(GetFieldSelections([Technology])),

Concat(Technology],','), 'Search for application or technology'))