topic Re: Crosstable mapping issue in QlikView

Crosstable mapping issue

YJ_SG — Sat, 16 Nov 2024 00:36:52 GMT

Hi,

I am new on QlikView. I have a question when map week from sale cross table.

After loaded, it shows two groups of week. I guess one is number, the other is Text. How to join these two together?

Thanks.

Sales:
CrossTable(Week,Sales)
Load * Inline [
Person,201,202,203,204,205,206,207,208,209,210
Jason,100,100,100,100,100,100,100,100,100,900
Peter,200,200,200,200,200,200,200,200,200,600
Johny,300,300,300,300,300,300,300,300,300,500];

Wk2Month:
Load * Inline [
Week,Month
201,Jan
202,Jan
203,Jan
204,Jan
205,Feb
206,Feb
207,Feb
208,Feb
209,Mar
210,Mar];

Re: Crosstable mapping issue

Lisa_P — Mon, 25 May 2020 04:40:13 GMT

Try this:

SalesTemp:
CrossTable(Week,Sales)
Load * Inline [
Person,201,202,203,204,205,206,207,208,209,210
Jason,100,100,100,100,100,100,100,100,100,900
Peter,200,200,200,200,200,200,200,200,200,600
Johny,300,300,300,300,300,300,300,300,300,500];

Wk2Month:
Load * Inline [
Week,Month
201,Jan
202,Jan
203,Jan
204,Jan
205,Feb
206,Feb
207,Feb
208,Feb
209,Mar
210,Mar
];

Sales:
NoConcatenate
Load Person,
Num#([Week]) as Week,
Sales
Resident SalesTemp;

DROP Table SalesTemp;

Re: Crosstable mapping issue

YJ_SG — Mon, 25 May 2020 05:12:54 GMT

Thank you Lisa, it works.

I tried to use NUM# to change format but didn't put prefix NoConcatenate before load. Thank you.