topic Problem regarding Distinct function. in QlikView

Problem regarding Distinct function.

Mon, 26 Sep 2011 12:22:20 GMT

Dear All,

Distinct is a easy function to use but my problem is that

when I use it in a straight table expression inside a sum

function the total is comming smaller,because the distinct

eleminates duplicate value in to one value.But I need to show

the actual total.

How to resolve it?Please help me.I am waiting for your first respone.

Thanks & Regards,

Koushik Roy.

(GreenCube Infotech.)

its_anandrjs — Mon, 26 Sep 2011 12:33:11 GMT

Hi,

You have to sum some think like below

Sum( Distinct If( isnull( Yourfield ) = -1,1,0 ) ) + Sum( Distinct Yourfield )

try this

Let me know

HTH

Rgds

Anand

SunilChauhan — Mon, 26 Sep 2011 12:33:57 GMT

use below

RangeSum(Top(Sum(Fieldname), 1, NoOfRows()))

hope this helps