Chart title From DB

[bmaheshwari]

Hello sir,

i want to display Chart title from database 

Sql Query for this :

select LabelValue from labels
where FieldKey = 'XXXXX' 

can you please suggest how we apply this condition in Title Expression in Qlik Sense.

Thanks.

[gn_marvs1989 · Accepted solution]

You just need to load the labels from the DB into a Island table in Qlikview. 

Then use this expression:

=only(LabelValue )

if you have multiple LabelValue , you need to add another Field in you table that will serve as Flag.

Example:

SQL select LabelID, LabelValue from labels;

Then expression:

=only({<LabelID={'xx'}>} LabelValue )