expression

master_student — Tue, 10 Oct 2017 09:48:34 GMT

Hello Guys,

This expression give me the value of the selectes month and year

=(num(sum( {$<[Year of date]={$(=Max([Year of date]))}>} recharge_amount),'# ##0')- num(sum( {$<[Year of date]={$(=Max([Year of date])-1)}>} recharge_amount),'# ##0')) / num(sum( {$<[Year of date]={$(=Max([Year of date])-1)}>} recharge_amount),'# ##0') *100

I need the expression that give me the value of the selected year and the month -1( in this case august)

the filed month is [Month of date]

Thank you

Re: expression

sunny_talwar — Tue, 10 Oct 2017 09:57:31 GMT

May be like this

Create a new field in the script like this

LOAD [Year of date],

[Month of date],

Date(Date#([Month of date] & ' - ' & [Year of date], 'MMMM - YYYY'), 'MMM-YYYY') as MonthYear

...

FROM ....;

and then this:

=(Sum({$<[Year of date], [Month of date], MonthYear = {"$(=Date(AddMonths(Max(MonthYear), -1), 'MMM-YYYY'))"}>} recharge_amount) - Sum({$<[Year of date], [Month of date], MonthYear = {"$(=Date(AddMonths(Max(MonthYear), -13), 'MMM-YYYY'))"}>} recharge_amount)) / Sum( {$<[Year of date], [Month of date], MonthYear = {"$(=Date(AddMonths(Max(MonthYear), -13), 'MMM-YYYY'))"}>} recharge_amount) * 100

topic expression in QlikView

expression

Re: expression