topic Re: Help in set analysis (max date for each project) in App Development

Help in set analysis (max date for each project)

ali_hijazi — Thu, 18 Nov 2021 15:56:22 GMT

Hello I got a table with one dimension (Project) each project has several dates and in each date it has a number
what i want to display is by Project the number which is for the max date for each project
so for the below:
I want to display
LLOYDS-FTP-IMPL 1077.43
SBSA-JHB-MM-EXT 162.2095

I want to use set analysis and not if statement

Re: Help in set analysis (max date for each project)

mdmukramali — Thu, 18 Nov 2021 16:27:31 GMT

Dear,

Can you try to use FirstSortedValue.

Expression:

=FirstSortedValue(aggr(Sum(RBL),[Fiscal Period End Date],ProjectName),-[Fiscal Period End Date])

Re: Help in set analysis (max date for each project)

ali_hijazi — Thu, 18 Nov 2021 16:35:49 GMT

ok this works
but now they ask me to get the sum by Month Year also
i.e. the 1077 above is the sum of RBL on several months so I want to group by month too

so each [FISCAL PERIOD END DATE] has several months
so I want to sum the RBL for each month for the last [FISCAL PERIOD END DATE] of each project
kindly advise

Re: Help in set analysis (max date for each project)

ali_hijazi — Fri, 19 Nov 2021 06:12:11 GMT

may you please help me with the following issue:
https://community.qlik.com/t5/App-Development/get-the-sum-by-project-and-month-for-the-last-period-of-each/td-p/1861136