Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
madmax88
Creator II
Creator II

IF Year from Data A = Year from Data B, then sum

I have 2 Data Connection which I dont want to connect by date. 

Connection A:
Year_A
Sales
Customer_ID

Connection B:
Year_B
Income
Customer_ID

I need the Sum of Income in a chart where Year_A is the dimension. The year of A and B are the same, but I can't connect them. Is there an expression?

1 Solution

Accepted Solutions
sunny_talwar

If you data is connected using Customer_ID.... What does Sum(Income) give you? If that is not right, then may be you need Sum(If(Year_A = Year_B, Income))

View solution in original post

1 Reply
sunny_talwar

If you data is connected using Customer_ID.... What does Sum(Income) give you? If that is not right, then may be you need Sum(If(Year_A = Year_B, Income))