topic Re: Max value in alternate state field in QlikView

Max value in alternate state field

Thu, 30 Oct 2014 12:05:55 GMT

Hello!!!

What is the syntax to find the maximum value of a alternate state field?

This is my original expression: Sum({<ID_ROLLING={$(=Max(ID_ROLLING))},YEAR=[Group PL 1]::YEAR, MONTH_SHORT_NAME=[Group PL 1]::MONTH_SHORT_NAME>}VALUE)

But now I just need those whose [Group PL 1]::year is the maximum value. Something like this wrong expression: Sum({<ID_ROLLING={$(=Max(ID_ROLLING))},YEAR=[Group PL 1]::max(YEAR), MONTH_SHORT_NAME=[Group PL 1]::MONTH_SHORT_NAME>}VALUE)

Regards.

Re: Max value in alternate state field

Thu, 30 Oct 2014 12:07:20 GMT

Hi,

Syntax is

Max({Platform1}(InputDate))

here Platform1 is the alternatestate name.

Re: Max value in alternate state field

Thu, 30 Oct 2014 12:21:06 GMT

Shruthi, thanks for your answer. But I need to set it as a condition of the function. My function is sum (not max), but a condition of the sum function is that the year value is the maximum.

I'll try to explain better, this is my original function: Sum({<ID_ROLLING={$(=Max(ID_ROLLING))},YEAR={$(=Max(YEAR))}, MONTH_SHORT_NAME=[Group PL 1]::MONTH_SHORT_NAME>}VALUE)

I need the same function, but the condition of the maximum year must be for a specific alternate state, in this case : [Group PL 1] is the alternate state name.

Re: Max value in alternate state field

Thu, 30 Oct 2014 13:08:50 GMT

Hi,

I hope this works.

Sum({<ID_ROLLING={$(=Max(ID_ROLLING))},YEAR={$(=Max({[Group PL 1]}YEAR))}, MONTH_SHORT_NAME=[Group PL 1]::MONTH_SHORT_NAME>}VALUE)

Re: Max value in alternate state field

Thu, 30 Oct 2014 14:55:43 GMT

Thank you very much Shruthi Reddy it works!!

Regards