Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
chaiwaykeat
Contributor II
Contributor II

Expression to find out Distinct value

Hi All,

I am trying to pull the value from [Backlog_Actual (2).backlogamt] given that  to [Backlog_Actual (2).SO] is equal to [Sales Order] in the below expression:

sum ( if ([Backlog_Actual (2).SO]= [Sales Order],[Backlog_Actual (2).backlogamt]))

But by doing this I have duplicated value pulled from [Backlog_Actual (2).backlogamt] as my [Sales Order] contains duplicate values.

How can I avoid pulling the duplicated values ?

Thanks !

2 Replies
tresesco
MVP
MVP

Try like:

sum (Distinct  if ([Backlog_Actual (2).SO]= [Sales Order],[Backlog_Actual (2).backlogamt]))

chaiwaykeat
Contributor II
Contributor II
Author

by adding distinct the expression only pull out distinct value for [Backlog_Actual (2).backlogamt]

I will need distinct value for [Sales Order] when comparing it with [Backlog_Actual (2).SO]