Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
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 ?
Should have tried harder before posting the above.
On the KPI object I changde the Number formatting to Custom and it now displays the text ok.
Should have tried harder before posting the above.
On the KPI object I changde the Number formatting to Custom and it now displays the text ok.
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:
num(
sum(Scale)
/
pow(1000 ,floor(log10(fabs(sum(Scale)))/3))
,
'$##0.0' & pick((floor(log10(fabs(sum(Scale)))/3)+1),'',' K',' M',' B')
)
HTH
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.
Regards,
Mike Tarallo
Qlik
AH very cool - I see that too with the KPI object.
Michael
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
Michael
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.