Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Combine set expression with list box

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.

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

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

- Marcus

View solution in original post

2 Replies
Highlighted
MVP & Luminary
MVP & Luminary

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

- Marcus

View solution in original post

Highlighted
Creator
Creator

Hi Marcus,

Thanks a lot, this does the trick!

Janneke.