topic Re: GetCurrentField query in QlikView

GetCurrentField query

knightwriter — Mon, 24 Aug 2015 13:39:26 GMT

Hi All,

I am using the GetCurrentField(goupname) in the general tab under chart title.

This works fine apart from the group name that it is pulling is made up of an expression (ie =Left([Car sales.first name],1) & .....).

Is there a way I change this expression name to 'Sales Person'? Changing the label name under group setting only works for the cyclic logo and not the chart title name.

Suggestions welcome. Thanks.

Re: GetCurrentField query

sunny_talwar — Mon, 24 Aug 2015 13:44:20 GMT

Try this:

If(GetCurrentField(GroupName) = '=Left([Car sales.first name],1) & .....)', Car Sales, GetCurrentField(GroupName))

If(GetCurrentField(GroupName) = '=Left([Car sales.first name],1) & .....)', 'Sales Person', GetCurrentField(GroupName))

Make sure you have the exact expression, including the spaces and commas, within the two single quotes.

HTH

Best,

Sunny

Re: GetCurrentField query

avinashelite — Mon, 24 Aug 2015 13:46:08 GMT

can you please share the sample data or QVW ..it will give us a better idea what exactly your looking for??

OR you can explain with an example

Re: GetCurrentField query

knightwriter — Mon, 24 Aug 2015 14:03:35 GMT

Hey Sunny,

Thanks for the note.

I have put this into the title in chart box and get error in expression.

=IfGetCurrentField ([activity group]) = '=left ([Sales_Sales.First Name],1) & '. ' & [Car_Sales.Last Name]', Car Sales, GetCurrentField([activity group])

Does Car Sales need to be in single quotes? As the chart title should show 'Sales Person'.

Continuing on from this, do I repeat this for the second field in my group?

Re: GetCurrentField query

sunny_talwar — Mon, 24 Aug 2015 14:05:25 GMT

Yes it does. I did make the change in my above comment.

If(GetCurrentField ([activity group]) = '=left ([Sales_Sales.First Name],1) & '. ' & [Car_Sales.Last Name]', 'Sales Person', GetCurrentField([activity group]))

Re: GetCurrentField query

sunny_talwar — Mon, 24 Aug 2015 14:06:03 GMT

And yes repeat this for all your calculated fields.

Re: GetCurrentField query

knightwriter — Mon, 24 Aug 2015 14:10:46 GMT

Hi Avinash.

I have a cyclic group with two fields. The two fields within this group both have expressions in them so when I use the getcurrentfields(groupname) in the Title Chart on the general tab, its pulls the expression from the 'used field'.

This expression then sits above the chart and is not very user friendly.

I want to be able to change the name under the 'used field' to represent something easy to read.

Re: GetCurrentField query

jonathandienst — Mon, 24 Aug 2015 14:13:31 GMT

You can give the expression a label in the Document Properties | Groups tab. Select the Group, Click Edit..., select the calculated field (in Used Fields) and enter a label in the Label box.

Re: GetCurrentField query

knightwriter — Mon, 24 Aug 2015 14:32:07 GMT

Hi Sunny,

Thanks Ive 95% got the answer here.

I still get an error as I've already used single quotes in my group expression to be used within the IF function. See highlighted in red below and so when I use the single quotes I still get this error. How do I get around this?

If(GetCurrentField ([activity group]) = '=left ([Sales_Sales.First Name],1) & '. ' & [Car_Sales.Last Name]', 'Sales Person', GetCurrentField([activity group]))

Your formula works perfectly for the other field in my group (and its has no single quotes in the original expression!)

Re: GetCurrentField query

sunny_talwar — Mon, 24 Aug 2015 14:36:48 GMT

Try this:

If(GetCurrentField ([activity group]) = '=left ([Sales_Sales.First Name],1) & ' & Chr(39) &.& Chr(39) & ' & [Car_Sales.Last Name]', 'Sales Person', GetCurrentField([activity group]))

Chr(39) = Single Quote

Re: GetCurrentField query

sunny_talwar — Mon, 24 Aug 2015 14:41:27 GMT

My bad:

If(GetCurrentField ([activity group]) = '=left ([Sales_Sales.First Name],1) & ' & Chr(39) &'.'& Chr(39) & ' & [Car_Sales.Last Name]', 'Sales Person', GetCurrentField([activity group]))

Re: GetCurrentField query

knightwriter — Mon, 24 Aug 2015 14:42:28 GMT

Hi Jonathan,

Thanks for the suggestion but this does not work. I am looking to change the Used Field name so it will appear in the Graph title rather than pull the expression. Your idea only works for the cyclic logo dropdown as far as i can see.

Re: GetCurrentField query

knightwriter — Mon, 24 Aug 2015 14:53:33 GMT

Hi Sunny,

Really appreciate the help here but its still is not showing although its says expression is ok!

The only change I have made is that I fixed the table names in the expression from Sales_Sales to my table name.

The error must still rely around the Chr(39) workaround. Any final suggestions?

Re: GetCurrentField query

knightwriter — Mon, 24 Aug 2015 14:56:27 GMT

Hi Sunny,

Scrap the above note, it was a spacing difference from '.' to '. ' that did the trick.

Many thanks again and appreciate all the help.

Re: GetCurrentField query

sunny_talwar — Mon, 24 Aug 2015 15:01:23 GMT

Awesome

I am glad that finally it worked.

Best,

Sunny