Discussion Board for collaboration related to QlikView App Development.
It might be more flexible to preserve the numeric format as well.
Sorting could be done in numeric order, you could subtract months, and so on.
Thank you - your solution was perfect!
this is what im looking for, a quick fix in case the value of month is in NUMERIC value that is not from a date function. This is common if the source data is in csv or xls file.
An easy way to get a proper QV month dual from a month number is:
It doesn't matter what year you use in the Makedate() function.
Begineers can use if codition.
Hear is the code:
When Month is loaded as number only.
if(Month=12,'Dec')))))))))))) as Month,
Most of the scripts were for tables.
yours worked perfectly for this instance...of front end variables
For vCursorMonth = (vMonthFrom) to (vMonthTo)
Let vcmm = PICK($(vCursorMonth),'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec');
This works great when you need Month as both numbers and letters, so you can work with both dimensions (ie. [Month] and [MonthNumber]).
Thanks a lot.