Apply a Filter with no matches

[#1]

Hello,

I have a bit of an odd question. I am creating a button that will apply a filter. I want this filter to be applied even if no matches are returned - i.e., tables will be empty.

As of right now, the behavior is that if there are no records to match the filter, QlikView just shows all the records. Anyone know a way to do this?

Thanks,

Christian

[Anonymous · Accepted solution]

Apply   any of getselectedcount(field)>=1  or  getpossiblecount(field)>=1 as caluculation condition of chart general properties.

and in error message set as 'no match found' in  calculation condition unfulfilled

this way it will not show any results, until there is a match

[Anonymous]

See attached example.

Notice what happens if you select value 'D' in Dim1 (actually it is renamed %Dim1), 'h' in Dim2, or 'W' in Dim3.

The solution is in the expression of the chart.

[#4]

This solution worked well for me. For future reference of anyone that reads it later, I had multiple filter buttons a user could select, so I added a variable for each button to add to the Calculation Condition of the chart and then OR'ed them together. Seems to be working.

[#5]

Hi Christian.  Can you show me how you did this.   I'm trying to do the same thing.  Appreciate it.