topic Re: How to set reference Line in a Cyclic Group? in QlikView

How to set reference Line in a Cyclic Group?

Tue, 15 Jul 2014 12:24:45 GMT

Hi All,

We have a Requirement as below,

in Bar chart we are using Cyclic group as dimension(which has year,Quarter, Month,Day Fields in cyclic group).

Now we have to set Reference Lines (Nothing But Targets) for each individual Fields.

for Eg. Year wise target should be 1000, Quarter it may 250, for month it is 84 like wise..

Kindly provide us a solution.

Thanks

Re: How to set reference Line in a Cyclic Group?

alexandros17 — Tue, 15 Jul 2014 12:28:36 GMT

When you use cyclic group there is the instruction "getcurrentfield(GroupName)" that gets the information of which dimension field are you using in the group.

So you can write:

if(getcurrentfield(GroupName)=year, 1000,

if(getcurrentfield(GroupName)=quarter, 250,

100

)

let me know

Re: How to set reference Line in a Cyclic Group?

Tue, 15 Jul 2014 12:41:43 GMT

Hi Alessandro ,

Thanks for your reply.

We have tried the same,but unfortunately its not working. we are getting error while giving the "Group Name" in Expression.Please suggest..

Thanks..

Re: How to set reference Line in a Cyclic Group?

alexandros17 — Tue, 15 Jul 2014 12:43:02 GMT

Try with '

so:

... getCurrentField('abc') ...

let me know

Re: How to set reference Line in a Cyclic Group?

Tue, 15 Jul 2014 12:57:07 GMT

Still its not working..

Thanks..

Re: How to set reference Line in a Cyclic Group?

martinpohl — Tue, 15 Jul 2014 12:58:48 GMT

Unfortunately the group name is interpreted as error but it works

Re: How to set reference Line in a Cyclic Group?

alexandros17 — Tue, 15 Jul 2014 13:02:45 GMT

I tried with an example of mine:

If(getcurrentfield(abc)='1S', 300, ...

the apex had to be added to the field name, sorry ...

Re: How to set reference Line in a Cyclic Group?

PradeepReddy — Tue, 15 Jul 2014 13:08:40 GMT

As Martin explained,

whenever you give the Group Name it gives error in expression, but you will get the currently selected field from Group.

GetCurrentField(Group_Name)

Re: How to set reference Line in a Cyclic Group?

Wed, 16 Jul 2014 04:16:00 GMT

Hi,

If possible please post me a sample, it is not working in my application.

Thanks..

Re: How to set reference Line in a Cyclic Group?

Wed, 16 Jul 2014 05:14:36 GMT

Hi,

I have attached a sample application for your Reference. Kindly do suggest me what changes i need to make to achieve my requirement.

Thanks..

Re: How to set reference Line in a Cyclic Group?

avinashelite — Wed, 16 Jul 2014 05:43:38 GMT

Hi Reena,

As per my knowledge, you cannot you reference line with the groups(cyclic or drill down) .It can be use only on non-grouped dimension. You cannot fetch the particular selection of the group.

If you want to achieve it try with his approach.

Add a inline table having values Year, Quarter etc.

Add four dimensions and hide them based on selection using conditional hiding.

Follow the same in the reference line too. This will give you the desired representation.

Hope this helps you.

Regards,

@vi

Re: How to set reference Line in a Cyclic Group?

jagan — Wed, 16 Jul 2014 06:15:10 GMT

Hi Reena,

I am not able to fixed that in existing chart, but when I tried to create the new one it is working, used the following as reference line expression.

=Pick(Match(GetCurrentField(cgNewGroup), 'Year', 'Quarter'), 1000000, 500000)

Replace cgNewGroup with your group name.

Regards,

Jagan.

Re: How to set reference Line in a Cyclic Group?

Wed, 16 Jul 2014 06:25:59 GMT

Thanks Jagan its works...