topic Re: Crosstable in QlikView

Crosstable

jim_chan — Fri, 22 Jul 2016 06:19:18 GMT

Hi guys.

I have created a table as such:

Table:

CrossTable(Month, Data, 14)

LOAD * FROM

$(vFile)

(qvd);

But, i still want to add in another 2 more new field/column .Startdate and EndDate.

How to add it to this Table?

Rgds,

Jim

Re: Crosstable

Fri, 22 Jul 2016 06:21:46 GMT

Hi Jim, Can you please share a sample?

Re: Crosstable

jim_chan — Fri, 22 Jul 2016 06:25:29 GMT

the above line my sample of code already. Can I do it this way?

Table:

CrossTable(Month, Data, 14)

LOAD * ,

num(Date#($(vStart),'YYYYMMDD')) as StartDate,

null()as EndDate

FROM

$(vFile)

(qvd);

Re: Crosstable

Fri, 22 Jul 2016 06:27:54 GMT

Please try this preceding load.

table:

load

num(Date#($(vStart),'YYYYMMDD')) as StartDate,

null()as EndDate, *;

CrossTable(Month, Data, 14)

LOAD * ,

num(Date#($(vStart),'YYYYMMDD')) as StartDate,

null()as EndDate

FROM

$(vFile)

(qvd);

Re: Crosstable

tresB — Fri, 22 Jul 2016 06:34:48 GMT

May be this:

Table:

CrossTable(Month, Data, 16)

LOAD

num(Date#($(vStart),'YYYYMMDD')) as StartDate,

null()as EndDate,

* // new fields have to come before '*' in the load

FROM

$(vFile)

(qvd);

Re: Crosstable

avinashelite — Fri, 22 Jul 2016 06:37:01 GMT

Do you want the new columns to be included Under Month and Data ??

if yes then load this way

Table:

CrossTable(Month, Data, 14)

LOAD * ,

num(Date#($(vStart),'YYYYMMDD')) as StartDate,

null()as EndDate

FROM

$(vFile)

(qvd);

//If you don't need to include then try like this

Table:

CrossTable(Month, Data, 16)

LOAD

num(Date#($(vStart),'YYYYMMDD')) as StartDate,

null()as EndDate,

FROM

$(vFile)

(qvd);

Re: Crosstable

jim_chan — Fri, 22 Jul 2016 06:42:15 GMT

thanks bro!

Re: Crosstable

jim_chan — Fri, 22 Jul 2016 06:42:53 GMT

Solved! thanks for telling me the options!