topic Re: List box in QlikView

List box

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

Hi,

I have values in list box and two pie chart

When I Click the values in list box,only one pie chart should be affected.

The other sheet objects should not be affected.

How to set the target properties?

please help

Re: List box

Anil_Babu_Samineni — Mon, 20 Nov 2017 09:39:52 GMT

Try to use Alternate States

Re: List box

shanky1907 — Mon, 20 Nov 2017 09:39:58 GMT

Can you share the details of your expression for the Pie Chart?

Re: List box

PrashantSangle — Mon, 20 Nov 2017 09:40:35 GMT

either nullify those field in 2nd pie chart

or use alternate state..

Regards,

Re: List box

jonathandienst — Mon, 20 Nov 2017 09:42:18 GMT

>>How to set the target properties?

Not sure what you mean by that. Selections in a list box apply to the entire model.

On the 'unaffected' chart, you need to override the selections (in the pie chart expressions), or look into alternate states if that is more appropriate. Both options are covered by many articles here in the forum.

Re: List box

Anonymous — Mon, 20 Nov 2017 09:48:46 GMT

can you tell me how to use alternate state

Re: List box

Anonymous — Mon, 20 Nov 2017 09:52:47 GMT

I have attached a screen shot

in that I have a list box with date filed. When I click that date only the values of completed last week pie chart should be affected.

The inflight pie chart should remain unchanged all time

Re: List box

shanky1907 — Mon, 20 Nov 2017 09:58:28 GMT

You can use 1 as identifier in the set expression for IN Flight Pie Chart

Re: List box

woshua5550 — Mon, 20 Nov 2017 09:58:45 GMT

when you want to ignore user selection of one specific field in chart you can use syntax like this:

Sum({<Date = >}Sales)

see the sample app attached

Re: List box

Anil_Babu_Samineni — Mon, 20 Nov 2017 10:00:49 GMT

From help clearly stated !! Alternate States ‒ QlikView

Re: List box

Anonymous — Mon, 20 Nov 2017 10:30:06 GMT

Hi Dhivya,

You can exclude the selection (list box) field in the particular pie chart

Ex:

sum({<account_type=>}[Net Actual])

Above account type selection will not affect any selections in the charts

-Jai