Pivot table Expression

Tue, 23 Dec 2014 11:42:49 GMT

Hi all,

The below Condition is Applying in my Pivot Table for The Expression volume ;

Correct Results are showing while Individual Selections on Dimensions.wise like material ,material Group Etc..while clearing the Selections ..the Below Condition is not Working..

if(GROUP = ('2A') and PERID < 201408 ,aggr(Sum(CONS_FKIMG), PERID, GROUP),

if(GROUP = ('3A') and PERID < 201408 ,aggr(Sum(CONS_FKIMG) , PERID, GROUP),

Sum(PLAN_FKIMG)))

CONS_FKIMG------is a key figure Which is Coming From another Data set if the above condition is Success

PLAN_FKIMG------ condition fails values populating from Pivot table source dataset...

Thnaks

Re: Pivot table Expression

tyagishaila — Tue, 23 Dec 2014 12:04:41 GMT

Can you attach you qvw file, to understand more clearly the problem which you are facing.

topic Pivot table Expression in QlikView

Pivot table Expression

Re: Pivot table Expression