Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
Specialist
Specialist

text color

Hi All,

I am using a table in qliksense and it has 2 dimenions and one expression . the nubers are correct or basically i was able to plot a table . 

My expression is simple  (sum(Sales)+Sum(Benifit))/2 

And under Text color expression Iam using this expression to color the text . 

if ((sum(Sales)+Sum(Benifit))/2 <50,red(),

(sum(Sales)+Sum(Benifit))/2 >50 and (sum(Sales)+Sum(Benifit))/2 <=80,yellow() ,Green()))

This is not giving me the color , 

Can you please tell me how do i achive this ? 

And also i see that i need to align the values in centre  but the option is only either left or right . ?

I am new to QlikSense trying to learn this things if any one of you can please help me with this ? it would be really greatfull .

Thanks,

5 Replies
NitinK7
Specialist
Specialist

Try below Expression

if ( (sum(sales)+Sum(benefit))/2 <50, red(),
if( (sum(sales)+Sum(benefit))/2 >50 and (sum(sales)+Sum(benefit))/2 <=80,yellow() ,Green()))

 

 

smilingjohn
Specialist
Specialist
Author

Hi All,

I ahev got the coloring the text fomat ...

Can please someone tell me how do i bold the folnt size and align the data in centre in an table?

An is there in document on how do we use extension objects in qliksense

NitinK7
Specialist
Specialist

Do you want all text in bold format?

smilingjohn
Specialist
Specialist
Author

@NitinK7  Yes  in the table i want to display all the values in bold. 

 

NitinK7
Specialist
Specialist

Hi,

Do you know about custom theme ?

you need to use theme for that.

refer below link

https://sensetheme.com/edit