topic Re: Apply a Filter with no matches in QlikView

Apply a Filter with no matches

Thu, 21 May 2015 22:30:53 GMT

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

Re: Apply a Filter with no matches

Anonymous — Thu, 21 May 2015 22:54:37 GMT

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

Re: Apply a Filter with no matches

Anonymous — Fri, 22 May 2015 00:06:00 GMT

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.

Re: Apply a Filter with no matches

Fri, 22 May 2015 04:48:53 GMT

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.

Re: Apply a Filter with no matches

Thu, 31 Mar 2016 05:09:34 GMT

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