topic Script issue in QlikView

Script issue

Wed, 25 Aug 2010 12:36:09 GMT

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.

Script issue

Miguel_Angel_Baeyens — Wed, 25 Aug 2010 12:51:00 GMT

Hello,

Try something like

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

Is that what you are looking for?

Script issue

Wed, 25 Aug 2010 12:53:21 GMT

Hi Miguel.

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

Script issue

Miguel_Angel_Baeyens — Wed, 25 Aug 2010 13:03:54 GMT

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.

Script issue

Wed, 25 Aug 2010 13:05:03 GMT

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