Question: When filtering if your second filter resets first filter is there a way to have it say no records match instead?

Thu, 11 Oct 2012 13:10:47 GMT

Lets say you have 2 filters.

The first is market

The second is Radio Station.

If you pick NY you can limit the filter to only show matching but that's not what the boss wants. He wants it to say NO MATCHING RECORDS if you then picked a LA Radio Station instead of the normal behavoir where it resets the market from NY to LA because you picked a LA station.

Can you guys think of any way to overide the regular behavior of Qlikview?

Re: Question: When filtering if your second filter resets first filter is there a way to have it say no records match instead?

johnw — Thu, 11 Oct 2012 23:32:30 GMT

I believe the quick answer is "It is not possible to override this default behavior. Your boss will have to get used to using QlikView the way QlikView works."

Unfortunately, that's not the end of the story. You can probably make it look like you're overriding the default behavior even though you can't actually do so. One solution that might work for smaller data sets is to create a table with every combination of attributes. You can then make any combination of selections, and it will never wipe out other selections. If that combination of attributes results in no actual data being returned, then charts displaying actual data will instead display "No data to display". We can also change the chart caption to give the desired message. On the down side, it takes a potentially impossibly large table to include every combination of attributes, and you won't get other nice default QlikView behavior like graying out selections that don't match data.

See attached.

There are surely other workarounds if this one isn't practical. This is just the first thing I thought of.

topic Question: When filtering if your second filter resets first filter is there a way to have it say no records match instead? in QlikView

Question: When filtering if your second filter resets first filter is there a way to have it say no records match instead?

Re: Question: When filtering if your second filter resets first filter is there a way to have it say no records match instead?