Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can anyone help me with this same problem?
This is my calendar:
Calendar:
DECLARE FIELD DEFINITION TAGGED '$date'
Parameters
first_month_of_year = 1
Fields
Year($1) As Year Tagged '$year',
Month($1) as Month Tagged '$month',
Num(Month($1)) as MonthNum Tagged '$month',
Date($1) as Date Tagged ('$date', '$day'),
Week($1) as Week Tagged '$week',
Weekday($1) as Weekday Tagged '$weekday',
DayNumberOfYear($1, first_month_of_year) as DayNumberOfYear Tagged ('$numeric');
DERIVE FIELDS FROM FIELDS "Fecha Registro" USING Calendar;
I don't understand how and where to put the script to make my bar charts show data in the following order:
July, August , September, October , November, December , January, February , March, April , May, June
Thank you.
Regards.
I don't know if that works but I solved it by adding a simple table and using "NumeroMes" in sorting by expression.
Mes | NumeroMes |
Julio | 1 |
Agosto | 2 |
Septiembre | 3 |
Octubre | 4 |
Noviembre | 5 |
Diciembre | 6 |
Enero | 7 |
Febrero | 8 |
Marzo | 9 |
Abril | 10 |
Mayo | 11 |
Junio | 12 |
Thank you Sunny.
Regards.
Have you tried sorting your data using this expression?
=Match(MonthNum, 7, 8, 9, 10, 11, 12, 1, 2, 3, 4, 5, 6)
I don't know if that works but I solved it by adding a simple table and using "NumeroMes" in sorting by expression.
Mes | NumeroMes |
Julio | 1 |
Agosto | 2 |
Septiembre | 3 |
Octubre | 4 |
Noviembre | 5 |
Diciembre | 6 |
Enero | 7 |
Febrero | 8 |
Marzo | 9 |
Abril | 10 |
Mayo | 11 |
Junio | 12 |
Thank you Sunny.
Regards.
Sunny offered a clever trick, but it would have to be repeated in all charts involving months. If you'd like ALL of your charts to be presented by Fiscal Month, I'd change your calendar declaration using the setting first_month-of_year:
first_month_of_year = 7
This way, your calendar should get generated with the desired order of fiscal periods.
cheers,
Oleg Troyansky
Upgrade your Qlik skills at the Masters Summit for Qlik - coming soon to Milan, Italy!
Yup, I am glad you were able to figure it out
Hi Oleg.
I tried that but didn't work.
Thank you.
Regards.