topic Re: not filter null values in QlikView

not filter null values

stekol61 — Thu, 14 Nov 2019 15:21:21 GMT

Hi!

In my app I'm loading tickets.

I use a filer to select tickets that has 'Start date' in e.g. October.

I also has filter that should select tickets with 'Cleared Date' for the same month.

The problem with the 'Cleared Date' filter is that it excludes tickets with no value.

I want the filer to show ticket that has a 'Cleared Date' but also tickets with no value

Brett_Bleess — Tue, 19 Nov 2019 15:23:39 GMT

Stefan, any chance you can attach a sample QVW, I think it would be very helpful in getting you some responses on this one?

Regards,
Brett

stekol61 — Wed, 20 Nov 2019 08:45:47 GMT

Hi!

I have a filter for 'Clear Date'.

If I add a filter for e.g '2019-10' I want to see all dates for October but also all blank row's.

Is that possible?