Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Expression

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

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Expression

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


talk is cheap, supply exceeds demand
8 Replies
MVP & Luminary
MVP & Luminary

Re: Expression

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


talk is cheap, supply exceeds demand
MVP & Luminary
MVP & Luminary

Re: Expression

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

-Rob

Not applicable

Re: Expression

Hi Gysbert,

Thanks for that. Now it is working

Not applicable

Re: Expression

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

Hi

For any chart, u can use like this

= 'Total Sales = ' & sum(Sales)

& is used for concat the values

hope it helps

MVP & Luminary
MVP & Luminary

Re: Expression

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

Not applicable

Re: Expression

Hi Mayil,

Thanks for the information.

Not applicable

Re: Expression

Hi Rob ,

Thanks for the information