Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
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
CELAMBARASAN

Hi,

     Have you tried using Concat Function?

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

Celambarasan

View solution in original post

2 Replies
CELAMBARASAN

Hi,

     Have you tried using Concat Function?

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

Celambarasan

View solution in original post

Not applicable
Author

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.