Need help

[Mahamed_Qlik]

Hi All,

I need dynamic title in chat text as per cyclic drop down list.

there is one cyclic group which has three dimensions(original dimensions renamed in label)

I want to display the dimensions from drop down to title in chart.

Like, if i select savings reason from cyclic drill down in chart then it should show Top-10 Savings reasons.

Same if i select lost reason frrom cyclic drill down in chart then it should show Top-10 Lost reasons

Regards,

mahamed

[Mahamed_Qlik]

Here is that.

[jonathandienst]

Can you reduce that in size?

Preparing examples for Upload - Reduction and Data Scrambling

You probably need something like this:

='Top 10 - ' & Pick(Match(GetCurrentField(GroupName), 'first field name', 'second field name'), 'first label', 'second label')

Replace the field names and labels according to your needs

[Mahamed_Qlik]

Jonathan,

It works for only single field name and its label.

Any reason?

[Anonymous]

Try with GetCurrentField('GroupName')

[Digvijay_Singh]

I think only way to go is as Jonathan suggested. Pick/Match will help to define three values in one go. I don't see any function available which picks the label of the group dimension field.

[#7]

Hi Mahamed,

Try this

='Top 10 - ' & if(GetCurrentField(GroupName)='Value1','Value1',

                         if(GetCurrentField(GroupName)='Value2','Value2',

                              if(GetCurrentField(GroupName)='Value3','Value3')))

Hope this may help's you.

Regards,

Arjun.

[Mahamed_Qlik]

Hi arjun,

What if I have multiple group name? again i have to right the above expression for each group name.

Is there any way to make the group name dynamic too?

[Anonymous]

In this case, you just define those Group Name and then try to implement like what we does in Adhoc Reports.

Adhoc reporting in Qlikview