topic Re: Expression in QlikView

Expression

Wed, 19 Dec 2012 13:48:09 GMT

I have an expression for sum(sales) how to display in the caption such that it shows ''Total sales=sum(sales). in place of sum(sales) i should see the value.

eg: Total Sales = 2012

Re: Expression

Gysbert_Wassenaar — Wed, 19 Dec 2012 14:02:22 GMT

Try: = 'Total Sales = ' & sum(sales)

Re: Expression

rwunderlich — Wed, 19 Dec 2012 19:36:33 GMT

Do you mean the display in the hover pop-up? What kind of object (chart) do you hve the expression in?

-Rob

Re: Expression

Thu, 20 Dec 2012 12:50:34 GMT

Hi Gysbert,

Thanks for that. Now it is working

Re: Expression

Thu, 20 Dec 2012 12:52:28 GMT

Hi Rob ,

I am using Pie chart .

We have different type s of representation for each type of chart? in my case as Gysbert said = 'Total Sales = ' & sum(sales) is working . Can you please tell me , what if i use different charts

Re: Expression

MayilVahanan — Thu, 20 Dec 2012 14:03:01 GMT

For any chart, u can use like this

= 'Total Sales = ' & sum(Sales)

& is used for concat the values

hope it helps

Re: Expression

rwunderlich — Thu, 20 Dec 2012 16:35:12 GMT

It's the same caption expression for any chart type. I was just trying to clarify if the question was about the caption or hover pop-up.

Don't forget to mark Gysbert's answer correct.

-Rob

Re: Expression

Fri, 21 Dec 2012 10:18:52 GMT

Hi Mayil,

Thanks for the information.

Re: Expression

Fri, 21 Dec 2012 10:20:21 GMT

Hi Rob ,

Thanks for the information