Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sspawar88
Creator II
Creator II

Hide Table on selection in list Box


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.?

1 Solution

Accepted Solutions
sunny_talwar

25 Replies
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
MVP
MVP

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

sspawar88
Creator II
Creator II
Author

But my table is already created.

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

sspawar88
Creator II
Creator II
Author

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
MVP
MVP

Sorry, I don't understand.

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

awhitfield
Partner
Partner

Hi satish,

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

HTH

Andy

Peter_Cammaert
Partner
Partner

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
Creator II
Creator II
Author

=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?