Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Inconsistent Behavior with Expression

 

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.

 

 

6 Replies
Clever_Anjos
Employee
Employee

Downloaded your file, both expressions are showing same value

QlikView 12 IR here

Not applicable
Author

QlikView 11.20.12904.0 SR12 64 bit.

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

sunny_talwar

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

Clever_Anjos
Employee
Employee

That expression does not work into Conditional and Show Column

Weird, seems to be a bug to me

sunny_talwar

I agree

Not applicable
Author

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