sheet objects visible based on listbox selections

[#1]

Hi,

I am new to qlikview and i am posting one of the scenarios where i am trying alot.

\

[johngouws]

Hi,

You can set the Layout / Show / Condition in the Chart Properties.

I am using a similar scenario where I have a multiple condition to be met, before showing the Chart.

Try something like =GetSelectedCount(Table_1) = 1 and GetSelectedCount(Table_2) >= 1.

Note the = and >= conditions.

[#3]

For each chart you can use the GetSelectedCount(<field>) function in the Show Conditional textbox to display the chart when a value is selected from the list box.

If you are only looking to show a chart based on a selection of one field, you can do something like this:

• For the "Year vs Sales" chart, you can add GetSelectedCount(Year) > 0
• For the "Market vs Sales" chart, you can add GetSelectedCount(Market) > 0

[#4]

Thnaks Lior Abitbol for your soltion.

It works fine but at the same time I need to both charts based on year and sales i.e now with this approach I could able to get any one of the chart either for sales or for Year. But I need both charts should be visible upon different selections.

if I select on Year chart should be visible and if I select on Sales the other chart should also be visible

can you clarify on the same

[#5]

No problem, just add both expressions to the conditional show textbox with and "and":

GetSelectedCount(Year) > 0 and GetSelectedCount(Market) > 0

[#6]

Maybe I am misunderstanding, Do you want both charts to be visible when any of the selections are made (i.e. Year, Market or Sales)? If that's the case, use an "or" with the following condition for both charts:

GetSelectedCount(Year) > 0 or GetSelectedCount(Market) > 0 or GetSelectedCount(Sales) > 0

[#7]

If I made selections on Year .chart should be visible and if I made selctions on Sales chart should be dispayed and at the same time first chart should not be hidden .