Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

How to merge cell borders in one column in pivot table

Hi All,

here I need to create a pivot table like bellow

pivote_table.jpg

I can place a text object but I need to know is there any solution to get an empty column, please suggest.

Thanks in advance

 

Labels (1)
1 Solution

Accepted Solutions
Highlighted
Partner
Partner

I can get this:

MC.PNG

Select Design Grid on the top panel.

Then right click on the table dimension that you want to perform formatting and select "Custom format cell".

You will see dropdown selection for Border before cell and Border after cell.

Select the first option for both.

Thanks and regards,

Arthur Fong 

View solution in original post

4 Replies
Highlighted
Creator II
Creator II

Hello,

Try this

https://community.qlik.com/t5/New-to-Qlik-Sense/Pivot-Table-Column-value-differs-in-Qlik-sense/td-p/...

+55(44) 9 9993-3605, WhatsApp
E-Mail or Skype - danilo16stochi@hotmail.com
Highlighted
Digital Support
Digital Support

Did the post you received help you with your use case?  I know it was for Sense Help, not QlikView, so I wanted to be sure to see if that did help or not.  If so, be sure to use the Accept as Solution button to mark the post to give credit for the help and to let other Community Members know that helped you with the use case.  If you are still working on things, I think we need some further clarification, as I am a little confused about exactly what you wanted help solving, the subject says one thing, but your description does not seem to coincide very well, so just wanted to be sure what the request really was on this one.  I think that will likely help you get some further posts if you need them.

I will take a stab at things, one thing might be to use a Calculated Dimension that results in your empty column with just dimension name:

https://community.qlik.com/t5/Qlik-Design-Blog/Calculated-Dimensions/ba-p/1472813

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
Highlighted
Creator II
Creator II

Hi BrettBleess,

thanks for reply,

here i want to remove cell borders for entire column like above image which i placed, so its design based requirement.

thanks,

 

Highlighted
Partner
Partner

I can get this:

MC.PNG

Select Design Grid on the top panel.

Then right click on the table dimension that you want to perform formatting and select "Custom format cell".

You will see dropdown selection for Border before cell and Border after cell.

Select the first option for both.

Thanks and regards,

Arthur Fong 

View solution in original post