topic Re: Pivot table - Accent style customization in QlikView

Pivot table - Accent style customization

Fri, 03 Jan 2014 01:47:23 GMT

Dear community,

Could we customize pivot table to accent style as shown below?

Thanks and best regards,

Chanel

Re: Pivot table - Accent style customization

Sokkorn — Fri, 03 Jan 2014 02:40:47 GMT

Hi Ms. Chanel,

This can be done easily by using Straight Table with image below

By the way, we can achieve it in Pivot Table as well, but need more input. Let try

1. Add new Expressions: RowNo(TOTAL)

2. Select new expression -> Check on "Conditional" -> Type 1<>1 in difinition box

3. Goto "Presentation" tab -> Select expresion "RowNo(TOTAL)" -> Uncheck "Suppress Zero-Values"

4. Go back to "Expression" tab -> Expend expression by click on + sign -> Select "Background Color" -> Definition: If(Mod(RowNo(TOTAL),2)=0,RGB(214,233,239),RGB(255,255,255))

You need to apply "Background Color" for all expression and dimension.

Regards,

Sokkorn

Re: Pivot table - Accent style customization

jagan — Fri, 03 Jan 2014 02:47:01 GMT

Hi,

Use this expression in Background color option of Expressions and Dimensions

=If(Mod(RowNo(TOTAL), 2) = 0, RGB(100,0,0))

Regards,

Jagan.

Re: Pivot table - Accent style customization

Fri, 03 Jan 2014 02:52:38 GMT

Thanks so much, Jagan!!!

Here we go:

Best regards,

Chanel