topic Re: Pivot heading format in QlikView

Pivot heading format

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have created pivot table which has 2 dimension Product, Month & expression is Sum(Sales).

I have dragged month horizontally for column level. Now Product aligned vertically and month horizontally.

I want to change background color on Month.

Do we have that kind of option? I could not find it

Thanks in adv

Re: Pivot heading format

prat1507 — Wed, 21 Jun 2017 06:15:45 GMT

Yes you can change the background color using this:

Re: Pivot heading format

Wed, 21 Jun 2017 06:22:40 GMT

Thanks,

I did not know this option. Moreover I have concat 2 formulas ( WeekDay(ReportDate) & ' - '& Day(ReportDate)). It looks now Mon-12. I want to wrap this like following ouput. Do we have any option for this?

Mon

I tried '\n' but doesn't works.

Thanks again

Re: Pivot heading format

prat1507 — Wed, 21 Jun 2017 06:26:55 GMT

Yes Narendra. You can use it as WeekDay(ReportDate) & chr(13)& Day(ReportDate)

Regards

Pratyush

Re: Pivot heading format

Wed, 21 Jun 2017 07:29:46 GMT

Thank you Pratyush... very helpful!!