Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted

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
Honored Contributor III

Re: Display the Possible value field based on other Field

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

sushil353
Honored Contributor II

Re: Display the Possible value field based on other Field

Hi,

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

Re: Display the Possible value field based on other Field

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
Honored Contributor II

Re: Display the Possible value field based on other Field

Hi,

In your output why are you getting position 500 ?

and do you have any sample app to share

Re: Display the Possible value field based on other Field

Hi Shushil,

Position is just for identification of the Hierarchy Level.

Already i shared the sample app.