topic Re: Straight table help in QlikView

Straight table help

Mon, 30 Jul 2012 02:33:09 GMT

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

Re: Straight table help

shree909 — Mon, 30 Jul 2012 03:36:09 GMT

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

Re: Straight table help

Mon, 30 Jul 2012 04:29:02 GMT

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

Re: Straight table help

somenathroy — Mon, 30 Jul 2012 06:13:59 GMT

You may try this:

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

Regards,

Som

Re: Straight table help

Anonymous — Mon, 30 Jul 2012 06:15:50 GMT

U can also use set analysis for d same.

regards,

vaibhav

Re: Straight table help

Mon, 30 Jul 2012 06:43:00 GMT

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.

Re: Straight table help

qliksus — Mon, 30 Jul 2012 07:34:58 GMT

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

Re: Straight table help

Wed, 01 Aug 2012 20:23:10 GMT

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

Re: Straight table help

MayilVahanan — Wed, 01 Aug 2012 20:29:34 GMT

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

Re: Straight table help

Wed, 01 Aug 2012 20:41:17 GMT

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

Re: Straight table help

Wed, 01 Aug 2012 20:43:23 GMT

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.

Re: Straight table help

MayilVahanan — Wed, 01 Aug 2012 20:45:06 GMT

Please check the attached file..Hope it helps

Re: Straight table help

ektarathi — Thu, 02 Aug 2012 00:42:05 GMT

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.

Re: Straight table help

Fri, 03 Aug 2012 16:08:05 GMT

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