topic Re: Display the Possible value field based on other Field in QlikView

Display the Possible value field based on other Field

settu_periasamy — Thu, 08 Jan 2015 05:55:00 GMT

Hi All,

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

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.

Re: Display the Possible value field based on other Field

anbu1984 — Thu, 08 Jan 2015 06:36:48 GMT

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

Re: Display the Possible value field based on other Field

sushil353 — Thu, 08 Jan 2015 06:52:12 GMT

Hi,

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

Re: Display the Possible value field based on other Field

settu_periasamy — Thu, 08 Jan 2015 07:40:27 GMT

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.

Re: Display the Possible value field based on other Field

sushil353 — Thu, 08 Jan 2015 07:49:37 GMT

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

settu_periasamy — Thu, 08 Jan 2015 08:15:13 GMT

Hi Shushil,

Position is just for identification of the Hierarchy Level.

Already i shared the sample app.