Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

Community Browser