Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Listbox Problem

I have included the following file and would like to create two list boxes with the Alt  and Top Criteria column names listed and in the list box. Something like so:

Alternates               Top Level Criteria

Alt1                                   1

Alt2                                   2

Alt3                                   3

Alt4                                   4

Alt5                                   5

Alt6                                   6

Alt7                                   7

Alt8                                   8

Alt9                                   9

Alt10                                10

Alt11

If possible, I was wondering if there was an ability to select either the Alternate or Top Level Criteria and get a display of the respective data.

1 Solution

Accepted Solutions
sunny_talwar

Try this:

Table:

CrossTable(Alternative, Data, 2)

LOAD [Top Level Criteria],

    [Sublevel Criteria],

    [Alt 1],

    [Alt 2],

    [Alt 3],

    [Alt 4],

    [Alt 5],

    [Alt 6],

    [Alt 7],

    [Alt 8],

    [Alt 9],

    [Alt 10],

    [Alt 11]

FROM

chicklet_example_scratch.xlsx

(ooxml, embedded labels, table is Combined);

View solution in original post

10 Replies
hic
Former Employee
Former Employee

You should load this data using a Crosstable load, e.g.

CrossTable(Alternates, Data, 2)

LOAD [Top Level Criteria],

     [Sublevel Criteria],

     [Alt 1],

     [Alt 2],

     [Alt 3],

     [Alt 4],

     [Alt 5],

     [Alt 6],

     [Alt 7],

     [Alt 8],

     [Alt 9],

     [Alt 10],

     [Alt 11]

FROM [chicklet_example_scratch.xlsx]

(ooxml, embedded labels, table is [Numeric Translation]);

See more on The Crosstable Load

HIC

sasikanth
Master
Master

Try this

Pls. fina the attachment

Chanty4u
MVP
MVP

may be

sunny_talwar

Use a CrossTable Load here:

Table:

CrossTable(Alternative, Data, 2)

LOAD [Top Level Criteria],

    [Sublevel Criteria],

    [Alt 1],

    [Alt 2],

    [Alt 3],

    [Alt 4],

    [Alt 5],

    [Alt 6],

    [Alt 7],

    [Alt 8],

    [Alt 9],

    [Alt 10],

    [Alt 11]

FROM

chicklet_example_scratch.xlsx

(ooxml, embedded labels, table is [Numeric Translation]);


Capture.PNG

Not applicable
Author

Henric,

I'm sorry, but I would like to know the above based on only the Combined data sheet in the attached file.

Thanks Again,

Preston

Not applicable
Author

Sasi k,

Thanks on the quick reply, but I would like to know the above based on only the Combined data sheet in the attached file.

Thanks Again,

Preston

Not applicable
Author

Chanty 4u,

I'm sorry, but I wasn't specific enough in the initial post. I would like to know the above based on only the Combined data sheet in the attached file.

Thanks Again,

Preston

Not applicable
Author

Sunny T,

Thanks again for a speedy reply! I remember you helping me on the CrossTable load before, but my management wants to use the Combined data sheet in the attached file to get the initial layout I posted above. Do you have any idea how I could get it done?

Thanks Again,

Preston

sunny_talwar

Try this:

Table:

CrossTable(Alternative, Data, 2)

LOAD [Top Level Criteria],

    [Sublevel Criteria],

    [Alt 1],

    [Alt 2],

    [Alt 3],

    [Alt 4],

    [Alt 5],

    [Alt 6],

    [Alt 7],

    [Alt 8],

    [Alt 9],

    [Alt 10],

    [Alt 11]

FROM

chicklet_example_scratch.xlsx

(ooxml, embedded labels, table is Combined);