topic Re: FIlters not working in QlikView

FIlters not working

savithri_n_s — Sat, 16 Nov 2024 01:25:12 GMT

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

Re: FIlters not working

Lisa_P — Tue, 28 Jan 2020 03:05:45 GMT

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

Re: FIlters not working

savithri_n_s — Tue, 28 Jan 2020 04:17:14 GMT

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%

Re: FIlters not working

Brett_Bleess — Thu, 20 Feb 2020 21:43:38 GMT

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