topic Dynamic Chart title in QlikView

Dynamic Chart title

Tue, 19 Jul 2011 20:29:42 GMT

Hi,

I have a chart for which i would like to set a dynamic title.

So I am calculating a count(Key) in my graph and in the title i would like to display: Open bugs = count(key)

if i just write =count(key), it works.

but i want to display if(status = 'open', count(key)) and this doesnt work.

What should i change?

Thanks!

erichshiino — Tue, 19 Jul 2011 20:43:27 GMT

Hi,

This if will only work if there is only one possible value (selected) for status (=open)

You can use set analysis.

The tittle expression will probably be:

= 'Open bugs: '& count({<status={open}>} key)

Hope this helps,

Erich

Tue, 19 Jul 2011 20:53:20 GMT

The count still doesnt come right. It should display the title as: Open bugs: 2

but instead it is giving the expression only!

erichshiino — Tue, 19 Jul 2011 20:57:47 GMT

Did you put the =' in the beggining?

The tittle shoud be exactly this

= 'Open bugs: ' & count({<status={open}>} key)

Tue, 19 Jul 2011 21:28:42 GMT

Thanks so much for your help! In addition to this, if i want to make only the number part in a bigger font, how can i do that?