Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have a table from external database and I need to write a correct script. Script should be summing MAUC value in max dates.
Table is now:
I need FINAL table in which will be:
1. only max date updating
2. sum of MAUC according to different component
Could you help me, how can I do this ?
HI, if you do an inner join with
Inner Join (DataTable)
MAX(DATE UPDATING) as DATE UPDATING
Group by STORE,ITEM;
That keeps only the rows you want.
You can do another group by of that data to crate the sum or leva as it is so also have the value of each component.
Instead of an Inner Join you can also do a left join to add a flag (just add a field like "1 as flagLastUpdate"), and use this flag in set analysis to filter las update data by store and item.
This way you keep all data and can easily do calcualtions for last update.
View solution in original post