Discussion Board for collaboration related to QlikView App Development.
Hello. I hope I've chosen the correct location.
In qlikview, I am trying to create a text box that has a concatenation and a count.
=If(Count(X) > Count(Y), '+', '-' ) & Count(X) - Count(Y) & ' some text'
what I am looking for as a result is '+12 some text'
The result I am getting is '12 some text'
I have tried just +,-
I tried "+","-"
not sure why it wont show up.
=If(Count(X) > Count(Y), '+', '-' ) & Text(Count(X) - Count(Y)) & ' some text'
View solution in original post
Thanks! Worked like a charm.