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
Contributor
Contributor

Qlik View - Formating Partial Sums in Pivot Table

Hi All,

I am trying to format the following pivot table, the column Metric2 has 3 values, Income, Balances and Margin. I want to be able to format such that it is easy to distinguish between the three of them.

Is there anyway I can add a horizontal black line that would go all the way across my pivot table to make it easier to distinguish between Income, Balance and Margin?

Thanks!

1 Reply
Highlighted
Digital Support
Digital Support

Probably the best idea would be to use the background colors potentially, see the Help:

http://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Pivot_Table.htm

I think you want to do the Dimension background in this case, the help will guide you on what you need to do, hopefully that may do the trick.

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.