topic Set analysis with Max(Month) in QlikView

Set analysis with Max(Month)

helen_pip — Tue, 29 Apr 2014 08:58:38 GMT

Hello

I am using a master calender with my entire dataset, but want to show just the max(MonthYear) for just one particulare data set

I have tried a variation using set analysis, but have not quite got the code right yet, could someone kindly help me with the correct code

{<data_source={'18_Wks_Admitted'}>}Max(MonthYear),'MMM YYYY')

Kind Regards

Helen

helen_pip — Tue, 29 Apr 2014 09:09:35 GMT

Hello

Problem solved

Max({<data_source={'18_Weeks_Admitted'}>}MonthYear)

Tue, 29 Apr 2014 09:11:50 GMT

Like this

=Sum({<MonthYear={$(=Max(MonthYear))}>}Sales)

Hope it helps you..!