topic Show/hide multiple tables based on selection in QlikView

Show/hide multiple tables based on selection

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

Dear Experts:

Please note, there are four tables in my app - 1. Sales, 2. Budget, 3. Forecast I and 4. Forecast II

I have to show them based on selection from "Type" List Box and to do that I have set condition in "Layout" tab like the following

Now the app shows the tables accordingly.

But if I select multiple items from the list box all the tables disappear.

According to client requirement, in the given scenario Sales and Budget tables need to be shown.

Looking forward to your suggestions.

Ahammad Shafi

jonathandienst — Fri, 01 Apr 2016 06:23:30 GMT

Use a conditions like:

=WildMatch(Concat(Type), '*Act*')

=WildMatch(Concat(Type), '*Bud*')

Chanty4u — Fri, 01 Apr 2016 06:23:44 GMT

try something lik below

=if(

(GetFieldSelections ([filed])='no'

or GetSelectedCount([YourFlag])=0

or GetSelectedCount([YourFlag])=2

)

,Expression1

,Expression2

)

Chanty4u — Fri, 01 Apr 2016 06:26:14 GMT

=GetSelectedCount(filed)=1

=GetSelectedCount(filed)='value';

ahammadshafi — Fri, 01 Apr 2016 06:38:56 GMT

Hi Jonathan:

Many thanks, it works fine with one exception - when I select "Forecast II" it shows two tables (Forecast I and Forecast II).

The condition I have set in "Forecast I" table is "=WildMatch(Concat(Type),'*Forecast I*')"

and in "Forecast II" table is "=WildMatch(Concat(Type), '*Forecast II*')"

jonathandienst — Fri, 01 Apr 2016 06:41:01 GMT

Add a delimiter like a pipe |, so that you can distinguish these:

=WildMatch('|'& Concat(Type, '|') & '|', '*|Act|*')

=WildMatch('|'& Concat(Type, '|') & '|', '*|Forecast I|*')

ahammadshafi — Fri, 01 Apr 2016 07:02:43 GMT

Many thanks to both of you. Got it resolved