Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Rodney
New Contributor III

Filtering not working

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. Filter1.PNG

 

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

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

 Why not? 

7 Replies
MVP
MVP

Re: Filtering not working

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

Re: Filtering not working

Do you have a distinct counting?

Gabriel
Valued Contributor II

Re: Filtering not working

Hi,

 

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

Rodney
New Contributor III

Re: Filtering not working

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
New Contributor III

Re: Filtering not working

"Do you have a distinct counting?"

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

Rodney
New Contributor III

Re: Filtering not working

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

Re: Filtering not working

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?
Community Browser