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? 

[tresesco]

Could you post the expression you used to mark them D or E? Sample qvf would be even better, if you could share.

[uroboros]

Do you have a distinct counting?

[Gabriel]

Hi,

Can you attach qvf? This will help resolve the issue as the problem is in the data model

[Rodney]

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. 

[Rodney]

"Do you have a distinct counting?"

No, I don't think so. I've now attached the expression. 
Thanks.

[Rodney]

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' )

[Øystein_Kolsrud]

If I'm not mistaken, I think there have been some changes in this domain in later releases of Qlik Sense. What version are you using?

[Rodney]

Good question. When I go to the Site License Page in the QMC, I see this: 

PRODUCTLEVEL;50;;2019-03-31

Is this the version? 

[Øystein_Kolsrud]

No, that's information related to your license I think. You should find the version information down in the bottom right corner of the start page of the QMC. In the Hub, you can get the information from the "About" section accessible from the menu in the top right corner.