topic Re: Background Color for Full Row is not working in Pivot Table in QlikView

Background Color for Full Row is not working in Pivot Table

sakthi266 — Fri, 12 Nov 2021 14:37:22 GMT

Hi Team,

I am working on Pivot table with two dimension and one expression. I am moving one dimension from vertical to horizontal then it is showing with Space. Is it possible to remove that space. Please refer the attachment

1. Data in first sheet.

2. Showing as sheet 2

But required as mentioned in the sheet 2 below

Regards,

Sakthivel.S

9843527174

Re: Background Color for Full Row is not working in Pivot Table

AshutoshBhumkar — Sat, 13 Nov 2021 04:43:23 GMT

Hello,

As there are not blank spaces or nulls in your data, Blank space should not come in Pivot.

Could you please provide some Qlikview table screenshot ?

Thanks,
Ashutosh

Re: Background Color for Full Row is not working in Pivot Table

ramasaisaksoft — Mon, 15 Nov 2021 09:04:26 GMT

if you have Null Values in your data then you can ignore (Suppress when Value is Null)those in Dimensions.

if you want Background ground color for a table /For each Row

Pivot Table--> Properties-->Style-->Current Style (Drop down list )--> select Pyjama Green-->Stripes every 1 Row.