topic MACRO - Variable with Concatenate Values in QlikView

MACRO - Variable with Concatenate Values

Tue, 14 Sep 2010 22:39:01 GMT

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

MACRO - Variable with Concatenate Values

disqr_rm — Wed, 15 Sep 2010 00:00:35 GMT

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.

MACRO - Variable with Concatenate Values

Wed, 15 Sep 2010 13:48:24 GMT

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

MACRO - Variable with Concatenate Values

disqr_rm — Wed, 15 Sep 2010 14:59:01 GMT

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.

MACRO - Variable with Concatenate Values

Wed, 15 Sep 2010 15:24:56 GMT

Thanks Rakesh, it works very well

Regards

Orlando