topic Re: Need Help in if condition(Calculated Dimension)....?? in QlikView

Need Help in if condition(Calculated Dimension)....??

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

Hi All.

1. if division is Excutive then we have to disply EC name as CEO.

2. if EC name is null then -- we have to display EC name as Visitors/Others.

can any correct the below condition which we are using as a calculated dimension please as per the above seanario...

if(ISNULL[EC Name]= 'Visitors/Others',(if(Division) = ‘Executive’, CEO))

EC Name is 'N/A' so we are considering it as NULL..

olivierrobin — Fri, 29 Jun 2018 12:02:01 GMT

if(division='Executive',

CEO,

if(len(trim([EC Name])=0 or [Ec Name]='N/A',

'Visitors/Others',

[EC Name]

)

dhasharadh — Fri, 29 Jun 2018 14:16:39 GMT

Thanks Robin,

But getting syntax error.

if(division='Executive','CEO',if(len(trim([EC Name])=0 or [Ec Name]='N/A','Visitors/Others',[EC Name])))

i have verified couple of times all braces are closed properly, No idea why am getting that.

olivierrobin — Fri, 29 Jun 2018 14:20:07 GMT

right parenthesis missing in len(trim( ......

and the last one is to be suppressed

if(division='Executive','CEO',if(len(trim([EC Name]))=0 or [Ec Name]='N/A','Visitors/Others',[EC Name]))

dhasharadh — Fri, 29 Jun 2018 14:30:24 GMT

Thanks again, but still getting some counts under null category.

we want those counts as well under 'Visitors/Others' only. Can you change the expression please.

olivierrobin — Fri, 29 Jun 2018 14:33:58 GMT

you have to check the values of Ec Name concerned so you can add the needed condition in the statement

vishsaggi — Fri, 29 Jun 2018 14:39:04 GMT

Can you show use the list of values coming from your field EC Name?