topic display text value - alternative to sum() in QlikView

display text value - alternative to sum()

Tue, 17 Apr 2012 14:21:55 GMT

usually, text values are displayed by just =(fildname)

if certain expressions are used, this doesnt seem to work.

Is there an alternative to the "sum" operator ?

sum(CustomerID) results in "-", because CustomerID='AX001FE' ; alphanumeric.

- text(), treats numeric values as txt similar to num()

- there is minstring or maxstring, but no string()

is there an alternative to display

<operator>({<[Tablename]={'GroupA','GroupB'}>}CustomerID) ?

any suggestions are welcome

display text value - alternative to sum()

CELAMBARASAN — Tue, 17 Apr 2012 14:34:18 GMT

Hi,

Have you tried using Concat Function?

Concat(({<[Tablename]={'GroupA','GroupB'}>}CustomerID,',')

Celambarasan

display text value - alternative to sum()

Tue, 22 May 2012 12:59:29 GMT

thank you Celambarasan. This is exactly what solves this (and some other) problems.

The full text search in the reference manual found only text(), which f.e. as the opposite of num() only changes the output of a expression (if applicable) to text form.