Problem in Partial Sum

vijayit43 — Sun, 29 Mar 2015 05:34:06 GMT

In Qlikview Three Type All,PendingDO,Collection in ListView and expression column are outstanding,Collection,PendingDO

when select All then show all data for outstanding,Collection,PendingDO,When Select Collection then Show Only those where collection qty is greater then zero.we have use this Code for Outstanding

if(Type='Collection' and SUM({<TRANSDATE ={'>=$(=Date(StartCalendarDate))<=$(=Date(StartCalendarDate))'}>}CollectionAmount)>0,

SUM({<TRANSDATE = {'>=$(=Date(StartCalendarDate))'}>}AMOUNTMST),

if(Type='All', SUM({<TRANSDATE = {'>=$(=Date(StartCalendarDate))'}>}AMOUNTMST),

if(Type='PendingDO' and SUM(PendingQuantity)>0,SUM({<TRANSDATE = {'>=$(=Date(StartCalendarDate))'}>}AMOUNTMST),0)))

Its work fine but when use show partial sum then type All Selected In Outstanding is ok but when type collection select then total sum give wrong figure(Its Show all Amount Sum) please suggest. for reference sample attached..

Re: Problem in Partial Sum

vijayit43 — Mon, 30 Mar 2015 02:01:45 GMT

Hi All,

Please suggest..

topic Re: Problem in Partial Sum in QlikView

Problem in Partial Sum

Re: Problem in Partial Sum