Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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)