topic Re: Show a chart only when a list of values is selected in a ListBox in QlikView

Show a chart only when a list of values is selected in a ListBox

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

Hi there,

I have a chart that I want to show conditionally, only if a certain (specific) list of values is selected in a ListBox. In the example below, the "Monthly Extra Costs" chart should display only when "A. PALAZUELOS Y CIA, S.C.", "AKZENT LOGISTICS, S.A. DE C.V." and "ARCATEK, S.A. DE C.V." are selected in the 'Cliente_US' listbox (all of them).

Please, how can I accomplish this?

Thanks and kind regards.

-E. Alvarez

Re: Show a chart only when a list of values is selected in a ListBox

Arthur_Fong — Thu, 07 Nov 2019 01:11:43 GMT

In chart properties > layout > Show conditional :

if(match(GetFieldSelections(Cliente_US),'A. PALAZUELOS Y CIA, S.C.', 'AKZENT LOGISTICS, S.A. DE C.V.','ARCATEK, S.A. DE C.V.'),1,0)

Re: Show a chart only when a list of values is selected in a ListBox

eadbhard — Thu, 07 Nov 2019 01:34:39 GMT

Thanks, but with this solution, the chart is shown if I select just one of the required values in the ListBox. If I select two or all three values, the chart is not shown.

Now, would it be possible to show the chart when any combination of the required values is selected, being just one value, any two values, or all three?

Thanks and kind regards,

-E. Alvarez

Re: Show a chart only when a list of values is selected in a ListBox

Arthur_Fong — Thu, 07 Nov 2019 01:44:14 GMT

Try this:

if(GetSelectedCount(Cliente_US)>0,1,0)

Re: Show a chart only when a list of values is selected in a ListBox

eadbhard — Thu, 07 Nov 2019 17:24:56 GMT

I found the solution 😊

=If(SubStringCount(GetFieldSelections(Cliente_US),'A. PALAZUELOS Y CIA, S.C.') +
SubStringCount(GetFieldSelections(Cliente_US),'AKZENT LOGISTICS, S.A. DE C.V.') +
SubStringCount(GetFieldSelections(Cliente_US),'ARCATEK, S.A. DE C.V.')>0,1,0)

With this, the chart is shown when any combination of the company names is selected, either just one company, or any two companies, or all three companies. Selecting any other company in the ListBox (or clearing all selections) makes the chart disappear.

SubStringCount() did the trick here, this function gets along better with GetFieldSelections() than Match().

Thanks for all the help!