topic Re: sheet objects visible based on listbox selections in QlikView

sheet objects visible based on listbox selections

Sun, 06 Jul 2014 14:02:34 GMT

Hi,

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

Re: sheet objects visible based on listbox selections

johngouws — Sun, 06 Jul 2014 14:46:26 GMT

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.

Re: sheet objects visible based on listbox selections

Sun, 06 Jul 2014 20:53:32 GMT

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

Re: sheet objects visible based on listbox selections

Mon, 07 Jul 2014 02:15:27 GMT

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

Re: sheet objects visible based on listbox selections

Mon, 07 Jul 2014 02:43:15 GMT

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

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

Re: sheet objects visible based on listbox selections

Mon, 07 Jul 2014 02:49:53 GMT

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

Re: sheet objects visible based on listbox selections

Mon, 07 Jul 2014 03:19:25 GMT

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 .