Text object problem

[#1]

Hello.

I am trying to use text object on QlikView.

On this text object, I am trying to put a number value and some text.

But the result is always just a '-'.

When I put the number value = sum(if([date]=varMaxDate,#1))-sum(if([date]=varMaxDate-1,#1)) alone on the text box, it shows the number value on text object. But it does not work when i put that and text like this:

= sum(if([date]=varMaxDate,#1))-sum(if([date]=varMaxDate-1,#1)) & 'some text'

What is the problem? How can I accomplish this?

Cheers,

Niko

[sunny_talwar · Accepted solution]

Try this:

=(Sum(if([date]=varMaxDate,#1))-sum(if([date]=varMaxDate-1,#1))) & 'some text'

[#3]

Well thank you Sunny T!

I thought that I had already tried something like that, but obviously I had not.

Simple solution, thank you!

Cheers,

Niko