topic Re: Conditional with jerarquic dimmension in QlikView

Conditional with jerarquic dimmension

Mon, 15 Jun 2015 17:34:40 GMT

I have a jerarquic dimmension

I have null values in the expression

I wanna do something like this

=if (isnull(JERARQUICDIMENSION), 'NULL', "JERARQUICDIMENSION")

It isn't working. It seems like i'm seeing the first dimmension of the jerarquic

Thank you

Greetings

sunny_talwar — Mon, 15 Jun 2015 17:43:33 GMT

Is this a dimension? May be try this:

If(Len(Trim(JERARQUICDIMENSION)) <> 0, JERARQUICDIMENSION)

Mon, 15 Jun 2015 18:02:05 GMT

yes! is a dimmension

I think it's not working

The dimension should be

if is null = 'Null value'

If not = ' Dimension'

sunny_talwar — Mon, 15 Jun 2015 18:05:04 GMT

Above is working the same way as you have described, Have you checked "Suppress When Value Is Null" on the dimensions tab???

The box should have tick mark next to it.

HTH

Best,

Sunny

Mon, 15 Jun 2015 18:07:36 GMT

Yeah. Sory if i didn't expressed myself well.

I dont' wanna supress the null values. I wanna have a name for that. In this case it would be 'No Client'

You understand ?

Thank you

Greetings

sunny_talwar — Mon, 15 Jun 2015 18:12:21 GMT

Try this:

If(Len(Trim(JERARQUICDIMENSION)) <> 0, JERARQUICDIMENSION, 'No Client')