Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

display text value - alternative to sum()

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

1 Solution

Accepted Solutions

display text value - alternative to sum()

Hi,

     Have you tried using Concat Function?

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

Celambarasan

2 Replies

display text value - alternative to sum()

Hi,

     Have you tried using Concat Function?

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

Celambarasan

Not applicable

display text value - alternative to sum()

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.

Community Browser