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: 
nikhilgarg
Specialist II
Specialist II

coloring the totals row in straight table in qlik sense

Hello,

I have a straight table in QLIK SENSE, i want to color the TOTALS row in it. I ahve tried with fn. Isnull(row()) and dimensionality() but none of these seems to work. Pls find attached snapshot for your reference.

Can someone help me in this?

13 Replies
pradosh_thakur
Master II
Master II

what is your color expression ? can you post the expression ? A sample app is better if you can .

Learning never stops.
nikhilgarg
Specialist II
Specialist II
Author

I am using folowing expression for color coding;

= If(Even(RowNo(TOTAL)) , RGB(203, 209, 225), RGB(231,234,241))

pradosh_thakur
Master II
Master II

pick(match(dimensionality(),0)+1,If(Even(RowNo(TOTAL)) , RGB(203, 209, 225), RGB(231,234,241)),color_for_total)


or


if(dimensionality()=0,color_for_total,If(Even(RowNo(TOTAL)) , RGB(203, 209, 225), RGB(231,234,241)))

Learning never stops.
nikhilgarg
Specialist II
Specialist II
Author

Hey,

I tried this as well, but does not work

pradosh_thakur
Master II
Master II

post your sample nikhil..We will be able to  help you better.

Learning never stops.
nikhilgarg
Specialist II
Specialist II
Author

Give me some time, will upload it for sure

rsing122
Contributor II
Contributor II

Hi Nikhil,

Were you able to resolve this. If yes, could you please share how when you get a chance?

Cheers

R

nikhilgarg
Specialist II
Specialist II
Author

Hey Rahul,

Didnt get the soultion to color Totals row. So, deployed as it is

rsing122
Contributor II
Contributor II

That's a bummer. I'm still looking for a solution to this one. Thanks for sharing.