Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
snarrp_Rocky
Contributor III
Contributor III

Expression. Need Help

ScenarioDateIDPortfolioTotal
20160701A AUD OPT AU-                  337,065
20160701A CAD OPT AU-                         229
20160701A CPI OPT AU-                   17,770
20160701A CPI OPT2 AU                   13,322
20160701 Total -                  341,742
20160704A AUD OPT AU               1,238,323
20160704A CAD OPT AU                          33
20160704A CPI OPT AU                  378,288
20160704A CPI OPT2 AU-                   98,216
20160704 Total                1,518,428
20160705A AUD OPT AU-                  130,404
20160705A CAD OPT AU                     1,625
20160705A CPI OPT AU                   56,491
20160705A CPI OPT2 AU-                  150,693
20160705 Total -                  222,981
20160706A AUD OPT AU-                  529,386
20160706A CAD OPT AU                     1,113
20160706A CPI OPT AU-                     4,093
20160706A CPI OPT2 AU                   14,396
20160706 Total -                  517,970

 

I have 4 dates, and each date has 4 portfolios, I need to total them by each date and out of that 4 dates total, I need to get 2nd lowest which is 341,712.

Kindly Help.

Labels (1)
1 Reply
sunny_talwar

May be this

Min(Aggr(Sum(Value), ScenarioDateID), 2)