topic Re: Concatenate Year+Month in QlikView

Concatenate Year+Month

Wed, 05 Dec 2012 13:44:10 GMT

Hi,

i´d like to create a new dimension,where i can connect two existed dimensions (year/month) and character "/" = for example 2012/5

Could i do it in calculate dimension by some formula,or should i solve it in script by distinct

Thx a lot

Re: Concatenate Year+Month

Wed, 05 Dec 2012 13:48:26 GMT

try

DATE (MakeDate(YEAR('YEAR'),MONTH('MONTH')),'YYYY/MM') as DATE_NEW

Re: Concatenate Year+Month

MayilVahanan — Wed, 05 Dec 2012 13:49:24 GMT

Try like this

=Year &'/'&Month as dimension

Load Year&'/'&Month as YearMonth from tablename;

Hope it helps

Re: Concatenate Year+Month

Gysbert_Wassenaar — Wed, 05 Dec 2012 13:54:15 GMT

try: year&'/'&month as yearmonth. This will result in a string, so don't try to use date calculations on it. If you need that use something like Rebeca posted. Perhaps date(makedate(year,month),'YYYY/M') will do. Note, qlikview is Case Sensitive, so 'year' is not the same as 'Year'. Take this into account when creating and using field names.

Re: Concatenate Year+Month

CELAMBARASAN — Wed, 05 Dec 2012 13:56:33 GMT

You can use Calculated dimension as

=YearField&'/'&MonthNumberField

Or in Script

Date(Floor(DateField),'YYYY/M')

Using this in script in better.

Re: Concatenate Year+Month

Wed, 05 Dec 2012 14:17:14 GMT

Thanks,it works....can you tell me,how i get a legend into a chart,i still have it next chart on the right and i cannot find this way in the options/presentations

Thanks a lot

Re: Concatenate Year+Month

Gysbert_Wassenaar — Wed, 05 Dec 2012 14:42:51 GMT

There are some settings for the legend on the Presentation tab. Click on Settings in the Legend box. There's also a way to move the legend around a bit. Select your chart and press Ctrl+Shift. You should then see boxes with red outlines. You can move and resize the boxes while you keep the Ctrl+Shift keys down.

Re: Concatenate Year+Month

Wed, 05 Dec 2012 15:25:40 GMT

Yes,thanks for a very good advice