How to show last Yr and last month...in set analysis

[mohammadkhatimi]

Hi Everyone,

How to show last Fiscal Month of Last Fiscal year.

For e.g- Fiscal year-2015-2016 Apr Month is selected....the data should show March of Fiscal Year 2014-15.

Any help would highly appreciate.......................

Regards,

Mohammad

[hariprasadqv]

Hi,

The below link may help you.

http://www.analyticsvidhya.com/blog/2014/01/set-analysis-qlikview/

[buzzy996]

try these,

Last year:

=num(sum({$<Year = {$(=only(Year) - 1)}, Month = {"<=$(=max(Month))"}>} LineSalesAmount), '$#,##0;($#,##0)')

Last Month:

sum({$<Year = {$(=only(Year) - $(=if(only(Month) = 1, 1, 0)))}, Month = {$(=month(addmonths(MonthYear, -1)))}>} LineSalesAmount)

[#4]

hi,

for YTD  =>variable   MaxDate=max(DATE)

Sum({$<FinYear=,FinMonth=>}InYearToDate(DATE,'$(MaxDate)',0,4) * -1 *(([Amount])))

LYTD

Sum({$<FinYear=,FinMonth=>}InYearToDate(DATE,'$(MaxDate)',-1,4) * -1 *(([Amount])))

MTD

Sum({$<FinYear=,FinMonth=>}InMonthToDate(DATE,'$(MaxDate)',0,4) * -1 *(([Amount])))

LMTD

Sum({$<FinYear=,FinMonth=>}InMonthToDate(DATE,'$(MaxDate)',-1,4) * -1 *(([Amount])))

Regards

Vimlesh

[mohammadkhatimi]

Hi Shiva,

I want last yr and last month in one expression

[buzzy996]

u mean 2014 dec?

[#7]

Hi,

Look at this app.

Regards

Vimlesh

[mohammadkhatimi]

no i want fiscal yr

For e.g- Fiscal year-2015-2016 Apr Month is selected....the data should show March of Fiscal Year 2014-15.

[mohammadkhatimi]

Wher is the app...

please attached

[#10]

hi,