Discussion Board for collaboration related to QlikView App Development.
i'm trying to create a button to select previous 12 month rolling from a field that has value not in data format.
The name of the field is ANNO_MESE, here is a screenshot of a list box (YYYYMM not in data format):
What i'd like to have is a button (or even something else) to activate selection on previous 12 months based on current month, so, for example:
today (october 2017) -> button activate selection on the field ANNO_MESE from 201610 to 201709
tomorrow (novembre 2017) -> button activate selection on the field ANNO_MESE from 201611 to 201710
Unfortunately, i can't edit the script or create new variables (it's a shared document).
Is there a way to do it?
Thanks in advance to everybody,
see if the below helps: ( I am using Version 12)
View solution in original post
Thirumala, it's simply perfect!!! Thank you very much, you've been incredibly fast and kind!
You are welcome and glad I am able to help...