topic Re: Hide and Show in QlikView

Hide and Show

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

Hi All. Please anyone tell me how to show and hide Object in QlikView using List Box Object. Thank You

andrey_krylov — Fri, 24 Aug 2018 04:06:48 GMT

Like this?

vipin_mishra479 — Fri, 24 Aug 2018 05:40:53 GMT

Hi. you can do it using variables

i give an example

Try this,

Variable ->vhide

Value:

=If(vhide = 0, 1, 0)

In chart, use vhide variable in Layut-conditional - show = vhide

with this variable you can show/hide all the object

Thanks !!

Vinod — Fri, 24 Aug 2018 10:33:05 GMT

Application not opening.It is showing error.

Vinod — Fri, 24 Aug 2018 10:41:38 GMT

Hi Vipin Mishra. I Know this logic. I wan't to know using List Box object.

andrey_krylov — Fri, 24 Aug 2018 10:54:11 GMT

Ok, then in load script add

LOAD * INLINE [

Objects

Object 1

Object 2

Object 3

];

Put List Box [Object] on sheet and in any object properties Layout -> Show-> Conditional paste

GetSelectedCount(Objects) > 0 and WildMatch('Object 1', $(=Chr(39)&Concat(Objects,Chr(39)&Chr(44)&Chr(39))&Chr(39)))

Now this object is visible only when you select "Object 1" in "Objects"

Vinod — Fri, 24 Aug 2018 11:00:40 GMT

Thank You. It's working but I didn't understand this code $(=Chr(39)&Concat(Objects,Chr(39)&Chr(44)&Chr(39))&Chr(39))). Can You please explain.

andrey_krylov — Fri, 24 Aug 2018 11:04:14 GMT

It gives a string like 'Object 1', 'Object 2' - selected values of [Objects].