topic Re: Need help in QlikView

Need help

Mahamed_Qlik — Tue, 23 Feb 2016 12:30:14 GMT

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

Re: Need help

Anonymous — Tue, 23 Feb 2016 12:33:45 GMT

sample file?

Re: Need help

Colin-Albert — Tue, 23 Feb 2016 12:36:53 GMT

See this post

showing cyclic group selection in title showing cyclic group selection in title

Re: Need help

tresB — Tue, 23 Feb 2016 12:37:36 GMT

May be using function like: GetCurrentField(GroupName)

Re: Need help

jonathandienst — Tue, 23 Feb 2016 12:44:50 GMT

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

Replace GroupName with the correct name of your cyclic group

Re: Need help

Mahamed_Qlik — Tue, 23 Feb 2016 13:13:13 GMT

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.

Re: Need help

jonathandienst — Tue, 23 Feb 2016 13:24:54 GMT

Post your qvw or a representative sample.

Re: Need help

Anonymous — Tue, 23 Feb 2016 13:27:27 GMT

HI,

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

Re: Need help

avinashelite — Tue, 23 Feb 2016 13:32:02 GMT

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

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

Re: Need help

Mahamed_Qlik — Tue, 23 Feb 2016 13:37:24 GMT

Avinash,

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

Re: Need help

Mahamed_Qlik — Tue, 23 Feb 2016 13:39:55 GMT

Here is that.

Re: Need help

jonathandienst — Wed, 24 Feb 2016 06:03:52 GMT

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

Re: Need help

Mahamed_Qlik — Wed, 24 Feb 2016 07:03:04 GMT

Jonathan,

It works for only single field name and its label.

Any reason?

Re: Need help

Anonymous — Wed, 24 Feb 2016 07:07:20 GMT

Try with GetCurrentField('GroupName')

Re: Need help

Digvijay_Singh — Wed, 24 Feb 2016 07:16:08 GMT

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.

Re: Need help

Wed, 24 Feb 2016 07:17:04 GMT

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.

Re: Need help

Mahamed_Qlik — Wed, 24 Feb 2016 07:22:48 GMT

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?

Re: Need help

Anonymous — Wed, 24 Feb 2016 07:29:29 GMT

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