topic Calculated dimension: Nested IF returns a null value in addition to the other correct value in QlikView

Calculated dimension: Nested IF returns a null value in addition to the other correct value

Wed, 26 Jan 2011 11:49:17 GMT

Hi,

I have the following calculated dimension:

=If(GetFieldSelections(Language_Id) = 'FR', REV_SubRubric_FR, (If(GetFieldSelections(Language_Id) = 'DE', REV_SubRubric_DE,(If(GetFieldSelections(Language_Id) = 'EN', REV_SubRubric)))))

here isthe tables relationship:

I have only 6 rows on the FieldsMap1 table.

Can someone explain me why I got 7 values in my calculated dimension?here is the chart where you can see a null value:

If, instead of a calculated dimension, I use the Field REV_SubRubric as my dimension, then I got only the 6 correct values.

Do you know what I am doing wrong?

thanks,

Caro.

Calculated dimension: Nested IF returns a null value in addition to the other correct value

Stefan_Walther — Fri, 29 Apr 2011 15:36:47 GMT

Sorry, I think without any sample data this question is really hard to answer 🙂

Calculated dimension: Nested IF returns a null value in addition to the other correct value

Fri, 29 Apr 2011 15:48:46 GMT

Hi there, try this:

pick(match(Language_Id,'FR','DE','EN'), REV_SubRubric_FR, REV_SubRubric_DE, REV_SubRubric)

Regards

Calculated dimension: Nested IF returns a null value in addition to the other correct value

johnw — Sat, 30 Apr 2011 00:04:19 GMT

Oh, and in addition to simplifying with the pick(match()) that Ivan gave, checkmark "suppress when value is null" for your calculated dimension. That should make the null value go away.

Calculated dimension: Nested IF returns a null value in addition to the other correct value

Mon, 21 Nov 2011 22:08:42 GMT

Thanks for the solution !! Works fin for me too

Gracias por la solcion !! A mi tambien me funciono