topic Re: count expression in QlikView

count expression

Mon, 28 Apr 2014 08:17:45 GMT

Dear All,

I have to write an expression to find the count of those customer which have (NET Balance - Credit amount) = 0

its_anandrjs — Mon, 28 Apr 2014 08:20:23 GMT

New Update please check now

Write Expression like

=Count(if( (([NET Balance]) - ([Credit Amount])) = 0, Customer ))

lironbaram — Mon, 28 Apr 2014 08:31:07 GMT

if the net balance and credit amount are calculated for each customer with sum function then use

sum(aggr(if(sum([Net Balance])-sum([Credit Amount])=0,1,0),Customer))

MK_QSL — Mon, 28 Apr 2014 08:33:06 GMT

=Count(DISTINCT {<Customer = {"=SUM([NET Balance])-SUM([Credit Amount])>0"}>}Customer)

Update : Sorry, I misread your question...

=Count(DISTINCT {<Customer = {"=SUM([NET Balance])-SUM([Credit Amount])=0"}>}Customer)