Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

sankar_ganesh
New Contributor

Pivot table dimensionality

Product_CategoryProductSales
X10
XA20
XB30
XC0

Hello,

By loading the above table data as a source, I have created a pivot table in a qlikview report as shown below. Now I need to display the row , highlighted by the blue rectangle below, in the red background , the rule is to show that 'Product category' row in red background when there is a Product(2nd column) under that category  having sales =0. Here the Product C has zero sales , hence that Product Category row needs to be shown with the redbackground. Is it possible ? Can anyone help.

Capture.JPG.jpg

Regards,

Sankar

3 Replies
veidlburkhard
Contributor III

Re: Pivot table dimensionality

Hi Sankar,

no problem, this is easy. See the picture below

PivotTest.jpg

Hope this helps

Burkhard

sankar_ganesh
New Contributor

Re: Pivot table dimensionality

Hi Burkhard,

Thanks for your inputs. I want to highlight the row which do not have any 'Product' value (i.e. having '-') in the red background as shown in the screenshot I have given.

Regards,

Sankar

MVP
MVP

Re: Pivot table dimensionality

HI,

Try this in BackGround Color

=If(Len(Product) = 0, RGB(255, 0, 0))

Regards,

Jagan.

Community Browser