Hi community!
I have a problem that I have not been able to find the correct expression for several days.
I have on one side a table of amounts data with date and a concept code, another table where the concept code has another field that can be C or D and the calendar master.
I am using a bar chart where the X dimension is the year month of the calendar master and the measure is where I have the problem, I have tried both SUF(IF..) and set analysis without achieving the goal.
Simplifying the tables..
Amount Table:
MCACustomer | MCA_YearMonth | Code | MCAValue |...
1 | 2019-Jan | 30 | 100 |...
1 | 2019-Jan | 35 | 100 |...
1 | 2019-Feb | 30 | 100 |...
1 | 2019-Feb | 40 | 100 |...
Concept Table:
Code | Type |...
30 | C |...
35 | C |...
40 | D |...
MasterCalendar:
YearMonth |...
2019-Jan |...
2019-Feb |...
Some expressions that I tried without success:
SUM({<[Code] = {'C'}, MCA_YearMonth = {'$(=Only(YearMonth))'} >} MCAValue)
SUM(IF([Code] = 'C' AND MCA_YearMonth = YearMonth,MCAValue,0))
Thanks in advance to anyone who can give me some light on this problem!
Qlik Sense Business
