Row Coloring for Missing Values

[#1]

Hi,

As you can see in the attached app, each row of the table will take a color based on this expression in its background property:

if(even(aggr(NODISTINCT rowno(), PAIR)),rgb(210,210,210),white())

which is to highlight each pair of rows with alternating white and gray based on PAIR values.

This works fine until there is a missing value in one of the expressions in the table. For example,  Customer F, PAIR 2, subcategory 4 has no imported data for Measure 1. So qlikview is not colorizing the subcategory 4 row with gray (as measure does not exist). However, this row has data for Measure 2.

So does anyone know of a trick to make it paint that row gray as it should.

[kuba_michalik · Accepted solution]

If the PAIR order is crucial and it's not just about simple banding (for example, you make selections for subcategory so only one row per some PAIRs is visible), then use this:

If(Even(Only(TOTAL<PAIR> Aggr(NODISTINCT RowNo(), PAIR))),RGB(210,210,210),White())

as the color expression.

I find it a rather unusual use of Aggr. Thanks for the learning opportunity!

[#3]

Thank you.