topic Re: Need to remove the Red highlighted Header dimention from the Pivot table in QlikView

Need to remove the Red highlighted Header dimention from the Pivot table

alis2063 — Sat, 14 Oct 2017 07:47:26 GMT

I have Pivot table, where we need to remove highlighted dimension name with column.

Demo is the file where we need to remove

Result is the file of expected result which look to be same.

Anil_Babu_Samineni — Sat, 14 Oct 2017 08:06:18 GMT

You can use Label as "Space( )" and then decrease the width of that cell.

alis2063 — Sat, 14 Oct 2017 08:09:58 GMT

is there not another way to achieve?

As i have seen in blog that it is take place by default .

Anil_Babu_Samineni — Sat, 14 Oct 2017 08:11:31 GMT

No way as of now, May be Qlik need to work on it either this is facing since 2001.

alis2063 — Sat, 14 Oct 2017 08:21:31 GMT

Hi Anil,

Can you please assist me to bold the second dimension i.e Jan 2017,Feb 2017

Anil_Babu_Samineni — Sat, 14 Oct 2017 09:01:56 GMT

You can use Text format for InvMonthYear as ='<B>'

alis2063 — Sat, 14 Oct 2017 09:20:24 GMT

Thanks for your help

I have done from custom cell properties

Anil_Babu_Samineni — Sun, 15 Oct 2017 02:48:01 GMT

Are you sure, Custom format option triggers for you, I don't believe.. Can you share image the new one