topic Re: Listbox not consistent with the tableview. in QlikView

Listbox not consistent with the tableview.

Mon, 20 Jul 2015 08:57:35 GMT

I have been testing to see if my dashboard is robust. Unfortunately, i came across this problem. I want you to specifically look at Question 18 where "somewhat/sometimes,slightly/rarely,not at all" are linked to "no" in Compliancy. Below is the tableview for your understanding. This is suppose to be the correct form.

But when i produce the raw list without any editing to its expression, it only highlights "not at all" as no when it is supposed to display "somewhat/sometimes,slightly/rarely,not at all"

What i have done?

I have tried looking into the source which is an excel file and it is written out correctly
reload the QVD creator and loading the QVD files into the dashboard and it works fine
Tableview confirms that QVD creator is working fine consuming the data.
I have tested with other parameters and they are all working fine except for this question.

FYI, ComplianceKey is a composite of type, question number and rating label and type is consistent for all questions.

What can you help me with?

a way to debug this( because i am honestly out of ideas)
a solution
tell me what i have not checked?

Re: Listbox not consistent with the tableview.

Gysbert_Wassenaar — Mon, 20 Jul 2015 09:09:36 GMT

Where does the Evaluation field come from? Does clearing the selection in that field change anything?

Can you post a qlikview document that demonstrates the problem?

Re: Listbox not consistent with the tableview.

Mon, 20 Jul 2015 09:14:56 GMT

You could say that evaluation is a superset of Question 18. So even if i clear it, it will still give me the same result in Rating Label.

These Category basically separates the Questions into parts. I apologize for not stating it clearly.

Re: Listbox not consistent with the tableview.

Wed, 22 Jul 2015 07:22:45 GMT

Turns out the issue was with the data source. The naming of field value was similar but not the same with the fact table. Hence it affected the relationship between the two list. It was human error after all.