topic Re: Hide Table on selection in list Box in QlikView

Hide Table on selection in list Box

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

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

Re: Hide Table on selection in list Box

sunny_talwar — Thu, 31 Mar 2016 13:15:11 GMT

May be try this condition for your Dept1:

=GetFieldSelection(ListBoxField) = 'Dept1'

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

Re: Hide Table on selection in list Box

swuehl — Thu, 31 Mar 2016 13:17:15 GMT

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

Re: Hide Table on selection in list Box

sspawar88 — Thu, 31 Mar 2016 13:20:55 GMT

But my table is already created.

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

Re: Hide Table on selection in list Box

sspawar88 — Thu, 31 Mar 2016 13:21:25 GMT

But my table is already created.

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

Re: Hide Table on selection in list Box

sunny_talwar — Thu, 31 Mar 2016 13:23:24 GMT

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

Re: Hide Table on selection in list Box

swuehl — Thu, 31 Mar 2016 13:23:55 GMT

Sorry, I don't understand.

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

Re: Hide Table on selection in list Box

awhitfield — Thu, 31 Mar 2016 13:26:40 GMT

Hi satish,

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

HTH

Andy

Re: Hide Table on selection in list Box

Peter_Cammaert — Thu, 31 Mar 2016 13:27:20 GMT

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

Re: Hide Table on selection in list Box

sspawar88 — Thu, 31 Mar 2016 14:31:27 GMT

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

Re: Hide Table on selection in list Box

sunny_talwar — Thu, 31 Mar 2016 14:33:06 GMT

You will have to specify the name of the field without single quote and on what value you would want to see your table based on

=GetFieldSelections(Field_Name) = 'Value'

Re: Hide Table on selection in list Box

swuehl — Thu, 31 Mar 2016 14:37:53 GMT

Or maybe use this as conditional expression:

=Sum({<FIELD_NAME *= {'Department 1'}>} 1)

replace FIELD_NAME and the field value to check with your field name used and field value to check.

This will also work with multiple selections, but it will show the chart also if no selections are made (default QV logic).

Re: Hide Table on selection in list Box

sspawar88 — Thu, 31 Mar 2016 14:41:46 GMT

without single quote it is showing error.

By assuming the filed name AB-AC, when i click on that in my list box, alredy created table should be invisible.

what would be the expression?

Re: Hide Table on selection in list Box

Peter_Cammaert — Thu, 31 Mar 2016 14:52:21 GMT

For demonstration purposes, you cannot have both a listbox field called 'AB-AC' and a selected value 'AB-AC' in that same listbox.

If I have a listbox displaying a field called 'DepartmentNames', and I have a chart called 'Dep1_figures' that should be visible whenever I select value 'Dept1' in listbox 'DepartmentNames', use this as conditional show expression:

=GetFieldSelections(DepartmentNames) = 'Dept1'

This won't display any chart at all whenever you select more than one value in the listbox. Better enable AlwaysOneSelected in the Listbox properties. Or use WildMatch().

Peter

PS Andrew's example document below shows you exactly how you should proceed to get the intended effect.

Re: Hide Table on selection in list Box

sspawar88 — Thu, 31 Mar 2016 15:06:59 GMT

SUPPOSE i'm having' list box in which one filed is 'CHEQUE_MONTHLY-CQDF60' and i have created diffrent one table.

what will be the expression for conditional layout?

Re: Hide Table on selection in list Box

Peter_Cammaert — Thu, 31 Mar 2016 15:13:42 GMT

Same as with your previous post: there is a difference between the name of the field you want to check, and the actual value in that field you want to check. Let me reply with two questions. Your answers may resolve this issue as clearly as possible:

You say you have a listbox in your document. What is the name of the field this listbox is displaying? To find out, rightclick the listbox, select Properties from the menu, go to the General tab and copy the text that is displayed in the Field selection list.

You say you have a table that should be made visible only if a very specific value is selected in that listbox. What is the value that must be selected to display table 1? To find out, press the Clear button in the toolbar, select that particular value in your listbox, and whatever text is now displayed in bright green, you copy in your reply.

At best, you should be able to reply with two values (and not just one like you seem to prefer):

1. Field name = ..........

2. Selected value = ...........

Best,

Peter

Re: Hide Table on selection in list Box

HirisH_V7 — Thu, 31 Mar 2016 15:31:54 GMT

Hi ,

Check this,

Show/Hide image based on Listbox value selection

Re: Hide Table on selection in list Box

awhitfield — Thu, 31 Mar 2016 15:37:57 GMT

Check my example!

Re: Hide Table on selection in list Box

sspawar88 — Thu, 31 Mar 2016 16:30:14 GMT

yes. i download it.

but i dont know why there is no any expression in it.

Can you please check.

Re: Hide Table on selection in list Box

sunny_talwar — Thu, 31 Mar 2016 16:31:46 GMT

I see it