Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
alis2063
Creator III
Creator III

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

Hi

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.

1 Solution

Accepted Solutions
alis2063
Creator III
Creator III
Author

Thanks for your help

I have done from custom cell properties

View solution in original post

7 Replies
Anil_Babu_Samineni

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
alis2063
Creator III
Creator III
Author

is there not another way to achieve?

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

Anil_Babu_Samineni

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
alis2063
Creator III
Creator III
Author

Hi Anil,

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

Anil_Babu_Samineni

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
alis2063
Creator III
Creator III
Author

Thanks for your help

I have done from custom cell properties

Anil_Babu_Samineni

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful