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: 
Anonymous
Not applicable

Set analysis usage ... think the expression code could be better ... i'm a little stuck

I have an expression but I'm sure there must be a better way of doing this ...


= sum({$< FB= {'Eigen'}, A.ACC={'TERMINAL'}, V.DT = {'Factuur'}, Year ={$(vCurrentYear)},K.BBG = {'BINNENLAND'},K.KBG = {'KLANT'} >} if(A.PGC <> 'AVM' or (A.PGC= 'AVM' and IsNull(V.FRNr)= 0), V.Number)) +
sum({$<FB= {'Eigen'}, A.ACC={'TERMINAL'}, V.DT = {'Order'}, Year ={$(vCurrentYear)}>} V.Number)


Maybe someone can help me make this better?

Thx in advance

Anita

0 Replies