topic 12 month rolling selection from a field not in data format in QlikView

12 month rolling selection from a field not in data format

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

Hi guys,

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,

Andrea

trdandamudi — Tue, 31 Oct 2017 15:37:37 GMT

see if the below helps: ( I am using Version 12)

qv_bazz_10 — Tue, 31 Oct 2017 15:43:46 GMT

Thirumala, it's simply perfect!!! Thank you very much, you've been incredibly fast and kind!

Andrea

trdandamudi — Tue, 31 Oct 2017 15:47:44 GMT

You are welcome and glad I am able to help...