topic Listbox Problem in QlikView

Listbox Problem

Fri, 19 Feb 2016 00:46:06 GMT

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.

Re: Listbox Problem

hic — Fri, 19 Feb 2016 10:47:07 GMT

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

Re: Listbox Problem

sasikanth — Fri, 19 Feb 2016 10:47:50 GMT

Try this

Pls. fina the attachment

Re: Listbox Problem

Chanty4u — Fri, 19 Feb 2016 10:51:11 GMT

may be

Re: Listbox Problem

sunny_talwar — Fri, 19 Feb 2016 10:58:32 GMT

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]);

Re: Listbox Problem

Fri, 19 Feb 2016 13:01:11 GMT

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

Re: Listbox Problem

Fri, 19 Feb 2016 13:03:03 GMT

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

Re: Listbox Problem

Fri, 19 Feb 2016 13:04:15 GMT

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

Re: Listbox Problem

Fri, 19 Feb 2016 13:08:07 GMT

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

sunny_talwar — Fri, 19 Feb 2016 14:32:52 GMT

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);

Re: Listbox Problem

Fri, 19 Feb 2016 16:51:58 GMT

Thanks Sunny! I think that will do!

Very Thankful,

Preston