Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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];
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;
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;
Thank you Lisa, it works.
I tried to use NUM# to change format but didn't put prefix NoConcatenate before load. Thank you.