topic Re: Show Dimension as Title Name in Visualization and Usability

Show Dimension as Title Name

scotly-victor — Thu, 06 Oct 2016 07:16:15 GMT

Hi Everyone,

I want to show dimensionField as a Title in Bar Chart and if change the alternate dimension the alternate dimension should be Shown on title.

Can anybody Help?

Re: Show Dimension as Title Name

lakshmikandh — Thu, 06 Oct 2016 07:39:50 GMT

Try using this

https://help.qlik.com/en-US/sense/3.1/Subsystems/Hub/Content/Scripting/SystemFunctions/GetObjectField.htm

Re: Show Dimension as Title Name

Anonymous — Thu, 06 Oct 2016 07:53:19 GMT

Go to Expression---> Label---> GetObjectField(1)---> Apply

Here if you will give GetObjectField(0)--that it will take first dimension name and for GetObjectField(1) , 2nd dimension name.

Thanks,

Re: Show Dimension as Title Name

scotly-victor — Thu, 06 Oct 2016 08:44:42 GMT

Sorry ,it did not work

Re: Show Dimension as Title Name

Thu, 06 Oct 2016 10:35:04 GMT

Goto Expression--> Label--> GetObjectField(0),

Here GetObjectField(0) will give first dimension name of Cart and GetObjectField(1) will give name of second dimension.

For giving name of both field you can apply following formula

=GetObjectField(0) &' &' & GetObjectField(1)

Thanks,

Re: Show Dimension as Title Name

Anonymous — Thu, 06 Oct 2016 11:58:11 GMT

Hello Scotly

Below should help you.

How to make Chart Title dynamic based on group ... | Qlik Community

Re: Show Dimension as Title Name

Anonymous — Thu, 06 Oct 2016 12:10:13 GMT

Could you not just use the dimension name in the title bar like ='Chart title = '&[DimensionName]

Re: Show Dimension as Title Name

lakshmikandh — Thu, 06 Oct 2016 12:14:14 GMT

Sorry, Currently this option of extracting the Dimension name not available in Qlik sense.

Re: Show Dimension as Title Name

ogster1974 — Thu, 06 Oct 2016 14:48:56 GMT

Using a dimension in a title would not be very practical as there is no control of the length of the dimension value you would have to insert.

An alternative way of creating a dynamic title and chart would be through the use of a variable. See my attached example. I used an extension qsVariable to bring in the buttons to set my variables then used the variables to set my dimensions and measures.

Hope this helps

Andy

Re: Show Dimension as Title Name

lakshmikandh — Fri, 07 Oct 2016 05:25:13 GMT

This is not working in Chart Labels,Can you attach a sample Qvf where this expression is working ?

Re: Show Dimension as Title Name

lakshmikandh — Fri, 07 Oct 2016 05:25:36 GMT

Please share sample Qvf

Re: Show Dimension as Title Name

shraddha_g — Fri, 07 Oct 2016 08:50:13 GMT

I guess this will work in case of Qlikview.

In qliksense, Label is simple taxt-box and not Expression editor.

However dynamic dimension name in Title is not possible if you are using Alternate dimension.

Re: Show Dimension as Title Name

shraddha_g — Fri, 07 Oct 2016 08:52:44 GMT

There is workaround for using alternate dimension if you want dynamic title name according to Dimension selected.

You can use Qlik Branch and using variable you can achieve this.