Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Display Simple Text String

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 ?

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

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.

View solution in original post

6 Replies
Anonymous
Not applicable
Author

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
Employee
Employee

Hi Bill have you tried  this with a Text Image object?

7-14-2015 8-50-54 AM.png

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

Regards,
Mike Tarallo
Qlik
Michael_Tarallo
Employee
Employee

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

Regards,
Mike Tarallo
Qlik
Anonymous
Not applicable
Author

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
Employee
Employee

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

Regards,
Mike Tarallo
Qlik
Anonymous
Not applicable
Author

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.