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

[Anonymous]

sample file?

[Colin-Albert]

See this post

showing cyclic group selection in titleshowing cyclic group selection in title

[tresesco]

May be using function like: GetCurrentField(GroupName)

[jonathandienst]

='Top 10 - ' & GetCurrentField(GroupName) & 's'

Replace GroupName with the correct name of your cyclic group

[Mahamed_Qlik]

Hi Jonathan,

Thanks for your feedback.

But it is showing original dimension name as per database table.

But i need to show the dimension name which is renamed or label while creating cyclic group.

[jonathandienst]

Post your qvw or a representative sample.

[Anonymous]

HI,

Use the function GetCurrentField(CycleName) to get the current selected dimension from the cycle

[avinashelite]

you need to write a if condition on this ....

like

if(GetCurrentField(CycleName)='Column_A','A')

GetCurrentField will give you the name of the column as per the script ..if you want a customize name then you need to re-write it in the script or need to use the if condition in the front end as specified above

[Mahamed_Qlik]

Avinash,

this is fine if there is only one value in cyclic group i do have three values in cyclic group then how?