topic Re: Listbox Selection Issue in QlikView

Listbox Selection Issue

Fri, 19 Feb 2016 21:25:51 GMT

After following allot of good advice, I have run into another issue. I think it has to do with my setup, so hopefully someone out there can take a look and steer me in the right direction. I have two listboxes (Alternate and Criteria) in my file and when I select Criteria, I don't receive the Criteria value I selected, but if I select a Alternative, I see values, but not only just the Alternative column with values beneath it and a criteria column next to it. I'm really trying to get the correct data, but it seems to be above my current skill level. What I'm trying to get is basically the following:

I would like to select a Criteria and receive the following display:

Criteria #	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
1.1	1	1	1.00	1.00	-0.50	-0.50	0.90	-0.50	1.00	0.90	0.90	1.00	1.00

Right now, this selection is not working correctly and returns null values.

I would also like to be able to reset the page and select an Alternative and receive the following display:

Criteria #	Alt 1
1.0	0.91
1.1	1.00
1.2	1.00
1.3	1.00
1.4	0.27
1.5	1.00
1.6	1.00
1.7	1.00
1.8	1.00
2.0	0.00
2.1	0.00
2.2	0.00
3.0	0.58
3.1	0.15
3.2	1.00
4.0	0.64
4.1	1.00
4.2	0.09
4.3	0.50
4.4	0.50
4.5	1.00
4.6	1.00
4.7	1.00
4.8	0.00
5.0	0.00
5.1	0.00
5.2	0.00
5.3	0.00
6.0	0.67
6.1	0.00
6.2	1.00
6.3	1.00
6.4	1.00
6.5	0.00
6.6	1.00
7.0	0.00
7.1	0.00
7.2	0.00
8.0	0.60
8.1	0.00
8.2	0.00
8.3	1.00
8.4	1.00
8.5	1.00
9.0	1.00
9.1	1.00
9.2	1.00
10.0	-0.50
10.1	-0.50

I've heard the above can be done, but I can't seem to get it.

And finally, if it can be done, I would like to select a Criteria AND Alternative from the listboxes and receive this:

Criteria #	Alt 1
1.0	0.91

Or just the ability to be able to slect the Criteria AND Alternative and receive the correct row at least as shown above.

Can someone please take a look at my .qvw and see what I'm doing wrong here?

Needy Newbie,

Preston

Re: Listbox Selection Issue

swuehl — Fri, 19 Feb 2016 22:15:57 GMT

Maybe like attached?

a) Changing the key in hierarchy table from text to numeric

b) Using a pivot table chart instead of table box

Re: Listbox Selection Issue

Sat, 20 Feb 2016 03:44:24 GMT

Could you try and get the same results with the attached file please? I have added text to the Top Criteria and Sublevel Criteria columns to be more representative of the tables I need to do this with.

Thanks in Advance,

Preston

Re: Listbox Selection Issue

swuehl — Sat, 20 Feb 2016 11:34:50 GMT

It's the same principle as before:

a) Changing the key in hierarchy table from text to numeric

b) Using a pivot table chart instead of table box to show alternatives as a dimension, not single field columns

I noticed the new fields in your excel file, but since I don't know the relations you want to build or your requirement, not sure what I should do here. You should be able to load these descriptions to the hierarchy or fact table.

Re: Listbox Selection Issue

Sat, 20 Feb 2016 13:00:47 GMT

swuehl,

What key in the hierarchy table are you referring to? I'm confused and really not following your logic because I have the Criteria # as numeric and it still does not function correctly. Could you post the source file you used to load from, with the changes you made, so that I can visualize what you're talking about?

Warm Regards,

Preston

Re: Listbox Selection Issue

swuehl — Sat, 20 Feb 2016 23:19:49 GMT

I haven't made changes to your sources, because I don't know what I should change there, i.e. what your requirements and context are. I've uploaded the changes to the QVW in my last post (if you are viewing from the inbox, you can't see attachments, follow the link to the thread to see all attachments then).

Re: Listbox Selection Issue

Sat, 20 Feb 2016 23:26:21 GMT

swuehl,

Thanks for the helpful suggestions. They helped allot, but after further review, I think I have found the issue and it requires adding a new field to take care of what I have been encountering. Have good one!

Warm Regards,

Preston