Collpase View and Expanded View - Total Problem / Values not same

kiranpatil123 — Mon, 01 Jul 2019 07:07:41 GMT

Hi ALl ,

i Have CollpaseExpanded

I have above collapse and Expanded view of Pivot table

In Expanded View , Cumulative Reduction achieved YTD = (Baseline Count - 2019 June) / BaseLine Count

The values are coming fine for each Business Unit wise but when you see total its wrong , it should be (50-75)/50 = -50% but its showing -57%

Also when collapsed View , values are not correct.

I tried Aggr by dimesion but its not working . Please help

Re: Collpase View and Expanded View - Total Problem / Values not same

Brett_Bleess — Tue, 09 Jul 2019 20:43:27 GMT

Have a look at the following link, I think it might help, but I am not sure. By the way, you posted to the Education Forum, you really want to be posting on the correct Product Forum, I was going to move this for you, but I was not sure if you were talking about Qlik Sense or QlikView in this case. The Help link is QlikView, but I believe it is applicable to QlikSense as well, but I may be wrong. Pretty sure you were on the right track, just guessing you had something slightly off, so hopefully the link will help:

http://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/ChartFunctions/NestedAggregations/sum-of-rows-pivot-tables.htm

Regards,
Brett

topic Re: Collpase View and Expanded View - Total Problem / Values not same in QlikView

Collpase View and Expanded View - Total Problem / Values not same

Re: Collpase View and Expanded View - Total Problem / Values not same