Script issue

[#1]

Hey guys.

I apologies in advanced if i am not explaining this properly.

I have created a document in qlkview and everythng works. Im trying to load data from an excel sheet that contains a list of ID's of employers who have made sales on certain dates. e.g

Now i have uploaded it into my script like this:

LOAD QuotaDate,

[275.000000] as [275],

[276.000000] as [276],

[277.000000] as [277],

[279.000000] as [279],

[280.000000] as [280],

[282.000000] as [282],

[284.000000] as [284],

[286.000000] as [286],

[288.000000] as [288],

[289.000000] as [289],

[290.000000] as [290],

Website as WebsiteSales

But now how do i make them create a jon to a seperate table VIA ID. From 275 until 290 is all ID's and on each ID there are seperate sales for different times.

Hope I am making myself clear but s there a way to join them all to create one field called ID?

Any help is appreciated.

[Miguel_Angel_Baeyens · Accepted solution]

Hello,

Try something like

CROSSTABLE (ID, Sales) LOAD * FROM ExcelFile.xls (whatever)

Is that what you are looking for?

[#3]

Hi Miguel.

Thanks for the respnse. Im going to try that now. can you maybe explain to me what Cross Table does?

[Miguel_Angel_Baeyens]

Hi,

A cross table seems to be exactly what you want to get, meaning you have a matrix of values, where the first row is actually one field with multiple dimensions. In your case, I'd say your table has two fields, one is QuotaDate and the other is ID. Any combination of rows and columns are the field (Sales), but the information is displayed as a pivot table.

You can find further information in the Reference Manual p. 309 and pp. 506.

[#5]

Thanks so much buddy. It worked like a bomb and thanks for the explanation.