Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
nnellore
New Contributor II

Loading data from crosstable

Hi,

I need to load data from an excel and the data is in cross table.

Please find the details in the attached excel sheet.

There are two tabs in excel sheet.

I have given sample data in source tab.

In QlikView need to create List boxes based on heading mentioned in source tab.

Details have shown in Requirement tab.

Please help on this example.

2 Replies

Re: Loading data from crosstable

Table:

CrossTable(User,Value,2)

LOAD *

FROM

test.xlsx

(ooxml, embedded labels, table is Source, filters(

Transpose()

));

rename field F1 to Year;

rename field user to Month;

See attached qvw


talk is cheap, supply exceeds demand
nnellore
New Contributor II

Re: Re: Loading data from crosstable

Hi,

Many thanks.

It worked well with transposing data.

However if we have two fields in first two columns. Please find an example in attached file.

And please help on this example too..

Community Browser