Pivot Dimension distribution

agni_gold — Tue, 15 Nov 2016 10:10:14 GMT

Hi Friends ,

I have one expression

((sum({$<_PFlag={'ORG'},FINANCIAL_ACCOUNT_KEY={'$(vKPI1AccountKey)'},VARIANCE_BASE_SK={$(vVariance)},ACTUALITY_SK={'AC'}>}VOL_PREV_AMENDED))/1000000

(Sum({<_PFlag={'ORG'}, ACTUALITY_SK={'AC'}, VARIANCE_BASE_SK={'AI'}, Priorities={'Harbin/Sedrin'},FINANCIAL_ACCOUNT_KEY={'$(vAcc1)'}>}VOL_PREV_AMENDED)*.59)/1000000),

First part belongs to sole other zone and second part belongs to some other zone , but when i put this expression in pivot table then there are two different rows are coming for both the part, i want to sum both value and assigned to first part zone.

Thanks

Re: Pivot Dimension distribution

sunny_talwar — Tue, 15 Nov 2016 10:36:25 GMT

Try this

If(Zone = 'First',

((sum(TOTAL {$<_PFlag={'ORG'},FINANCIAL_ACCOUNT_KEY={'$(vKPI1AccountKey)'},VARIANCE_BASE_SK={$(vVariance)},ACTUALITY_SK={'AC'}>}VOL_PREV_AMENDED))/1000000

(Sum(TOTAL {<_PFlag={'ORG'}, ACTUALITY_SK={'AC'}, VARIANCE_BASE_SK={'AI'}, Priorities={'Harbin/Sedrin'},FINANCIAL_ACCOUNT_KEY={'$(vAcc1)'}>}VOL_PREV_AMENDED)*.59)/1000000)

)

Not sure what all dimensions you have, but you might need to add field names with the TOTAL qualifier

topic Re: Pivot Dimension distribution in QlikView

Pivot Dimension distribution

Re: Pivot Dimension distribution