List box as filter vs filter in code?

Anonymous — Thu, 27 Apr 2017 17:11:53 GMT

Hi,

I have a filter in a chart like the following:

= count({$<[Request Status]={'Work in Progress','Monitor',' '}>} DISTINCT [AutoID])

Also I have a list box filter for that field, the problem is that as the code inside the chart will include these 2 values, if I use the filter it won't apply in that chart. For example, if I use the list box filter for Request Status], and select "Work in Progress" I want that the chart only displays the "Work in Progress" records. Based on the expression it's not working.

Is there a way that the filter outside the chart will affect this chart besides the code inside?

Re: List box as filter vs filter in code?

sunny_talwar — Thu, 27 Apr 2017 17:13:14 GMT

Try this

=Count({$<[Request Status] *= {'Work in Progress','Monitor',' '}>} DISTINCT [AutoID])

Implicit Set Operators

topic Re: List box as filter vs filter in code? in QlikView

List box as filter vs filter in code?

Re: List box as filter vs filter in code?