topic Re: Filters not working in QlikView

Filters not working

savithri_n_s — Sat, 16 Nov 2024 01:24:54 GMT

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

Re: Filters not working

agigliotti — Mon, 27 Jan 2020 14:00:11 GMT

which PO_NUMBER_SP_PO values do you think are missing ?

Re: Filters not working

savithri_n_s — Mon, 27 Jan 2020 15:28:57 GMT

I feel something wrong the expression

None of the values are missing

Re: Filters not working

Brett_Bleess — Mon, 24 Feb 2020 17:58:00 GMT

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