topic Re: Expression syntax in QlikView

Expression syntax

scottc00 — Wed, 12 May 2021 15:41:37 GMT

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 — Wed, 12 May 2021 16:04:00 GMT

Try:

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

scottc00 — Wed, 12 May 2021 16:31:27 GMT

Thanks! Worked like a charm.