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:
|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|
Right now, this selection is not working correctly and returns null values.
|Criteria #||Alt 1|
I've heard the above can be done, but I can't seem to get it.
|Criteria #||Alt 1|
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?
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,
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.
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?
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).
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!