condiitonal expression / multiple expression

CanOls — Sat, 16 Nov 2024 19:40:40 GMT

I have a tricky table that I hope you can help me with.

The table consists of field that detail completion rate (in %), however, one field contains median age.

I didn't notice this at first and just used the sum function in an expression and it works for my completion rate fields, but it doesn't make sense in the median age field.

I was thinking that I need to add a conditional expression so that it will use the sum function per default but if the field name is median age then I use another way of calculating so I get a good result.

I can't quite figure out how to use a conditional expression or if it is even possible.

I hope it makes sense.

Any Help is appreciated!

Casper

Re: condiitonal expression / multiple expression

Arthur_Fong — Thu, 14 Nov 2019 11:55:35 GMT

Maybe try this:

if([FieldName]= "Median Age", <Exp for median age>, <default expression>)

Re: condiitonal expression / multiple expression

CanOls — Thu, 14 Nov 2019 12:09:30 GMT

Hi, thanks for your reply.

Your solution worked when I replaced the "" with ''.

Thanks.

topic Re: condiitonal expression / multiple expression in QlikView

condiitonal expression / multiple expression

Re: condiitonal expression / multiple expression

Re: condiitonal expression / multiple expression