topic Re: Date string concatenation in QlikView

Date string concatenation

Tue, 26 Apr 2016 14:12:26 GMT

Hi,

I have several Dates in my model (5 calendars).

Date_1, Date_2, Date_3...

I have a field that's indicate what type of date we work by,

the field called DatePick and he's containing 1 to 5.

I want to concatenate him in my dimensions.

So the dimension will look like this: Date_&DatePick or Month_&DatePick.

What is the proper way to achieve that?

Thanks for help, sorry for bad english.

Re: Date string concatenation

marcus_sommer — Wed, 27 Apr 2016 08:32:56 GMT

Have you checked if it's possible to merge some or all calendars into a canonical-calendar: Canonical Date? Your usage of DatePick and a possible concatenating it with date-fields into a dimension isn't quite clear for me what is the aim for it?

- Marcus

Re: Date string concatenation

Wed, 27 Apr 2016 08:44:09 GMT

I managed to solved it!

I've created a variable and set it to: ='Month_'&DatePick

and in the expression i put: =$(vMonth)

worked.

Thanks Marcus for your will to help.

Have a nice day.

Re: Date string concatenation

Digvijay_Singh — Wed, 27 Apr 2016 08:47:45 GMT

You may need to use calculated dimension as Date & '_' & DatePick and Month & '_' & DatePick