Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 2 list box as follows
List Box 1 List box 2
Dept Branch
A 1
B 2
C 3
4
5
6
7
8
9
Branch 1,2,3 come under Dept A
Branch 4,5,6 come under Dept B
Branch 7,8,9 come under Dept C
My requirement is to show Branch 1,2 and 3 in Branch List box if I select Dept A and so on
Pls help to write the expression for thisw
the easiest method would be to check the "hide excluded" option:
hope this helps
regards
Marco
Hi,
that's out-of-the-box QV functionality, i.e. no expression required.
hope this helps
regards
Marco
I do not understand
Hi,
Do these fields have any logical connection?
I mean do they reside in the same table?
if yes, then this is how qlikview works.
If not then do let me know.
Regards
ASHFAQ
added example above
regards
Marco
Thanks Marco
I get your point. but as per your example in the branch list box still the branch 4-9 are visible though not highlighted. What I want to see only 1 2 3 branches in the branch list box
Hi,
Create New List Box
Write Expression
Use AGGR(Branch,Dept)
There is change It should as below
Use AGGR(Branch,Branch)
When You select A from Dept Then it will give only 1,2,3
Regards
Will you please explain a little more
Hi,
For fields available in different table.
Regards
ASHFAQ
the easiest method would be to check the "hide excluded" option:
hope this helps
regards
Marco