Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sum based on expression

I have an expression called Range which is equal to

if(((sum(Final_amt/sum(avg_amt))/rate)<=.80,'A', if(((sum(Final_amt)/sum(avg_amt))/rate)>.90,'B','C'))

I would like to create another summation similar to this

sum(total <Range> Members)

Is this even possible? if not what can I do to work around this.... ?

Thanks!

1 Solution

Accepted Solutions
vgutkovsky
Master II
Master II

It sounds like your "Range" should be a calculated dimension rather than an expression. Also, the syntax above for Range won't work in QV since you have nested aggregation. Try taking this to a calculated dimension (using function aggr over dimension Member probably). The expression of the chart would just be sum(Members)

Vlad

View solution in original post

1 Reply
vgutkovsky
Master II
Master II

It sounds like your "Range" should be a calculated dimension rather than an expression. Also, the syntax above for Range won't work in QV since you have nested aggregation. Try taking this to a calculated dimension (using function aggr over dimension Member probably). The expression of the chart would just be sum(Members)

Vlad