topic Re: Distinct in Expression in QlikView

Distinct in Expression

Mon, 10 Feb 2014 05:41:40 GMT

I am using the following Expression :

SUM(if(len( [Territory Name])> 0,if(len(KeepChar([Territory Name],'0123456789')) > 0,KeepChar([Territory Name],'0123456789'),1)))

How do I add Distinct [Territory Name] in this expression ?

Thanks

VENU

Re: Distinct in Expression

Mon, 10 Feb 2014 05:44:29 GMT

try this

SUM(Distinct if(len( [Territory Name])> 0,if(len(KeepChar([Territory Name],'0123456789')) > 0,KeepChar([Territory Name],'0123456789'),1)))

Re: Distinct in Expression

Mon, 10 Feb 2014 05:46:57 GMT

try this

SUM(if(len(Sum(distinct [Territory Name]))> 0,if(len(KeepChar(Sum(distinct [Territory Name]),'0123456789')) > 0,KeepChar(Sum(distinct [Territory Name]),'0123456789'),1)))