Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
qv_bazz_10
Creator
Creator

12 month rolling selection from a field not in data format

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

1 Solution

Accepted Solutions
trdandamudi
Master II
Master II

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

View solution in original post

3 Replies
trdandamudi
Master II
Master II

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

View solution in original post

qv_bazz_10
Creator
Creator
Author

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

Andrea

trdandamudi
Master II
Master II

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