Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

ishanbhatt
Contributor II

How to load Crosstable with limited columns as data and others are as qualified?

Hi All,

I am trying to load data using cross table.

I've used qvd for data load and my data looks like

In Cross table Name and Product fields i select for the Qualifier and the other columns as Attribute fields.

Instead of this I want to use Name, Product, City and Country as Qualified field, Jan amount and Feb amount as attribute fields.

I want to load data

Please help me out,

Thanks in advance

Ishan Bhatt

5 Replies

Re: How to load Crosstable with limited columns as data and others are as qualified?

Maybe this:

Table:

CrossTable(Month, Data, 4)

LOAD Name,

          Product,

          City,

          Country,

          [Jan Amount],

          [Feb Amount]

FROM Source;

balrajahlawat
Esteemed Contributor

Re: How to load Crosstable with limited columns as data and others are as qualified?

Try what Sunny suggested you...

Another workaround is like say Jugad?

Insert all the attribute field as last column in excel as with above mentioned structure you would not be able to Qualify City & country.

balrajahlawat
Esteemed Contributor

Re: How to load Crosstable with limited columns as data and others are as qualified?

try this at script, slightly reorder the columns..

CrossTable(Month,Sales,4)

LOAD

NAME,

PRODUCT,

CITY,

COUNTRY

Jan,

Feb

 

FROM

(ooxml, embedded labels, table is Sheet1);

ishanbhatt
Contributor II

Re: How to load Crosstable with limited columns as data and others are as qualified?

Thanks you so much Sunny and Balraj to give response.

It Works. Thanks once again.

Ishan

ishanbhatt
Contributor II

Re: How to load Crosstable with limited columns as data and others are as qualified?

Thanks you so much Sunny & Balraj.

It's work.

Ishan