topic Re: Help regarding Cyclic Group in QlikView

Help regarding Cyclic Group

nikhilgarg — Fri, 15 Jan 2016 09:41:10 GMT

Hello,

I ahve cyclic group having dimensions as : Area Manager and Customer Name

. I want in my chart title, it should show Top 'N' Area Manager or Top 'N' Customer dynamically when i choose area manager or customer from cyclic group.

Plz help

Re: Help regarding Cyclic Group

tamilarasu — Fri, 15 Jan 2016 10:11:06 GMT

You want to show top N Manager Name / Customer Name.?

Try something like below,

Concat(Aggr(If(RANK(Sum(Sales))<N,"CylicGroupName"),"CylicGroupName"),',')

Re: Help regarding Cyclic Group

mightyqlikers — Fri, 15 Jan 2016 10:13:30 GMT

use dimension limits.

Regards

$@M.

Re: Help regarding Cyclic Group

mightyqlikers — Fri, 15 Jan 2016 10:21:33 GMT

use getselectedfield or getpossiblecount fuctions

Regarsd

$@M.

Re: Help regarding Cyclic Group

Anonymous — Fri, 15 Jan 2016 11:16:30 GMT

Say, Your Dim is: Cyclic Group

expression: Sum(Sales)

Then Goto -> Sort Tab -> Expression i.e Sum(Sales) -> Ascending or Descending( As required by you)

Note: Dont Forget to untick all other option for Cyclic Dim, Tick Only Expression only

After that:

Presentation -> Top Right(Tick Enable X axis Scroll bar) -> Item Exceeds Limit -> 5

This will give you top 5 only

Re: Help regarding Cyclic Group

Fri, 15 Jan 2016 12:13:43 GMT

I am assuming you are only talking about the title as differing between "Area Manager" and "Customer".

Fieldvalue('Name of cyclic group') will return this.
If your cyclic group is called C_GROUP and you are currently displaying the field [Customer] (in C_GROUP),

FieldValue('C_GROUP') will return "Customer".

So combine that in the title -> ='Top N (whatever number you like) ' & FieldValue('C_GROUP').

If this is regarding the 'N' as denoted, that depends on what rules you want to apply for showing the top N's. Dimension limit often does the trick.

Re: Help regarding Cyclic Group

Fri, 15 Jan 2016 13:24:31 GMT

'fieldvalue' is a two parameter function.

Tried implementing what you said but wasnt working..

Re: Help regarding Cyclic Group

jonathandienst — Fri, 15 Jan 2016 13:54:04 GMT

That should be =GetCurrentField('groupname')

(I have had problems in the past with this function with groups with spaces in the name)

Re: Help regarding Cyclic Group

Fri, 15 Jan 2016 16:08:40 GMT

Use the getcurrentfield function to modify the Chart Title.

='Top N ' & GetCurrentField('CyclicGroupName')

If you want to show only Top N , use dimension limits on your first expression.

Re: Help regarding Cyclic Group

nikhilgarg — Fri, 15 Jan 2016 16:44:47 GMT

Hey,

I also have space in fieldnames in CyclicGroup. How to resolve that?

Re: Help regarding Cyclic Group

nikhilgarg — Fri, 15 Jan 2016 16:45:35 GMT

Hey,

I have space in fieldnames in CyclicGroup. How to resolve that?

Help regarding Cyclic Group

Re: Help regarding Cyclic Group

nikhilgarg — Fri, 15 Jan 2016 16:46:13 GMT

Hey,

you get my question right. But your suggestion does not seems to work.

Re: Help regarding Cyclic Group

bohravanraj — Fri, 15 Jan 2016 17:06:31 GMT

Hi Nikhil,

you can use following Code in Text

=if(GetCurrentField(Group)='area manager','N Area Manager',

if(GetCurrentField(Group)='customer','N Customer'))

Regards,

Re: Help regarding Cyclic Group

Fri, 15 Jan 2016 18:24:17 GMT

Let us assume you have like below:

Group Name : Manager Group

Fields: AREA_MANEGER , CUSTOMER

=' Top N' & Pick(Match(GetCurrentField([Manager Group]),'AREA_MANEGER' ,'CUSTOMER'),'Area Manager' , 'Cusomer')

Can you please post your Cyclic Group Name & Field Names in the group so I will provide the correct answer.