Discussion board where members can get started with Qlik Sense.
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):
Do you have a distinct counting?
Can you attach qvf? This will help resolve the issue as the problem is in the data model
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.
"Do you have a distinct counting?"No, I don't think so. I've now attached the expression. Thanks.
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')
, 'E' )