Announcements
The way to achieve your own success is the willingness to help somebody else. Go for it!
cancel
Showing results for
Did you mean:
Creator

## Use multiple values in Month Variable (Rolling Months)

Hello everyone.

I have created 12 variable to express the range of month

vMoisCumul1 = '01'

vMoisCumul2 = '01','02'

....

vMoisCumul12 = '01,'02'....'11','12'

I have created another compilated variable which iscalled vMoisCumulTotal

If(Mois = 01,'\$(=vMoisCumul1)',
If(Mois = 02,'\$(=vMoisCumul2)',
If(Mois = 03,'\$(=vMoisCumul3)',
If(Mois = 04,'\$(=vMoisCumul4)',
If(Mois = 05,'\$(=vMoisCumul5)',
If(Mois = 06,'\$(=vMoisCumul6)',
If(Mois = 07,'\$(=vMoisCumul7)',
If(Mois = 08,'\$(=vMoisCumul8)',
If(Mois = 09,'\$(=vMoisCumul9)',
If(Mois = 10,'\$(=vMoisCumul10)',
If(Mois = 11,'\$(=vMoisCumul11)',
If(Mois = 12,'\$(=vMoisCumul12)',0
))))))))))))

What i want is use the variable vMoisCumulTotal in a set analysis

When i use a simple set analysis like this one (My qlik sense application has the Month Filter = 02 and Year = 2020 selected):

SUM({<Year = {'\$(=vCurrentYear)'} ,Mois = {\$(=vMoisCumulTotal)}>}TAUX_DEPART_CDI)

But i have the error : "Error in set modifier ad hoc element list: ',' or ')' expected"

Anyone could help ?

Thanks

Labels (2)

• ### Variable value

2 Replies
Creator
Author

Anyone ?

Creator
Author

UP

Tags
Community Browser