topic Re: How to display current,previous,next month without any selection...!! in QlikView

How to display current,previous,next month without any selection...!!

Mon, 17 Nov 2014 09:47:11 GMT

I want to display current month,previous month,next month and Previous to previous Month.

Eg: SEPT(Previous to Previous)

OCT(Previous Month)

NOV(Current Month)

DEC(Next Month)

Note:Without any Selection,I want the following requirement to display on my chart.

ychaitanya — Mon, 17 Nov 2014 09:57:39 GMT

Try This

Sum({<OrderDate = {">=$(=MonthStart(Today(),-2))<=$(=MonthStart(Today(),+1))"}>}Sales)

Thanks

Chaitanya

MK_QSL — Mon, 17 Nov 2014 10:02:31 GMT

Current Month

=Month(Today())

Previous Month

=Month(AddMonths(Today(),-1))

Previous to Previous Month

=Month(AddMonths(Today(),-2))

Next Month

=Month(AddMonths(Today(),1))

Mon, 17 Nov 2014 10:09:36 GMT

not Working

annafuksa1 — Mon, 17 Nov 2014 11:17:52 GMT

Can you post you app ?

please try

Sum({<{$<Month = {$(=Max(Month)-1)}>}>}Sales) for previous month

Anna

goncalo_ricardo_pereira — Mon, 17 Nov 2014 12:29:40 GMT

Hello,

You can try this expressions:

Current Month

sum({$<Month = {"$(=Month(Today()))"}, Year = {"$(=Year(Today()))"}>} Sales)

Previous Month

sum({$<Month = {"$(=Month(AddMonths(Today(),-1)))"}, Year = {"$(=Year(AddMonths(Today(),-1)))"}>} Sales)

Previous to Previous Month

Sum({$<Month = {"$(=Month(AddMonths(Today(),-2)))"}, Year = {"$(=Year(AddMonths(Today(),-2)))"}>} Sales)

Next Month

sum({$<Month = {"$(=Month(AddMonths(Today(),1)))"}, Year = {"$(=Year(AddMonths(Today(),1)))"}>} Sales)

Hope it helps.