topic Re: formula in expression using fiscal month in QlikView

formula in expression using fiscal month

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

Hi,

before calculating the fiscal month, I the following formula to get the month :-

=Count({<%DateEmpFormAdded = {"$(='>=' & Date(AddMonths(Max(%DateEmpFormAdded), - 1)) & '<=' & Date(AddMonths(Max(%DateEmpFormAdded), 0)))"}>}EngagementType)

Now that I have a fiscal month in my table against each transaction , can I use "Fiscal.Month" instead?

Fiscal calendar shows correctly the table:-

I've tried below and similar with no luck:-

Count({<Fiscal.Month}>}EngagementType)

Cheers

Re: formula in expression using fiscal month

Gysbert_Wassenaar — Thu, 14 Jul 2016 08:34:23 GMT

Count({<Fiscal.Month}>}EngagementType)

This merely makes the expression disregard selections in the Fiscal.Month field. Can you post a small qlikview document that demonstrates what you're trying to do?

Re: formula in expression using fiscal month

Anonymous — Thu, 14 Jul 2016 08:50:07 GMT

Hi GD. sample attached.

Re: formula in expression using fiscal month

Gysbert_Wassenaar — Thu, 14 Jul 2016 09:12:27 GMT

Your document does not contain a field names Fiscal.Month. You can't use non-existing fields in Qlikview documents.

Re: formula in expression using fiscal month

Anonymous — Thu, 14 Jul 2016 09:19:40 GMT

apologies , I loaded the sample I was playing around with:-

Count({<DateEmpMonth}>}EngagementType)

Re: formula in expression using fiscal month

Gysbert_Wassenaar — Thu, 14 Jul 2016 09:42:19 GMT

I'm afraid you've lost me. What are you trying to calculate?