topic Re: Pivot table dimensionality in QlikView

Pivot table dimensionality

sankar_ganesh — Thu, 19 Jun 2014 15:01:35 GMT

Product_Category	Product	Sales
X		10
X	A	20
X	B	30
X	C	0

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.

Regards,

Sankar

Re: Pivot table dimensionality

veidlburkhard — Thu, 19 Jun 2014 15:15:38 GMT

Hi Sankar,

no problem, this is easy. See the picture below

Hope this helps

Burkhard

Re: Pivot table dimensionality

sankar_ganesh — Mon, 23 Jun 2014 07:30:59 GMT

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

Re: Pivot table dimensionality

jagan — Mon, 23 Jun 2014 07:41:34 GMT

HI,

Try this in BackGround Color

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

Regards,

Jagan.