QlikView App Dev

[scottc00]

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.

Thanks

[Gysbert_Wassenaar · Accepted solution]

Try:

=If(Count(X) > Count(Y), '+', '-' ) & Text(Count(X) - Count(Y)) & ' some text'

[scottc00]

Thanks!  Worked like a charm.