Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
bmaheshwari
Contributor
Contributor

Chart title From DB

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.

1 Solution

Accepted Solutions
gn_marvs1989
Contributor III
Contributor III

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 )

View solution in original post

1 Reply
gn_marvs1989
Contributor III
Contributor III

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 )