topic Re: Help me in hiding a chart? in QlikView

Help me in hiding a chart?

durgabhavani — Mon, 27 Apr 2015 06:19:56 GMT

Hi All,

I have two charts

1. barchart

2. straight table

By default straight table need to be in hidden status. when i required to show the straight table i need to unhide the straight table.

How to implement this, please advice me.

Thanks,

Durga

Re: Help me in hiding a chart?

jjordaan — Mon, 27 Apr 2015 06:29:56 GMT

Hi Durga,

You can use conditional show this.

The conditional option you can in the layout tab.

Create an variable called vShow.

Create are button which set the variable to 0 or 1.

In the conditional show option you can it like If(vShow = 1, 1,0).

Hope this helps

Re: Help me in hiding a chart?

danieloberbilli — Mon, 27 Apr 2015 06:29:56 GMT

you can use a textbox as a button that shows/hides the object.

set a variable e.g. vShowChart = 0

and set a trigger action in the text box Variable vShowChart

=Not(vShowChart)

Please find attached.

Cheers

Daniel

Re: Help me in hiding a chart?

amit_saini — Mon, 27 Apr 2015 06:31:09 GMT

Hi,

Like this????

Thanks,
AS

Re: Help me in hiding a chart?

vvvvvvizard — Mon, 27 Apr 2015 06:43:06 GMT

minimize the table and save the model . double click it to unhide it .

Re: Help me in hiding a chart?

Mon, 27 Apr 2015 06:55:40 GMT

Hi durga

There are few inbuilt option in application from where you can hide the chart or column please refer below URL it help you

http://qlikviewcookbook.com/2014/04/using-column-visibility/

Thanks

Re: Help me in hiding a chart?

durgabhavani — Mon, 27 Apr 2015 06:58:50 GMT

Thanks everyone for responses!

Without textobject or button, we cant able to hide the straght table using the barchart.

If possible please let me know.

Thanks,

Durga

Re: Help me in hiding a chart?

danieloberbilli — Mon, 27 Apr 2015 07:23:42 GMT

The button or textbox is just one way to change the variable. You could also use a sheet trigger to change the variable or based on a certain data condition. If it should be am admin only function, you could also just open the variable overview and change the value manually

Re: Help me in hiding a chart?

durgabhavani — Mon, 27 Apr 2015 15:50:32 GMT

Thanks Saumil. Much useful

Durga