topic Re: Chart Title in QlikView

Chart Title

Thu, 09 Oct 2014 08:55:23 GMT

Hi all

i'm wondering how can i get my expression value as a window title of my chart : pics below.

expression : sum({$<Product={USER_EXP},METRIC_ID={'1'}>}VALUE)

thanks

Re: Chart Title

anbu1984 — Thu, 09 Oct 2014 09:05:05 GMT

Which value you want to set as Title? Min or Max of Sum?

Re: Chart Title

Thu, 09 Oct 2014 09:07:00 GMT

I'm trying to put in my title the value : "signup/smart_landing_v2.php"

Re: Chart Title

datanibbler — Thu, 09 Oct 2014 09:09:45 GMT

Hi kasdali,

do you want just a description of your metric in the title - or one specific value? - For the latter, you'd have to also specify a specific point on the dimension to use - or you'd have to use an average. But what would be the good of that?

Re: Chart Title

anbu1984 — Thu, 09 Oct 2014 09:11:34 GMT

You can set the Title in Chart Properties --> Caption Tab --> Title Text

Re: Chart Title

PrashantSangle — Thu, 09 Oct 2014 09:12:17 GMT

Hi,

"signup/smart_landing_v2.php" is your expression It contain more than one value

Then which value you wnat to show to the use

It is min value ? max vale? or range ? or Total Value within range?

If you want Total value in range

sum({$<Product={USER_EXP},METRIC_ID={'1'}>} TOTAL VALUE)

Regards

Re: Chart Title

Thu, 09 Oct 2014 09:13:41 GMT

Dear Kasdali,

But when I am trying I am able top get expression on chart title:-

Please see attached image:-

Re: Chart Title

Thu, 09 Oct 2014 09:34:20 GMT

I tryed this, but i'm looking to get the value of my dimension not a expression. i said in my first post that i'm trying to get the value of my expression sorry.

Re: Chart Title

Thu, 09 Oct 2014 10:19:22 GMT

I get it

it works with : =only({$<Product={USER_EXP},METRIC_ID={'1'}>}SubField(METRICPATH,'|',3))

thanks all