Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
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
sunny_talwar

Try this:

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

View solution in original post

2 Replies
sunny_talwar

Try this:

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

Not applicable
Author

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