topic Re: sum distinct in set analysis expression in QlikView

sum distinct in set analysis expression

geogou1973 — Wed, 19 Mar 2014 10:45:06 GMT

Hello.

Can anyone tell me how can i express in set analysis "sum distinct".

How can i put the command distinct or how can i have distinct results of sum sales in the below expression.

sum( {<DATE={ '$(=vdate)' } > }sales)

Thank you in advance.

MK_QSL — Wed, 19 Mar 2014 10:48:06 GMT

sum( {<DATE={ '$(=vdate)' } > }Distinct sales)

if vdate is variable

sum( {<DATE={ '$(vdate)' } > }Distinct sales)

senpradip007 — Wed, 19 Mar 2014 10:49:54 GMT

try this
sum( {<DATE={ '$(=vdate)' } > } Distinct sales)