Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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()))
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
Do you want all text in bold format?
@NitinK7 Yes in the table i want to display all the values in bold.
Hi,
Do you know about custom theme ?
you need to use theme for that.
refer below link