Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this:
=(Sum(if([date]=varMaxDate,#1))-sum(if([date]=varMaxDate-1,#1))) & 'some text'
Try this:
=(Sum(if([date]=varMaxDate,#1))-sum(if([date]=varMaxDate-1,#1))) & 'some text'
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