Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
geogou1973
Creator
Creator

sum distinct in set analysis expression

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.

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

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

or

if vdate is variable

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

View solution in original post

2 Replies
MK_QSL
MVP
MVP

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

or

if vdate is variable

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

senpradip007
Specialist III
Specialist III

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