Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Downloaded your file, both expressions are showing same value
QlikView 12 IR here
QlikView 11.20.12904.0 SR12 64 bit.
If I use the second expression, the mini-chart disappears entirely.
You are right, I am seeing the same problem in QV 12 as well
That expression does not work into Conditional and Show Column
Weird, seems to be a bug to me
I agree
Thanks everyone. I'll assume this is a bug then and look at raising it with Qlik.