Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

Listbox Selection Issue

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 CriteriaSublevel CriteriaAlt 1Alt 2Alt 3Alt 4Alt 5Alt 6Alt 7Alt 8Alt 9Alt 10Alt 11
1.1111.001.00-0.50-0.500.90-0.501.000.900.901.001.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.00.91
1.11.00
1.21.00
1.31.00
1.40.27
1.51.00
1.61.00
1.71.00
1.81.00
2.00.00
2.10.00
2.20.00
3.00.58
3.10.15
3.21.00
4.00.64
4.11.00
4.20.09
4.30.50
4.40.50
4.51.00
4.61.00
4.71.00
4.80.00
5.00.00
5.10.00
5.20.00
5.30.00
6.00.67
6.10.00
6.21.00
6.31.00
6.41.00
6.50.00
6.61.00
7.00.00
7.10.00
7.20.00
8.00.60
8.10.00
8.20.00
8.31.00
8.41.00
8.51.00
9.01.00
9.11.00
9.21.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.00.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

6 Replies
MVP
MVP

Re: Listbox Selection Issue

Maybe like attached?

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

b) Using a pivot table chart instead of table box

Not applicable

Re: Listbox Selection Issue

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

MVP
MVP

Re: Listbox Selection Issue

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.

Not applicable

Re: Listbox Selection Issue

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

MVP
MVP

Re: Listbox Selection Issue

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

Not applicable

Re: Listbox Selection Issue

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