topic Re: Qlik View - Formating Partial Sums in Pivot Table in QlikView

Qlik View - Formating Partial Sums in Pivot Table

Jthurston — Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: Qlik View - Formating Partial Sums in Pivot Table

Brett_Bleess — Mon, 22 Jul 2019 21:47:10 GMT

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