Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
Not applicable

Text object problem

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

1 Solution

Accepted Solutions

Re: Text object problem

Try this:

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

2 Replies

Re: Text object problem

Try this:

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

Not applicable

Re: Text object problem

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