topic Re: Use Object ID in an expression in QlikView

Use Object ID in an expression

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

HI,

Am I able to use object ID in an expression.

I want, for example, Textbox B to be visible when textbox A is hidden, Textbox B to be hidden when textbox A is visible.

I have something in my mind like

if( ObjectID(for textbox A) =1, ObjectID(for textbox B) to 0,ObjectID(for textbox B)=1 )

Re: Use Object ID in an expression

Anil_Babu_Samineni — Thu, 08 Dec 2016 01:58:59 GMT

Where you want to implement this, I mena which senario

Re: Use Object ID in an expression

Anonymous — Thu, 08 Dec 2016 02:15:23 GMT

I have a Textbox a with some condition that will hidden or visible. Now I want a textbox B with condition to be hidden or visible based on textbox visibility.

Re: Use Object ID in an expression

Anil_Babu_Samineni — Thu, 08 Dec 2016 02:19:41 GMT

You want to hide only One Text object or all objects which is related to Text object.

Let me explain bit more, What was happen Some client need to be as if one Text object is visible they want hide remaining Text objects (That qlik has capable). But, If you want to hide only that sheet (It bit difficult to justify). Somehow, I need more analysis on the same

Can you clarify me on this

Re: Use Object ID in an expression

Anonymous — Thu, 08 Dec 2016 02:30:16 GMT

hi, I guess I only want to hid one object. In fact, is more of hide a text object when 3 text object is visible. There are all in the same sheet.

Re: Use Object ID in an expression

susovan — Thu, 08 Dec 2016 06:25:33 GMT

May be like this,

But I used variable to hide the object.

PFA

Re: Use Object ID in an expression

Anonymous — Thu, 08 Dec 2016 06:27:30 GMT

Hi,

able to screenshot the script and varibles? I am unable to view due to personal editions. Sorry for the trouble.

Re: Use Object ID in an expression

susovan — Thu, 08 Dec 2016 06:34:21 GMT

For TextBox1:

Action

Variable : VHidden

Value : 1
Layout

Conditional : =vHidden=0

For TextBox2:

Action

Variable : VHidden

Value : 0
Layout

Conditional : =vHidden=1

Please find the attached images for the ready reference.

Re: Use Object ID in an expression

Anonymous — Fri, 09 Dec 2016 02:56:59 GMT

This is what I have enter on both the texboxs. However, but textbox is hidden. Not sure what I am missing out

Re: Use Object ID in an expression

tamilarasu — Fri, 09 Dec 2016 03:07:49 GMT

Hi Jia,

Variables are case sensitive. Type the correct varibale name (whatever you created in variable overview window) in your Textbox1 action and layout properties.

vHidden => Vhidden

Re: Use Object ID in an expression

susovan — Fri, 09 Dec 2016 05:48:05 GMT

You have enter the value for this (VHidden) Variable,

Like Value =1 or =0