topic conditional show issue in QlikView

conditional show issue

siddharth_kulka — Thu, 29 Jul 2010 22:07:12 GMT

This is an interesting one for 9.0!

I have a conditional show statement in one of the list box layouts (v_dropdown='National'), based on an input box selections(national, area, region)

If I select region, the list box is hidden(as expected), but if go back to national, it never comes back. The interesting thing is that the show mode for the same list box is NORMAL when i check object properties. I checked the layers, and every possible thing that i could. I also tested the variable value in a text box and there was no issue with that either

How can an object not appear in Front end when the SHOW MODE is NORMAL for that object? Also, this problem is NOT encountered for other objects like straight tables with the SAME LAYOUT CONDITION[:@]

Any clue?

Thanks,

Siddharth

conditional show issue

wizardo — Fri, 30 Jul 2010 08:11:54 GMT

hmm

what version of qv9 you have?

i tried it on ver 9sp3

and what you describe didnt happen to me

not on a listbox and not on any other object type

what are the constraints and method of selecting the values in the input box?

does it happen also if you change the variable value from the variable overview dialog?

does it happen on any list box? or just this specific one?

can you put this on a document and upload it ?

Mansyno

conditional show issue

siddharth_kulka — Fri, 30 Jul 2010 16:37:13 GMT

I am using 9.0 SR3. I checked the same in 8.5 and didnot notice the issue. Attached is the same qvw. Check the sheet properties for List Box Forest_Brand_Desc. It shows as normal, but doesnot get displayed for any of the input box selections.

Here are answers to your questions:

what version of qv9 you have?

Ans 9.0 SR3

what are the constraints and method of selecting the values in the input box?

Ans: Listed values in a drop down without constraints

does it happen also if you change the variable value from the variable overview dialog?

Ans Yes

does it happen on any list box? or just this specific one?

Ans Yes

I feel, its a 9.0 SR3 issue(bug). Please check if you get a chance.

Thanks,

Siddharth

conditional show issue

johnw — Fri, 30 Jul 2010 23:12:14 GMT

I suspect you're right about it being a 9.0 SR3 bug. It's working correctly for me in 9.0 SR5.

conditional show issue

pkelly — Fri, 30 Jul 2010 23:12:48 GMT

I have also experienced this problem.

I found that if you change the layer to custom 99, the bx will re-appear.

We have just moved to SR5 and as yet I haven't seen this happen - might be worthwile upgrading?

conditional show issue

siddharth_kulka — Mon, 02 Aug 2010 16:06:56 GMT

Paul,

I changed the custom layer to 99, but the issue still exists.

Thanks everyone!

conditional show issue

Mon, 02 Aug 2010 16:35:10 GMT

Yes, it looks like a bug. I have come across several instances of this. As suggested above, upgrading to a later SR should solve the problem.

conditional show issue

wizardo — Mon, 02 Aug 2010 20:56:35 GMT

i tried it on sr3 and i found out tjhat eac htime i changed the layer number (EG from 99 to 98) the listbox reappeared but disappeared again after i changed the variable value

changing the layer number again and it appeared and so fort and so on

seems like a bug indeed

conditional show issue

Tue, 03 Aug 2010 10:34:11 GMT

I've just upgraded to SR5 and the problem is fixed. Definitely a bug.

conditional show issue

Tue, 03 Aug 2010 10:48:28 GMT

Wow! I think I spoke too soon!

Now it appears that the Error Message I specified doesn't work. I have the following Calculation Condition.

GETSELECTEDCOUNT([Check-in Year])=1

The error displayed is: "Too Few Dimensions" which doesn't appear in the list of error messages to override. Even when I change the default error message it makes no difference.

Looks like another bug!

conditional show issue

kji — Tue, 03 Aug 2010 12:22:51 GMT

Overridable error messages are only those concerned with the calculation of the object, drawing related errors cannot be overriden.

conditional show issue

Tue, 03 Aug 2010 13:21:51 GMT

Sorry, I don't completely understand your post.

I have set a calculation condition on an object which works correctly. When the calculation condition is not met, I expect the "Calculation condition unfulfilled" error message to appear. This can be overriden by using a custom message. It works exactly that way on a PT I have in my app and also on other charts but does not work on a Trellis chart. The Trellis chart always displays "Too few dimensions" when I use the calc condition. When I remove the calc condition the chart displays but displays incorrectly. I don't see why the rules for a Trellis would be different to every other type of object.

I'm using v9.0 SR5.

Try it and see if you get the same issue.

conditional show issue

kji — Tue, 03 Aug 2010 14:20:31 GMT

I had a look at it and it seems that for trellis charts the code to split up the data into the individual trellises will run, discovering there isn't any dimension to split and thus give the "Too few dimensions" error, so defenitely looks like a bug.

conditional show issue

Wed, 04 Aug 2010 16:08:20 GMT

Sid,

Please see file with the attached alternative solution.

conditional show issue

siddharth_kulka — Wed, 04 Aug 2010 16:15:52 GMT

Its working in 8.5, but not in 9.0

Thanks!

conditional show issue

Wed, 04 Aug 2010 16:17:24 GMT

I am also on 9.0 SR3 and it is working fine.