String Expression - Strip Out First Word

[jmonroe918]

Hello:

I am using the Cyclic function on a pie chart and I would like to see the label above the legend but not the table name. Example: "CAPA.Status"; I want to only see "Status".

This will be the case across several other charts with different names, so I want to apply this to those charts as well.

Thanks.

Jeff 

[Anonymous · Accepted solution]

In the Label Box put =SubField(GetCurrentField(CycleGroupName),'.',2)

[jmonroe918]

Michael:

That worked perfectly. Thanks so much.

Jeff

[hic]

I think it would be much better if you just renamed the fields properly in the script to start with with. Then you would not have to do this in every object that these fields are used. It would simplify everything in the long run.

See more on http://community.qlik.com/blogs/qlikviewdesignblog/2012/09/25/how-to-rename-fields

HIC