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

[shree909]

can u provide an example????????????

[#3]

Basically what I would have is a straight table with 2 columns.

Column 1 would consist of a cyclic group dimension named as Org. Org would consist of Zone, Manager & Consultants.

Column 2 would consist of scores of Zone/Manager/Consultants. These scores are stored in variable1, variable 2 & variable 3.

If I select Zone from the cyclic group (column 1), column 2 should evaluate Variable 1.

If I select Manager from the cyclic group (column 1), column 2 should evaluate Variable 2.

If I select Consultants from the cyclic group (column 1), column 2 should evaluate Variable 3.

So, basically based on first column selection, second column should evaluate.

Can I use the statement,

(If (Org='Zone' , Variable 1,

if (Org='Manager',variable 2,

if(Org='Consultant',variable 3))),null())

Thanks In Advance for help,

Tutan

[somenathroy]

You may try this:

if(GetCurrentField(Org) = 'Zone', Variable1, if(GetCurrentField(Org) = 'Manager', Variable2, Variable3))

Regards,

Som

[Anonymous]

U can also use set analysis for d same.

regards,

vaibhav

[#6]

You can use the GetCurrentField() to identify which dimension is currently visible (e.g. it will return either Zone, Manager or Consultant).

Then using the If conditional, you can then apply different variables to perform your calculation.

[qliksus]

My question wil u always select one value in the zone column or more than that if u select more than one value

i would say u can create a expression in the straight table based on the dimension selected in the Cyclic group

instead of creating a calcuated dimension u can create a Expression and show iut like a dimension

as it is a straight table .If u cant understand wati said attach a sample file so that i can give u a solution

[#8]

Hi Guys,

This is not working. All I need is this:

I have the first column in a straight table as cyclic group ( built only using fields) named as Org. The cyclic group is consisting of the hierarchy as Zone --> Manager -->Consultant

All the other 14 columns in the straight table have numerical data.

What I need is, If I select Zone from the Cyclic group , it should evaluate variable 1 for the 1st column, variable 2 for the 2nd column & so on. If I select Manager from the cyclic group then it should evaluate variable 17 for first colulmn etc...

I tried using the function GetCurrentField(Org)='Zone' etc , but Qlikview can't find Org as a group whereas I see that defined as group and that is what the first column of my straight table is built of !!!

When I built the cyclic group Org was shown as a field. But as soon as I pulled it in my App, it doesn't show there any more

Am I missing something??

Please help.

Regards,

Tutan

[MayilVahanan]

Hi

     Can you check in App, you're using Org group..If so, use like below in first column

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

     Hope it helps

[#10]

Hi Mayii,

I tried doing what you suggested, but, Qlikview just don't to seem to recognise the group name "Org". I tried creating a new group with the same fields with the name "abc". Qlikview still doesn't consider it as a field.

Am I missing anything?

Best Regards.

Tutan