topic Re: Pivot table alternate colour by dimension row value in QlikView

Pivot table alternate colour by dimension row value

Pedro_Rodriguez — Sat, 16 Nov 2024 21:41:15 GMT

Hi all,

I have a pivot table, and I want to get alternate colours on it based on the first dimension value. Something like this:

The thing is that if I select 1 & 3 in Dim1, I need 1 in white and 3 in yellow.

Find enclosed this case

Thanks a lot in advance!

Re: Pivot table alternate colour by dimension row value

sunny_talwar — Thu, 27 Dec 2018 12:05:12 GMT

Try this expression for background color

=If(Even(Aggr(NODISTINCT RowNo(), Dim1)), Yellow())

When 1 and 3 are selected

When nothing is selected

Re: Pivot table alternate colour by dimension row value

Pedro_Rodriguez — Thu, 27 Dec 2018 12:22:30 GMT

Thanks!, it works perfectly

Re: Pivot table alternate colour by dimension row value

PriyankaShivhare — Wed, 04 Mar 2020 05:50:54 GMT

Hi,

I am trying to workout the same formula for my qliksense pivot table with latest edition of background colour feature for pivot dimensions. but it is not working. here my dim1 is not numeric .

Thanks in advance.

Re: Pivot table alternate colour by dimension row value

FelixM — Tue, 14 Apr 2020 15:03:39 GMT

I get stuck in the same problem. My Account Dim = HDCT. Coloring the row just by dimension works. But it doesn't work on the 0 / null values for the HDCT row. Means all values > /< in the HDCT row get colored correct. The zeros don't. I'd like to have the zero's colored too with the same format.

Thanks very much for the help