FIlters not working

[savithri_n_s]

Hi Team,

If i select Fiscal year = FY20 and month = Sep  i should get PO count of 152 and requestor count should be 57.

Can you please help?

Regards,

Savithri

[Lisa_P]

This works if you select from your Month_SPO field rather than your Month_C field as per your list box

[savithri_n_s]

I want this based on month-c only as if change the list box other values in the sheet is effected.

Completion % should be 86% if I select fy19 Aug and in flight should be 10 % and overdue should be 4%

[Brett_Bleess]

Per Lisa's comment, it would seem you have a data model issue, the best I can point you to in that case would be the Design Blog area or maybe Rob W's Cookbook site to see if you can find some further ideas on things there to address what you need.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

You may want to have a look at the Master Calendar post as that may be on the right track, not sure though.

https://qlikviewcookbook.com/

Sorry I do not have anything better for you.  My post will kick things back up, so maybe someone else will have another look and have a more direct idea for you too.

Regards,
Brett