Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
Hi All,
Please suggest..