topic Re: Expression Help in QlikView

Expression Help

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi guys

A bit of help needed if I may call on your assistance please?

I am trying to work out a score for the previous FY.

The below works for the current financial year (as an additional request, how do I get this to always to the current year using "Year(Today())")?

( Count({<[FTMR_P2P_KPI]={"Success"},[Purchase Order Document Type - Code]-={''}>} DISTINCT [Invoice Number]))

/

( Count({<[FTMR_P2P_KPI]={"Success","Failure"},[Purchase Order Document Type - Code]-={''}>} DISTINCT [Invoice Number]))

For the previous financial year, I guess I would need the above (once it's mastered to always be at the current year depending on today's date no matter what Year I select on my app) amending to include "Year(Today())-1"?

Many thanks for your help in advance!

Gareth

Re: Expression Help

Gysbert_Wassenaar — Wed, 15 Nov 2017 16:58:00 GMT

Perhaps something like this:

( Count({<MyYearField={$(=Year(Today()))}, [FTMR_P2P_KPI]={"Success"},[Purchase Order Document Type - Code]-={''}>} DISTINCT [Invoice Number]))

( Count({<MyYearField={$(=Year(Today()))}, [FTMR_P2P_KPI]={"Success","Failure"},[Purchase Order Document Type - Code]-={''}>} DISTINCT [Invoice Number]))

Previous year:

( Count({<MyYearField={$(=Year(Today())-1)}, [FTMR_P2P_KPI]={"Success"},[Purchase Order Document Type - Code]-={''}>} DISTINCT [Invoice Number]))

( Count({<MyYearField={$(=Year(Today())-1)}, [FTMR_P2P_KPI]={"Success","Failure"},[Purchase Order Document Type - Code]-={''}>} DISTINCT [Invoice Number]))

Re: Expression Help

Anonymous — Thu, 16 Nov 2017 09:22:25 GMT

Thank you very much Gysbert, that worked like an absolute dream.

Thanks again.

Gareth