Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
seWork
Contributor III
Contributor III

How to use straight table expression in aggr expression ?

Hi all,

 

I have a straight table that contains a Group dimension and the following expression

pick(match('A','B','C','D'),

sum(aggr(sum(XYZ),Item,Group))*vA ,

sum(aggr(sum(XYZ),Item,Group))*vB ,

sum(aggr(sum(XYZ),Item,Group))*vC,

sum(aggr(sum(XYZ),Item,Group))*vD) 

 

This expression returns the expect result

 

I'm trying to have another expression that will look like

 

sum(aggr(Vol*

pick(match('A','B','C','D'),

sum(aggr(sum(XYZ),Item,Group))*vA ,

sum(aggr(sum(XYZ),Item,Group))*vB ,

sum(aggr(sum(XYZ),Item,Group))*vC,

sum(aggr(sum(XYZ),Item,Group))*vD) 

 ,Item,Group))

 

But this expression returning 0 for all records

 

any suggestions?

 

0 Replies