I am looking to display a simple text string in QlikSense.
In QlikView I would use a Text Box with an expression like: =Only([MyDim]) to display when only 1 MyDim is selected, otherwise -.
The QlikSense KPI object only appears to be able to display numbers and not text.
Any suggestions ?
Solved! Go to Solution.
Hi Bill have you tried this with a Text Image object?
Here is another expression - I got as an example, it appends a different symbol to the measure - depending on what the value is:
'$##0.0' & pick((floor(log10(fabs(sum(Scale)))/3)+1),'',' K',' M',' B')
Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.
Strange, but I can't get the Text showing big & centred with a Test & Image Object.
Is this me being stupid, or is this just how it works.
[KPI Object looks fine though, so I do have a solution]
Glad you have a solution -
In order to get it to format, you can double-click the expression object and then change the settings.
Just for reference this is as big (XL) as I can get the text to show, with the Text and Image object:
I like the KPI object solution better
Thanks for your tip "you can double-click the expression object and then change the settings". It is quite fun giving QlikSense a try in my spare time, but there are many basics like this that I am still learning.
But as you say the KPI object does seem better.