Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

afuchten
Valued Contributor

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

Tags (1)
Community Browser