formula in expression using fiscal month

[Anonymous]

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

[Gysbert_Wassenaar]

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?

[Anonymous]

Hi GD.  sample attached.

[Gysbert_Wassenaar]

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

[Anonymous]

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

Count({<DateEmpMonth}>}EngagementType)

[Gysbert_Wassenaar]

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