Hi I am trying to add a new line in an expression in QlikSense but cannot get anything to work.
I have tried the below, and have also tried using \n to no avail. Any thoughts?
'Origin:' & Origin & Chr(13) & Chr(10) & BrandName & ' - ' & AncType & '(' & AncSubType & ') = ' & COUNT(CustomerID)
Solved! Go to Solution.
in strings, chr(10) always worked for me up to now - chr(10) was never needed.
But I am working with QlikView, not QlikSense, so there might be a difference?
Yes it could be.
Test your expression in a standard object such as the Text & Image object, and if that works, it is an issue for the developer of the extension.
One other thought, try adding a Maxstring() around any other fields in your text expression, as all fields should be referenced using some aggregation function.
If you do not specify an aggregation expression then QlikView can effectively add an only() around the expression thus the value will return null unless only one value is returned. I guess this also applies in Sense.
'Origin:' & maxtstring(Origin) & Chr(13) & Chr(10) & maxstring(BrandName) & ' - ' & maxstring(AncType) & '(' & maxstring(AncSubType) & ') = ' & COUNT(CustomerID)
maxstring(name) & ' ' & count(customer) works fine in a text object for me in Sense 1.1.0
Try adding your expression in a text object rather than the 3rd party extension.
Prove your expression works first.