topic Visibilitey Off.. in QlikView

Visibilitey Off..

Fri, 31 Dec 2010 10:41:19 GMT

How can i off the visibility off text box when condition is satisfy.

Suppose weight is greater than 500kg i want to off the visibility of textbox1 and visible textbox2

weight is below 500kg 1 want to visible textbox1 and visibilty off textbox2.

Sukamal

Visibilitey Off..

Miguel_Angel_Baeyens — Fri, 31 Dec 2010 10:57:54 GMT

Hello Sukamal,

If field is "Weight" and value is "500" then, the conditional for TextBox 1 is

Weight < 500

for TextBox 2

Weight >= 500

If value is a string "500kg" I'd first remove the trailing "kg".

Hope that helps

Visibilitey Off..

Fri, 31 Dec 2010 11:02:40 GMT

Hi Miguel,

How i write the condition. pls give me the example. How i switch on or switch off the visibility of text box. pls say what i write in show condition. I am using qlikview 10.

Visibilitey Off..

Miguel_Angel_Baeyens — Fri, 31 Dec 2010 11:36:16 GMT

The example above is the way you have to write conditionals to show/hide objects. Just change "Weight" and "500" for your field name and value.

Regards.