Discussion board where members can get started with QlikView.
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
any suggestions are welcome
Go to Solution.
Have you tried using Concat Function?
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.