topic Chart: Counts not changing based of list box in QlikView

Chart: Counts not changing based of list box

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

See attached sample.

When I select the listbox "INDICATOR" YES the value does not change in the chart.

When I select "YES" the value should change from 5 to 4. Any thoughts on how I can fix?

Re: Chart: Counts not changing based of list box

md_qlikview — Mon, 24 Jul 2017 19:51:17 GMT

Hi,

Instead of COUNT({<INDICATOR= {'YES','NO'}>} ID) try Count(ID) only. You have specified modifier as indicatror in your expression cause of which value is not changing.

Re: Chart: Counts not changing based of list box

sunny_talwar — Tue, 25 Jul 2017 00:48:13 GMT

Milind is right, but in case set analysis is needed because INDICATOR have more then the two values you have in your sample and you want the chart to only show YES and NO... then you can try this

COUNT({<INDICATOR *= {'YES','NO'}>} ID)

Read about the usage of asterisk here:

Implicit Set Operators