Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Re: Set Analysis Max Year, Month

the 2 fields are YEAR and MONTH in capitals. They're both integer and numeric and when used in =max() function they give me the result i want.

I've pasted the MONTH field with no change.

The result i;m getting is 0, not '-'

A set analysis using only max(YEAR) brings me results while an expression with only max(MONTH) brings me 0.

Re: Set Analysis Max Year, Month

Hi,

Can tell us

what value MONTH field contain?

and

What is output of =max(MONTH) in text box?

for Month field try like

=Month(max(MONTH))

or

=MonthName(max(MONTH))

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Not applicable

Re: Set Analysis Max Year, Month

create an extra field in your script as

num(Month(Yourdatefield)) as Month#,

and reload the application and write your expression as

sum({$<YEAR = {$(=max(YEAR))}, Month# = {$(=max(Month#))}>} Stock_Value_CY)

hope it will work

View solution in original post

Not applicable

Re: Set Analysis Max Year, Month

Thank you all for taking the time to respond.

Highlighted
admin1
New Contributor III

Re: Set Analysis Max Year, Month

Thank you for this.. I've been spending hours for the answer to my problem.