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):
Solved! Go to 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.
here's the expression.
It's a QlikSense application and the company is pretty sensitive to their data, so I don't think i can post any of the source files I'm afraid.
I've now simplified the expression so that there are only two values (not 3 as in the original).
But still have the same issue.
477 Showing in Total. 29 when I select E, but 477 showing when I select D.
= if ( Match ( weekday( [Date] , 6) , 'Thu.' , 'Sat.' , 'Sun.') OR ([Start Time] < '17:00') , 'D' , 'E' )