topic Re: IF in Expressions in QlikView

IF in Expressions

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

Hello There,

I have concern regarding the expression, i' m trying to get the value of FINAL_CLASS just happen sometimes is not available so if not i need to get the INITIAL_CLASS i composed like this:

=if ([FINAL_CLASS] = ' ',INITIAL_CLASS,FINAL_CLASS) but the problem is only INITIAL_CLASS appear although the FINAL_CLASS value is available.

Sample Data:

INITIAL_CLASS FINAL_CLASS

A A

B B

C C

D D

E E

F F

screenshot below:

Best Regards,

Bing

Re: IF in Expressions

Chanty4u — Fri, 20 Oct 2017 06:54:52 GMT

try below

=if (isnull([FINAL_CLASS]),INITIAL_CLASS,FINAL_CLASS)

Re: IF in Expressions

Anil_Babu_Samineni — Fri, 20 Oct 2017 06:58:08 GMT

We can do number of days for this? Can you share exactly data set with some null values?

Re: IF in Expressions

bsbernabe — Fri, 20 Oct 2017 07:54:07 GMT

Hi Chanty,

Thank you for your support.

Best Regards,

Bing

Re: IF in Expressions

Chanty4u — Fri, 20 Oct 2017 08:12:17 GMT

cool

Re: IF in Expressions

bsbernabe — Wed, 25 Oct 2017 01:54:22 GMT

Hi Chanty,,

Your expressions is working base on my sample data but i observed one thing that if the FINAL_CLASS is empty it is not working supposed to be if the FINAL_CLASS is empty get the value of INITIAL_CLASS. is it possible? although it is another scenario but I'm just asking. sorry so late reply about this concern. hoping you can help me about this.

Sample Data:

INITIAL_CLASS FINAL_CLASS

C C

E E

F F

Best Regard,

Bing