topic Right function returns incorrect results. in QlikView

Right function returns incorrect results.

nancymarmat — Tue, 16 Feb 2016 18:37:02 GMT

I am trying to filter results in a chart to count the number of items that DO NOT end with the character 'S'.

The expression I am using is: =IF(right(LineItemNumber,1) <>'S', TextCount(distinct LineItemNumber))

The results count all items.

What is wrong with the syntax?

Thank you.

sunny_talwar — Tue, 16 Feb 2016 19:06:18 GMT

May be try this:

TextCount(DISTINCT {<LineItemNumber -= {'*S'}>} LineItemNumber)

TextCount(DISTINCT If(WildMatch(LineItemNumber,'*S'), LineItemNumber))

nancymarmat — Tue, 16 Feb 2016 19:13:56 GMT

Thank you. That worked!