topic Re: Color totals in pivot tables in App Development

Color totals in pivot tables

tomf122 — Tue, 14 Jun 2022 14:44:57 GMT

I am trying to color code the total columns in my pivot table so they are easier to stand out.

I was able to color code each dimension total without issue but having trouble doing so on the measures.

I have the below chart and I basically want the total value to highlighted in each section.

Current logic i have which is working for the first total but not the second as its highlighting individual totals to.

If(rowno() =0,rgb(0,220,255),
If(rowno() =1,rgb(0,0,255)))

Is there a way to declare the total rows so these can be set ?

justISO — Wed, 15 Jun 2022 05:57:03 GMT

Hi, you can include 'dimensionality' to your formula for better accuracy:

if(Dimensionality()=0 and RowNo()=1, Green(), if(Dimensionality()=1 and RowNo()=1, LightBlue(), if(Dimensionality()=2 and RowNo()=0, LightCyan() )))

tomf122 — Wed, 15 Jun 2022 10:20:04 GMT

Thank you this is working great.

Just for my own knowledge how does the dimensionality function work. I wouldn't be familiar with it.

justISO — Wed, 15 Jun 2022 10:34:55 GMT

Qlik Help could be the first source to look at: