topic Re: Creating lines per (Year&Month) in load in QlikView

Creating lines per (Year&Month) in load

hschultz — Fri, 30 Nov 2012 12:03:40 GMT

Hi all

I hope that someone is able to assist me.

I have a table with some detail including Start & End dates.

Basically what i want to do is create a colum that i can use as a link to another table. This colum needs to have the Dimension&Year&Month for the link. Here is an example of what i'm talking about.

This is the data

Customer	Start Date	End Date	"Other Detail"
AAA	2012/01/01	2012/03/31	*Colums of data
BBB	2012/02/01	2012/04/30	*Colums of data

This is what the result is supposed to be:

Customer	Start Date	End Date	"Other Detail"	LINK Created
AAA	2012/01/01	2012/03/31	*Colums of data	AAA\|2012\|JAN
AAA	2012/01/01	2012/03/31	*Colums of data	AAA\|2012\|FEB
AAA	2012/01/01	2012/03/31	*Colums of data	AAA\|2012\|MAR
BBB	2012/02/01	2012/04/30	*Colums of data	BBB\|2012\|FEB
BBB	2012/02/01	2012/04/30	*Colums of data	BBB\|2012\|MAR
BBB	2012/02/01	2012/04/30	*Colums of data	BBB\|2012\|APR

So basically the data will be duplicated for as many months as the date makes it be active.

Thank you for the assistance

Re: Creating lines per (Year&Month) in load

Fri, 30 Nov 2012 12:46:48 GMT

Hi,

If you want to show 'LINK created' column in the chart then you can simply add an expression:

Customer & '|' & Year(Date field) & '|' & Month(Date field)

If you want to create a key to join these tables in data model then you have to define same expression in the script.

Hope this helps.

Regards,

Neha Rangari

Re: Creating lines per (Year&Month) in load

hschultz — Fri, 30 Nov 2012 12:48:37 GMT

It is not for a chart unfortunately. I need this in order to link to another table in my LOAD script

Re: Creating lines per (Year&Month) in load

Fri, 30 Nov 2012 12:51:07 GMT

Could you please share tablenames & fieldnames from the script?

Re: Creating lines per (Year&Month) in load

hschultz — Fri, 30 Nov 2012 13:03:37 GMT

Sorry, but I don't understand what you need.

It's basically as i have stated there in the first post. Only with a few more colums.

Re: Creating lines per (Year&Month) in load

hschultz — Wed, 12 Dec 2012 07:34:31 GMT

Here is the answer to my requirement