I have to present this dashboard on Monday and need help in trying to fix this issue I'm having.
The table diagram is attached.
"Preparer Grade" in table "Active File Query" and "Grade Value (P)" in the table "Preparer Grades" are the same thing.
Difference is that I have manually done a vlookup in Excel and added the values in Active Files Query sheet. This is the data I want to show in charts without having to do a vlookup.
The vlookup is between the Preparer Notes Address and FSLI. Qlikview isn't counting all the values as you can see in the attached image but the manual vlookup column "Preparer Grade" is. Please help.
