13 Month Trends and Current Mon vs. Previous Month Calculations

[dmohanty]

Hi All,

Could some one please help in providing the below logic in a sample QVW:

1. Last 13 month trends, based on a particular month selected, backward 13 months from that selected month 
2. Current Month vs Previous Month calculations

Regards!

[ali_hijazi]

Suppose your expression is Sum(Sales) and suppose your SAles Date in the transactions is Date

then for previous month:

sum({< Year=,Month=,Date={"$(=num(DayStart(Addmonths(Date(max(Date)),-1))))"}>}Sales)

Last 13 Months

sum({< Year=,Month=,Date={">=$(=num(DayStart(AddYears(Date(max(Date)),-1))))"}>}Sales)

these num(dayStart are needed in case your dates values are numbers(QlikView format)

[dmohanty]

Hi Ali,

Thank you for the help.

Could you please show this in a sample QVW please?

[ali_hijazi]

give me a sample data and I will write the expressions for you

sorry I don't have sample data from my side

[dmohanty]

Hi Ali,

Attached is the sample set of data. Please help me with a sample QVW

[dmohanty]

Hi All,

Any help on this request please?

Regards,

Dicky Mohanty

[ali_hijazi]

Check attached document

elaborate more if this is not what you exactly want

sorry for the late reply

[dmohanty]

Hi Ali,

Thank you for the help.

Can it be shown in some graphical way, may be line chart or something else?

Alos, how the Current Month vs. Previous Month calculations can be displayed?

[ali_hijazi · Accepted solution]

check attached document

[ali_hijazi]

check attached document