Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
settu_periasamy
Master III
Master III

Display the Possible value field based on other Field

Hi All,

I have 4 fields, Hierarchy1, Hierarchy2 , Customer and Position. see the below screen shot.

qv_help_hierarchy.JPG

when i select the Hierarchy 1, i need the output  chart like the above screen shot(output should be chart).

The position field  is based on the Hierarchy1.

Attached the sample application file.

5 Replies
anbu1984
Master III
Master III

Can you explain your requirement? How did you get Hierarchy2,Customer, Position based on selected ALL_109 in Hierarchy1?

sushil353
Master II
Master II

Hi,

what is the logic of getting this output.. explain your business case.

settu_periasamy
Master III
Master III
Author

Actually, Hierarchy1 is contains all customer number list (with Hierarchy also). if the position is 500, i.e the top Hierarchy(Hierarchy1). Position 400 is second level Hierarchy. The field Customer is bottom level hierarchy. Position is 200 and 300.

But the Position is directly linked with Hierarchy1. If i select the ALL_109 , I need to display the Customer List with Position.

              

Hope this is fine.

sushil353
Master II
Master II

Hi,

In your output why are you getting position 500 ?

and do you have any sample app to share

settu_periasamy
Master III
Master III
Author

Hi Shushil,

Position is just for identification of the Hierarchy Level.

Already i shared the sample app.