Combine set expression with list box

Janneke — Tue, 18 Sep 2018 07:07:45 GMT

Hi all,

Can anyone help with the following?

I have a chart in which set analysis is used. Simplified the expression is:

=Count(DISTINCT {$<Year={2018,2017,2016}>}Year)

In the app is also a list box containing Year.

What I want: A chart in which only the three mentioned values are shown. When the list box is used, I want to further filter the chart. Example:

However, what I get: The chart doesn't respond to the list box. I thought using the dollar-sign would make it possible to further filter, but it's not. Example:

Can you provide me with a solution for this? Thanks in advance!

Greetings, Janneke.

Re: Combine set expression with list box

marcus_sommer — Tue, 18 Sep 2018 07:22:13 GMT

Try it with this one: =Count(DISTINCT {$<Year *= {2018,2017,2016}>}Year)

- Marcus

Re: Combine set expression with list box

Janneke — Tue, 18 Sep 2018 07:32:29 GMT

Hi Marcus,

Thanks a lot, this does the trick!

Janneke.

topic Combine set expression with list box in QlikView

Combine set expression with list box

Re: Combine set expression with list box

Re: Combine set expression with list box