Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

nikhilgarg
Contributor III

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?

11 Replies
pradosh_thakur
Honored Contributor II

Re: coloring the totals row in straight table in qlik sense

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

Learning never stops.
nikhilgarg
Contributor III

Re: coloring the totals row in straight table in qlik sense

I am using folowing expression for color coding;

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

pradosh_thakur
Honored Contributor II

Re: coloring the totals row in straight table in qlik sense

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
Contributor III

Re: coloring the totals row in straight table in qlik sense

Hey,

I tried this as well, but does not work

pradosh_thakur
Honored Contributor II

Re: coloring the totals row in straight table in qlik sense

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

Learning never stops.
nikhilgarg
Contributor III

Re: coloring the totals row in straight table in qlik sense

Give me some time, will upload it for sure

rsing122
New Contributor

Re: coloring the totals row in straight table in qlik sense

Hi Nikhil,

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

Cheers

R

nikhilgarg
Contributor III

Re: coloring the totals row in straight table in qlik sense

Hey Rahul,

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

rsing122
New Contributor

Re: coloring the totals row in straight table in qlik sense

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

Community Browser