topic Re: Re: Background Color issue in Pivot Table in Total Row in QlikView

Background Color issue in Pivot Table in Total Row

Thu, 16 Oct 2014 04:11:08 GMT

Hiii alll,

I am using background color expression in Pivt tables but this expression is not working on Total row.

Please help me on this.

Thanks & Regarda

Prince Anand

Re: Background Color issue in Pivot Table in Total Row

ashfaq_haseeb — Thu, 16 Oct 2014 06:30:19 GMT

Hi Anand,

Did you try by custom format cell?

Go to Setting --> user Preference --> Design tab --> and select always show design menu item --> ok.

Now right click on total row in your chart --> click on custom format cell.

Play with the settings here.

Regards

ASHFAQ

Re: Background Color issue in Pivot Table in Total Row

Thu, 16 Oct 2014 06:52:03 GMT

Dear Ashfaq,

thanks for your response.

But I want to show total row background volor with some expression because by using custom format cell the background color will be fixed but i want dynamic color.

Thanks & Regards

Prince Anand

Re: Re: Background Color issue in Pivot Table in Total Row

ashfaq_haseeb — Thu, 16 Oct 2014 06:59:53 GMT

Hi,

Anand there is condition color option available in custom format cell.

have a look at attached image.

Regards

ASHFAQ