MACRO - Variable with Concatenate Values

[#1]

Hi Qlikers

I have a question, i have a field with this type of data: JAN 10, FEB 10, MAR 10, ...................... SEP 10.

What i want is to do a macro for a tab trigger that do the selection of the actual month and the actual year, example: when i change of tab it has to appear selected SEP 10 or depends on the month if we are on DEC it will be DEC 10 selected.

Can somebody help me with this issue plz?

Regards

Orlando

[disqr_rm]

See enclosed. If this works, just place the logic at SHEET trigger OnActivate instread of button trigger, as I have in the document.

You may need to play with the date or it's format a little bit.

Hope this helps you.

[#3]

Thanks for you fast response, it works the only thing it is the date format, can you help me with this, i have to put the year only with two numbers and i dont know how to do it. I need this format 'SEP 10'

Regards

Orlando Martinez

[disqr_rm]

Use the date formatting options with date() function, like: date(today(), 'MMM YY')

This will give you "Sep 10" value for today but internally it will keep the date contents (as numbers), so it will all link properly.

[#5]

Thanks Rakesh, it works very well

Regards

Orlando