Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Shahzad_Ahsan
Creator III
Creator III

Alternate row color in table chart in Qlik sense

Is there any way to alternate background row colors on Qlik Sense table chart.

1 Solution

Accepted Solutions
pradosh_thakur
Master II
Master II

Hi


if you have more than one dimension you need to use rowno(total) so try this


=if(Even(RowNO(total))=0,LightBlue(),Green())


regards

Pradosh

Learning never stops.

View solution in original post

14 Replies
Ralf_Heukäufer
Partner - Creator III
Partner - Creator III

Yes, you can change it here:

For example use green() or something else:

Color functions ‒ Qlik Sense

If you want to use more than one color you can use if clauses:

if(condition < 1, red(),green())

or for more than tow colors:

if(condition < 1, red(),if(condition >= 1 and condition < 2, green(),if(condition >= 2, blue())))

and so on

Shahzad_Ahsan
Creator III
Creator III
Author

Hi Ralf

Thank you for your answer.

I know about the conditional color, but this work for only that particular dimension.

I need like this;

Alternate row background color;

default-table-style.png

mdmukramali
Specialist III
Specialist III

Dear Shahzad,

Can you try expression in Background color

=if(Even(RowNO())=0,LightBlue(),Green())

1249258.PNG

Ralf_Heukäufer
Partner - Creator III
Partner - Creator III

You can use the following extension for that:

Qlik Branch

In the Standard you only can set Colors by Dimensions and Measures

But with this Extension

You can go to debug mode to get the Object Id from your table and set the even and the odd colors like in the example.

In this case every second table row is red

Shahzad_Ahsan
Creator III
Creator III
Author

Hi Mohammed

Its giving every row Lightblue.

mdmukramali
Specialist III
Specialist III

Hi,

Can you share your sample app.

Shahzad_Ahsan
Creator III
Creator III
Author

This is my table

Untitled13.jpg

mdmukramali
Specialist III
Specialist III

Hi,

Find the attached sample application i used the same expression and it's working fine .

which version of QlikSense are using ?

Thanks,

Mukram.

Shahzad_Ahsan
Creator III
Creator III
Author

I tested your qvf , its working fine but its not working for me. Dont know why??

I am using qliksense 3.2 SR5