Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Crosstable from ODBC or OLE DB source

The crosstable option is not available when loading a table from SQL Server via ODBC or OLE DB.

Why is this ?

What would be a workaround ?

2 Replies

Crosstable is not part of the wizard, but the functionality works exactly the same way. The following prefix goes before your load statement:

CROSSTABLE ( AttributeName, DataName, <Number of Qualifying Fields> )

You might have to first load from the database and then reload "Resident" if the preceding load doesn't work for some reason...

Contributor III
Contributor III

That helped me a lot! Works like a charm!

Thank you!