Hide Table on selection in list Box

[sspawar88]

Hi Community,

if i'm having one list box which are having seven department name.

i have created seven different table in which contain all related column of department separately.

how can i implement

--> When i click on one department name the related table should appear other should be hide.

what can i do for it in my qlikview application.?

[sunny_talwar]

May be try this condition for your Dept1:

=GetFieldSelection(ListBoxField) = 'Dept1'

Change the Dept1 to Dept2,3,4 for the other tables

[swuehl]

And use above in the show conditional on layout tab of your chart properties.

[sspawar88]

But my table is already created.

i just want to hide or show them as per my selection in list box.

[sspawar88]

But my table is already created.

i just want to hide or show them as per my selection in list box.

[sunny_talwar]

Yes and to hide/show them based on selection, you can add the provided expression on the Layout tab of the chart properties.

[swuehl]

Sorry, I don't understand.

We suggested a show conditional set on your already created chart objects. Have you tried it?

[awhitfield]

Hi satish,

simple example attached using condition displayed on the "layout" tabs of the charts.

HTH

Andy

[Peter_Cammaert]

But my table is already created.

:

No problem. Every object in QlikView has a conditional show option. Usually it is set at "Always", making every object visible at all times. In an existing object you can change this to "Conditional" and enter an expression that determines whether the current object should be visible (true or -1) or not (false or 0)

In your Straight/Pivot table, open Chart Properties->Layout and check the "Shiow" group (right in the middle). Then follow the instructions of Sunny and Stefan.

Since you have multiple tables that should appear only when a specific value is chosen, you'll have to repeat these steps N times with different test values.

Peter

[sspawar88]

=IF(GetFieldSelectionS('FIELD_NAME'),-1,0)

when i put above expression my created table layout>show>conditional expression.

its not working.

what is mistake in above expression?