topic Re: Issue in Pivot table in QlikView

Issue in Pivot table

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

Hi Community,

I am facing problem in P&L reports.

I have P&L format like bold and Empty lines.

This is my report format...

This format working fine in Straight table..

But, i want to do PIVOT table, i have 2 dimension Descr and Division.

Division i want to move up in Pivot table.

PFA,

Thanks in Advance....

sunny_talwar — Wed, 13 Jul 2016 02:00:20 GMT

What exactly is the issue you are facing Paul?

paulwalker — Wed, 13 Jul 2016 02:05:53 GMT

Hi Sunny,

I am not able to get that format in pivot table..

See here it's missing rows 4,5 and 8.

4th column should be- Total cost= 1500+1230+350= 3080

8th column = TotalDCost= 6500+8400= 14900

These 2 rows it should be BOLD

and 5th Row Empty Row

sunny_talwar — Wed, 13 Jul 2016 02:09:47 GMT

May be this:

IF(Null_1=1,Null(),

if(SNO=4, RangeSum(Above(TOTAL column(1),1,3)),

if(SNO=8, RangeSum(Above(TOTAL column(1),1,2)),

Sum(Cost))))

paulwalker — Wed, 13 Jul 2016 02:20:36 GMT

Yes, My problem was if i take one more Dimension. I am not getting that format.

See here..

Report format complete changed and one more null column appearing.

How to get rid of empty column... and 4 and 8 rows BOLD.

paulwalker — Wed, 13 Jul 2016 04:09:01 GMT

If anyone have Idea... Please let me know..

Clever_Anjos — Wed, 13 Jul 2016 05:05:20 GMT

This?

Clever_Anjos — Wed, 13 Jul 2016 05:06:25 GMT

PFA