Color banding within groups on a straight table

Thu, 09 May 2013 16:45:43 GMT

Trying to format a Straight Tables coloring to change on Groups. This can easily be accomplished by adding a Background Color Expression to the Dimesions such as:

=IF (SRC_SYS_CD='MRC',LightCyan()
,IF (SRC_SYS_CD='TTN',LightRed()
,LightBlue

To take this a step further I wanted to introduce color banding within the groups to simulate the Pyjama Stype at a set level. I thought this would work:

=IF (Even(RowNo(TOTAL)),
IF (SRC_SYS_CD = 'MRC',Cyan()
,IF (SRC_SYS_CD = 'TTN',Red()
,IF (SRC_SYS_CD = 'EMR',Blue()
,Green())))
, (IF (SRC_SYS_CD = 'MRC',LightCyan()
,IF (SRC_SYS_CD = 'TTN',LightRed()
,IF (SRC_SYS_CD = 'EMR',LightBlue()
,LightGreen())))))

But it doesn't work as expected. Although I get banding on groups, it seems to negate the row filter I have in my Expression Columns Expressions. I've tried adding these same Expression filters to the Background Color Expressions, but as I expected that only effects the color on the rows that are displayed, it does not reinstate the proper row filtering from the Expression Column filter. My theory is this "RowCol" function is the culprit somehow....

topic Color banding within groups on a straight table in QlikView

Color banding within groups on a straight table