Display Simple Text String

[Anonymous]

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 ?

[Anonymous · Accepted solution]

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.

[Michael_Tarallo]

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

[Michael_Tarallo]

AH very cool - I see that too with the KPI object.

[Anonymous]

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]

[Michael_Tarallo]

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

[Anonymous]

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.