Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
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

Re: Listbox Problem

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

Re: Listbox Problem

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
Valued Contributor III

Re: Listbox Problem

Try this

Pls. fina the attachment

Chanty4u
Esteemed Contributor III

Re: Listbox Problem

may be

Re: Listbox Problem

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

Re: Listbox Problem

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

Re: Listbox Problem

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

Re: Listbox Problem

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

Re: Listbox Problem

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

Re: Listbox Problem

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