topic Re: Conditional Show Hide in QlikView

Conditional Show Hide

Wed, 25 Nov 2020 16:16:04 GMT

How to conditionally show a straight table based on the slection made in list box.I know this has been already discussed but couldnt find it at the moment .

In List box I have ID

When I select 1 from the list box I want the straight table to pop up with Details associated to that ID.

ID Address City State Zip

1 ABCD ab bc 123

Thanks much

Re: Conditional Show Hide

sunny_talwar — Tue, 14 Jun 2016 11:50:34 GMT

May be the show/hide condition like this:

=SubStringCount(Concat(DISTINCT '|' & ID & '|'), '|1|') = 1

=ID = 1

Re: Conditional Show Hide

tresB — Tue, 14 Jun 2016 11:52:08 GMT

You can create a straight table. Layout tab->Show->Conditional exp: =getselectedcount(ID)>0

Re: Conditional Show Hide

susovan — Tue, 14 Jun 2016 12:00:34 GMT

Hi pavana,

Try this attachment,

Re: Conditional Show Hide

sasiparupudi1 — Tue, 14 Jun 2016 12:35:46 GMT

In the layout tab,

under show section, select conditional and add the following expression

=GetFieldSelections(ID)=1

hth

Sasi