topic Text object problem in QlikView

Text object problem

Tue, 08 Mar 2016 11:17:47 GMT

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

Re: Text object problem

sunny_talwar — Tue, 08 Mar 2016 11:28:26 GMT

Try this:

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

Re: Text object problem

Tue, 08 Mar 2016 11:31:02 GMT

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