topic Re: Inconsistent Behavior with Expression in QlikView

Inconsistent Behavior with Expression

Wed, 02 Mar 2016 20:13:50 GMT

Here's a pretty straightforward QlikView model. I have an expression inside a Chart/Straight Table, to show or hide a mini-chart based on another column. The problem is this:

This works:

If(isnull(column(1))),

But changing the expression to this, which should be equivalent, does NOT work:

If(isnull([Column Name]),

I don't want ordinal column references if I can avoid it.

Is this a QlikView bug? The expression that works is currently enabled; the one I'd like to use is commented out.

You can click the Incident Filter to see how the model shows and hides rows in the desired manner.

Also, I've added two other columns and disabled them just to confirm the two expressions are equivalent. They are.

Can someone have a look and comment? Thanks.

Re: Inconsistent Behavior with Expression

Clever_Anjos — Wed, 02 Mar 2016 20:20:48 GMT

Downloaded your file, both expressions are showing same value

QlikView 12 IR here

Re: Inconsistent Behavior with Expression

Wed, 02 Mar 2016 20:24:42 GMT

QlikView 11.20.12904.0 SR12 64 bit.

If I use the second expression, the mini-chart disappears entirely.

Re: Inconsistent Behavior with Expression

sunny_talwar — Wed, 02 Mar 2016 20:31:12 GMT

You are right, I am seeing the same problem in QV 12 as well

Re: Inconsistent Behavior with Expression

Clever_Anjos — Wed, 02 Mar 2016 20:41:30 GMT

That expression does not work into Conditional and Show Column

Weird, seems to be a bug to me

Re: Inconsistent Behavior with Expression

sunny_talwar — Wed, 02 Mar 2016 20:43:31 GMT

I agree

Re: Inconsistent Behavior with Expression

Fri, 04 Mar 2016 15:33:01 GMT

Thanks everyone. I'll assume this is a bug then and look at raising it with Qlik.