topic Re: Max year max month in QlikView

Max year max month

rajni_batra — Mon, 16 Apr 2012 07:03:10 GMT

hello m using this expression getting result for max year but max month only on selection..

i have to use it on dashboard so cant use selection there..

what should i use there tried only() also

sum({<[CAL.Fiscal Year]={$(=MaxFiscalYearGL)},[CAL.Fiscal Month]={"=$(=max([CAL.Fiscal Month Num]))"}, BSubHead = {'CURRENT ASSETS'}>}[Closing Balance])

Max year max month

jagan — Mon, 16 Apr 2012 07:08:24 GMT

Hi,

Try this expression

=sum({<[CAL.Fiscal Year]={$(=Year(Max(YourDateDimensionName))},[CAL.Fiscal Month]={"=$(=Month(max(YourDateDimensionName)))"}, BSubHead = {'CURRENT ASSETS'}>}[Closing Balance])

Hope this helps you.

Regards,

Jagan.

Re: Max year max month

adhudson — Mon, 16 Apr 2012 07:10:35 GMT

Hi,

Give a try with the below expression.

You may need to # or single quotes while using variables and expressions in set analysis.

sum({<[CAL.Fiscal Year]={'$(#=MaxFiscalYearGL)'},[CAL.Fiscal Month]={'=$(#=max([CAL.Fiscal Month Num]))'}, BSubHead = {'CURRENT ASSETS'}>}[Closing Balance])

Regards

Andrew Hudson

Re: Max year max month

rajni_batra — Mon, 16 Apr 2012 07:46:16 GMT

hi andrew...

giving the same result

Re: Max year max month

rajni_batra — Mon, 16 Apr 2012 07:47:25 GMT

Helo jagan,

actualy the problem is i have only calender date but here i need to work on fiscal terms derived fiscal month n year.

Max year max month

jagan — Mon, 16 Apr 2012 08:04:35 GMT

Hi,

Can you post some sample data or file you are working.

Regards,

Jagan.

Max year max month

CELAMBARASAN — Mon, 16 Apr 2012 09:01:21 GMT

Hi,

Try with this

sum({<[CAL.Fiscal Year]={$(=Max({1} [CAL.Fiscal Year]))},[CAL.Fiscal Month]={"=$(=max([CAL.Fiscal Month Num]))"}, BSubHead = {'CURRENT ASSETS'}>}[Closing Balance])

Celambarasan

Max year max month

rajni_batra — Mon, 16 Apr 2012 09:10:01 GMT

same output as before

Max year max month

CELAMBARASAN — Mon, 16 Apr 2012 09:16:21 GMT

Hi,

you mentioned Max month only on selection that means?If not selected what type of output you need to get?

Celambarasan

Max year max month

rajni_batra — Mon, 16 Apr 2012 09:22:48 GMT

current year current month

previous year current month

on dashboard without any selection

Max year max month

CELAMBARASAN — Mon, 16 Apr 2012 09:32:39 GMT

Hi,

What field you have used for Month and year Selection.

Celambarasan

Max year max month

CELAMBARASAN — Mon, 16 Apr 2012 09:40:48 GMT

Hi,

Its little confusing.Can you explain little more clearly about your problem?

Celambarasan

Re: Max year max month

rajni_batra — Mon, 16 Apr 2012 09:47:57 GMT

PFA.......

Re: Max year max month

CELAMBARASAN — Mon, 16 Apr 2012 09:55:38 GMT

Hi,

Sorry i'm using personal edition.I cann't open your attached QV file.

Celambarasan

Re: Max year max month

rajni_batra — Mon, 16 Apr 2012 09:58:21 GMT

cal.fiscal year for year

cal.fiscal month for month

Max year max month

jagan — Mon, 16 Apr 2012 10:13:57 GMT

Hi,

Try this expression

=sum({$<[Fiscal Year] = {$(MaxFiscalYear),$(=Max([Fiscal Year])-1)}, [Fiscal Month] = {"$(=Month(max([Link Date])))"}, BSubHead = {'CURRENT ASSETS'}>}[Closing Balance])

Let me know this is what you required.

Regards,

Jagan.

Re: Max year max month

rajni_batra — Mon, 16 Apr 2012 10:21:32 GMT

no again giving results on selection only...

Re: Max year max month

rajni_batra — Mon, 16 Apr 2012 10:24:23 GMT

but only asking for year selection not month this time ...

Max year max month

jagan — Mon, 16 Apr 2012 10:27:08 GMT

Hi Rajni,

You have no data for 2012 and 2013, that's why you are not getting the result. When no year is selected, 2012 and 2013 are considered for chart. Because of no data the chart is not having data.

Regards,

Jagan.

Max year max month

rajni_batra — Mon, 16 Apr 2012 10:46:23 GMT

Done thank u!!!!!!!!!