Most likely, your issue is related to formatting of the Month field. Based on your formula, the variable vActualIndicator is a 2-digit numeric field. Your field [Fiscal Month] is likely formatted as a Month, i.e. a dual value. Set Analysis can't make selections if the values are not properly formatted. You can, however, formulate an advanced search condition to overcome the issue. Something like this:
Another issue to verify is the variable itself and how it's being expanded in the $-sign expansion. Place this expression in a Straigh Table and leave the Label empty. In the expression label, you will be able to see a fully rendered Set Analysis expression. What kind of a value do you see there?
best,
Oleg Troyansky
www.masterssummit.com - take your QlikView skills to the next level!
This is what my expression would look like if the variable were displayed
Sum({<[Fiscal Month]={"<=$(4)"}>}Balance)
what this will do is sum everything from period 1 to period 4 , what I need to do is sum only the month which I have selected, if I select multiple months then sum them all but only sum up until month 4, month 5 and 6 will have data but those months are not closed off as yet so I dont want to see them as actuals.
Im finding it a bit difficult to create a sample file that will highlight my issue effectively Im using a UDR to generate a report so it will be a bit tricky to get the actual values
so, based on your explanation, you need to select an intersection between the user selections in the field Fiscal Month and the condition listed in your set analysis. In this case, use the operator *= instead of a simple =, like this:
.png "Former Employee"){kind=icon}
