topic Aggregate % for year when drill up in QlikView

Aggregate % for year when drill up

Sat, 13 Dec 2014 07:25:58 GMT

Hello,

Find attached, when i drill down i get 100% and when i drill p i get 1200% how do i aggregate 1200% to 100% on yearly bases as that of month. How do i do this?

Rgds

Re: Aggregate % for year when drill up

MK_QSL — Sat, 13 Dec 2014 08:00:29 GMT

Change expressions as below

Actual

Sum({<Description={'Pipeline Availabilty %'}>} Actual)/Sum(TOTAL {<Description={'Pipeline Availabilty %'}>} Actual)

Target

Sum({<Description={'Pipeline Availabilty %'}>} Target)/Sum(TOTAL {<Description={'Pipeline Availabilty %'}>} Target)

Actual

Sum({<Description={'Pipeline Availabilty %'}>} Actual)/Sum(TOTALActual)

Target

Sum({<Description={'Pipeline Availabilty %'}>} Target)/Sum(TOTAL Target)

Re: Aggregate % for year when drill up

Sat, 13 Dec 2014 13:07:21 GMT

Hello

This didn't work out