I have 3 list boxes Say - "Department", "Designation", "Name".
1st Condition:
I have applied condition in "Designation" list box such that if particular Department is selected from "Department" list box, then designations appearing only in that Department's hierarchy shall be listed.
2nd Condition:
Similarly, after selecting particular designation, Names appropriate employees (of selected department and designation) should be displayed.
Problem:
1st condition works fine.
When I select particular designation, I get names of all the employees of All Departments having selected designation. This is going wrong. Doesn't QV gives priority to sequence of selection? How can it be achieved?
I tried by locking 1st selection - Department. But then QV doesn't allow me to select from "Designation" list box.
By default, Qlikview's associative logic always highlight the possible values with white background based on the current selections.
In your case, I assume that there is proper relationship between 'Department', 'Designation' and 'Name' and so, if you select 'Department' and 'Designation', then the 'Name' values which corresponds to these selections will be highlighted. This should work properly if there is proper relationship between the referred fields.
Have you given any expression? if so, can you list them here, we can then check if there is any issue with the expressions.
