Discussion Board for collaboration related to QlikView App Development.
I am using a table like this
Expression for PaidAmt is
issue is the type column is also an expression field i.e =if(sum(receive_amt) = 0,'Unpaid','Paid');
now I want to show above table in pie chart to show the count of customer who paid/unpaid, something as in attached file
I think you can use column "Type" as dimension and use Count(distinct VoucherID) as expression.
Then you can make it.
Qlik will not accept having an expression like this that is a so-called nested aggregation:
Count( Sum(PaidAmt)=0 )
but you are allowed to nest aggregations if the inner aggregation has a TOTAL quaifier:
Count( Sum(TOTAL PaidAmt)=0 )
However you need Aggr() to create the two dimension values in a calcuated dimension:
Create the bar chart and press the "calculated dimension" on the Dimension tab to create the unpaid/paid values:
=Aggr( If(Sum(PaidAmt)=0,'unpaid','paid') , Customer )
if the paid status should be calculated not just per Customer but per VoucherID, VhrDate and Customer then:
=Aggr( If(Sum(PaidAmt)=0,'unpaid','paid') , VoucherID, VhrDate, Customer )
Then add the expression
=Count(Sum(TOTAL PaidAmt) = 0)