Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner
Partner

Help in set analysis (max date for each project)

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

community.PNG

I can walk on water when it freezes
1 Solution

Accepted Solutions
mdmukramali
Specialist III
Specialist III

Dear,

 

Can you try to use FirstSortedValue.

Expression:

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

View solution in original post

3 Replies
mdmukramali
Specialist III
Specialist III

Dear,

 

Can you try to use FirstSortedValue.

Expression:

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

View solution in original post

ali_hijazi
Partner
Partner
Author

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

I can walk on water when it freezes
ali_hijazi
Partner
Partner
Author

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-o...

 

I can walk on water when it freezes