Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot table Expression

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

1 Reply
tyagishaila
Specialist
Specialist

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