Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
stjernvd
Partner
Partner

Dynamic Chart Name

Hi,

I want to make my chart name dynamic in the sense that when I click on the stock and year, the name in the chart changes according to what stock and year is selected. If none are selected I want the title to be 'Stock Performance 2012-2014'.

How can I do this? (also how do I enter a space between dimension names in a chart title?)

Labels.PNG

Title.PNG

Error.PNG

Thanks

Danielle

1 Solution

Accepted Solutions
avinashelite

if your stocks are single select than you can use sunindia‌ expression , if its a multi select you can try like :

If(GetSelectedCount(Year) = 0 and GetSelectedCount(Stock) = 0, 'Stock Performance 2012-2014',

getfieldselection(Year,'|')&'-'&getfieldselection(Stock,'|'))

View solution in original post

4 Replies
sunny_talwar

Try this:

If(GetSelectedCount(Year) = 0 or GetSelectedCount(Stock) = 0, 'Stock Performance 2012-2014', Stock & Year)


If(GetSelectedCount(Year) = 0 or GetSelectedCount(Stock) = 0, 'Stock Performance 2012-2014', Stock & ' ' & Year)

sunny_talwar

Or may be this:

If(GetSelectedCount(Year) = 1 and GetSelectedCount(Stock) = 1, Stock & Year, 'Stock Performance 2012-2014')


If(GetSelectedCount(Year) = 1 and GetSelectedCount(Stock) = 1, Stock & ' ' & Year, 'Stock Performance 2012-2014')

avinashelite

if your stocks are single select than you can use sunindia‌ expression , if its a multi select you can try like :

If(GetSelectedCount(Year) = 0 and GetSelectedCount(Stock) = 0, 'Stock Performance 2012-2014',

getfieldselection(Year,'|')&'-'&getfieldselection(Stock,'|'))

View solution in original post

stjernvd
Partner
Partner
Author

Thank you!