Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
savithri_n_s
Contributor III
Contributor III

Filters not working

Hi Team,

 

Filters not giving proper results.

If i filter for FY20 and Sep. PO count should be 152 and Requestor count should be 57

instead of PO count :144 and  Requestor count :53.

Can you please help?

 

Regards,

Savithri

 

Labels (1)
3 Replies
agigliotti
Partner - Champion
Partner - Champion

which PO_NUMBER_SP_PO values do you think are missing  ?

savithri_n_s
Contributor III
Contributor III
Author

I feel something wrong the expression

None of the values are missing

Brett_Bleess
Former Employee
Former Employee

Are you referring to FY_SPO and REQUESTOR_SP_PO fields?  If not, need to know which fields you are using here to look into things, but generally what I do is use a Text Object and use Count and/or Count(Distinct( to check the counts on things to confirm what is actually there...  I was not getting the numbers you mentioned with the above fields at all, and the app seems to only contain FY20 at the moment, so should be no need to make that selection in the version of the app you provided.  

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.