Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem regarding Distinct function.

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.)

2 Replies
its_anandrjs

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

TigerisBack
Champion
Champion

use below

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

hope this helps