Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Ahhh ... found it, thank you. It is:
Qlik Sense September 2018 - 12.36.1
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.
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.