Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Employee
Employee

Re: Customize Partial Sum...

Israr ,  do you have a mapping table that defines which account code converts negative to positive and which one disregards negatives ?

You could add a field called 'converter' to that mapping table that is either  0 (disregard negatives)  ,  -1 (convert negatives) , and 1 (leave as is)

Your expression would be

sum  (   Value * converter)

->  any records associated to a code that is 0 get a 0 value in details and sums

-> any records associated to a code that is -1 get a positive value  in details and sums

-> any records associated to a code of 1 get no change at all

Would this work ?