topic Re: Max Value in QlikView

Max Value

Thu, 13 Aug 2015 13:10:31 GMT

Hi Community,

How to get Max value for 2 parametres.

Ex:

I want Count of X value with two parametres

EX: Count(Max(CurrentMonth, CurrentYear)X)

Thu, 13 Aug 2015 13:13:16 GMT

Hi,

Try like below,

Count({<CurrentMonth={"$(=Max(CurrentMonth)"}, CurrentYear={"$(=Max(CurrentYear)"}>}X)

sunny_talwar — Thu, 13 Aug 2015 13:13:44 GMT

Not really sure I understand your requirement, but may be this:

FirstSortedValue(X, -CurrentYear&CurrentMonth)

MK_QSL — Thu, 13 Aug 2015 13:27:14 GMT

=COUNT({<Year = {'$(=Max(Year))'},Month = {"$(=Month(MakeDate(Year(Today()),Max({<Year = {'$(=Max(Year))'}>}Month))))"}>}X)