Straight table help

[#1]

Hi,

I need have a straight table which consist of a Cyclic group ( consisting of a hierarchy such as Zone --> Managers --> Consultants) and another variable which would display score of Zone or Manager (under a Zone) and Consultants( Under a Manager) based on selection.

I have 3 list boxes which shows the Zone, Manager & Consultants.

The issue is, how do I represent the score in the Straight table using expressions?

I have 3 different variables for scores of Zone, Managers and Consultants. For example, if I click on Zone A in the list box for Zone and select Zone in the cyclic group among others (managers and consultants),  I would have variable 1 selected and corresponding Zone score displayed.

If I click on the cyclic group & choose Managers, then all the Managers under Zonewould be displayed and variable 2 should be selected

If I again click on the cyclic group symbol and choose Consultants then variable 3 should be selected and score displayed.

I would appreciate all your help and ideas to help me write an expression to do this.

Thanks to All in Advance,

Best regards,

Tutan

[#2]

Just to add to it... I can see the field abc as a cyclic group in the available field section in Qlikview. But once I pull it in the App, it's not there anymore in the list of the fields shown as I try to write an expression in the expression dialogue box.

[MayilVahanan]

Hi

     Please check the attached file..Hope it helps

[ektarathi · Accepted solution]

Hi,

Can you check using something like this :

If(GetCurrentField([Org]) = 'Zone', v1, if(GetCurrentField([Org])  = 'Manager', v2, v3))

I think what you are missing is square brackets around group name.

Hope this helps.

[#5]

Hi ektarathi,

Thanks a tonne. My bad, I was so late to realize that my group name was not continuous & it has space in between.

Thanks a lot for bringing the same to my notice.

We easily overlook small things which looks small but are of great importance.

Thanks & Regards,

Tutan