topic Sql data load issue - pivoting in QlikView

Sql data load issue - pivoting

Wed, 17 Jun 2015 12:19:13 GMT

Hi,

I have connected Qlik sense with a database and want to load the following data. The Sql query is below. However I am having trouble loading the data due to error in the following codes. Can someone suggest why this doesn't work?

Thanks.

LOAD ID,

ComponentSales,

Sales,

Territory,

Volume,

ComponentName,

"Type"

SQL with relevantComponents as

(

select [ComponentName], [Value], [Type] from SALESREPORTING.dbo.Components

where ([ReportRunId] = 901) AND ([AggregationId] = 'MainOneMonth')

)

SELECT *

FROM relevantComponents

pivot (

max([Value])

for [Type] in ([ComponentSales], [Sales], [Territory], [Volume])

)

as datapivot;

Re: Sql data load issue - pivoting

Gysbert_Wassenaar — Wed, 17 Jun 2015 12:46:48 GMT

Try adding a semicolon after "Type". A preceding load needs to be terminated with a ; character.

Re: Sql data load issue - pivoting

Wed, 17 Jun 2015 12:51:29 GMT

Hi Gysbert, thank you for the suggestion. I've added a semicolon after type but it still does not load... Can you see anything else wrong with it?

Re: Sql data load issue - pivoting

Gysbert_Wassenaar — Wed, 17 Jun 2015 12:57:00 GMT

I don't see a field ID anywhere in the sql statement.

Re: Sql data load issue - pivoting

Wed, 17 Jun 2015 13:16:16 GMT

Hi Gysbert, sorry I don't understand... aren't ID, ComponentSales, etc field IDs?

Thanks.

Re: Sql data load issue - pivoting

Gysbert_Wassenaar — Wed, 17 Jun 2015 13:24:28 GMT

   LOAD ID,

        ComponentSales,

        Sales,

        Territory,

        Volume,

        ComponentName,

        "Type"

You tell Qlikview to load a field called ID. Where does that field come from? I don't see it in the sql statement.