Filtering not working

[Rodney]

Help please! 

As per the first image, we have a simple grid with 477 records. We have a formula which looks at the date and time and depending on that combination, marks it as either a D or an E.

If we want to filter by D or E it will work for E, and give us the 29 records:

 but not when we select D (you can see it still selects all 477 records):

 Why not? 

[Rodney]

Ahhh ... found it, thank you. It is:


Qlik Sense September 2018 - 12.36.1

[Øystein_Kolsrud]

I was unable to reproduce the behavior your are seeing with that release. I think you would probably have to provide a QVF that exhibits the behavior for us to help.

[Rodney · Accepted solution]

Thanks for trying. I've given up too, but found a work-a-around ... 

I am putting the function that looks at the data and returns D/E in the SQL View, and returning this as an extra column. Then I add this field to the report and it filters fine.