topic Re: Dynamic Chart Name in QlikView

Dynamic Chart Name

stjernvd — Mon, 13 Jul 2015 12:43:00 GMT

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?)

Thanks

Danielle

Re: Dynamic Chart Name

sunny_talwar — Mon, 13 Jul 2015 12:45:34 GMT

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)

Re: Dynamic Chart Name

sunny_talwar — Mon, 13 Jul 2015 12:46:16 GMT

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')

Re: Dynamic Chart Name

avinashelite — Mon, 13 Jul 2015 12:51:58 GMT

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,'|'))

Re: Dynamic Chart Name

stjernvd — Mon, 13 Jul 2015 13:45:28 GMT

Thank you!