topic Re: month in QlikView

month

raadwiptec — Wed, 25 Nov 2020 16:16:04 GMT

i need to have last month only and this month only sales as 2 different columns in the same chart. I tried using add months concept..

any sugg

Chanty4u — Wed, 15 Feb 2017 10:39:29 GMT

May be this?

Current Month sales Expression: =Sum({<MonthNum={'$(=Max(MonthNum))'}>}Sales)
Previous Month sales Expression: =Sum({<MonthNum={'$(=Max(MonthNum)-1)'}>}Sales)

MayilVahanan — Wed, 15 Feb 2017 10:43:43 GMT

Try like this

Sum({<Date= {">=$(=Date(MonthStart(Today(),-1),'DD/MM/YYYY')) <= $(=Date(Floor(MonthEnd(Today())),'DD/MM/YYYY'))"}>}Sale)

raadwiptec — Wed, 15 Feb 2017 10:47:47 GMT

i tried this Sum({<[Month]={'$(=Max(Month)-1)'}>}Sales) .. but my output is 0

MayilVahanan — Wed, 15 Feb 2017 10:55:56 GMT

Try like this

=Sum({<[Month]={'$(=Month(AddMonths(Today(),-1)))'}>}Sales)

raadwiptec — Wed, 15 Feb 2017 21:32:47 GMT

hi mayhil,

it should not be based on today .. for ex: if iam selecting 02 it should show 01 and if i select month 03 it should show 02

vishsaggi — Wed, 15 Feb 2017 22:28:48 GMT

Can you share a sample app to work on?

MayilVahanan — Thu, 16 Feb 2017 05:25:38 GMT

Try like this

=Sum({<[Month]={'$(=Max(Month)-1)'}>}Sales)

Note thtat: =Max(Month)-1 wil return 11 (Number format), if your month is in number format, it will work.

Otherwise,

Try like this

=Sum({<[Month]={"$(=Month(Date#(Max(Month)-1,'MM')))"}>}Sales)

sasikanth — Thu, 16 Feb 2017 05:43:13 GMT

Try this

Current Month : Sum({< Month= {"$(=Month(AddMonths(Max(Date_Field),0)))"}>}Sales),

Previous Month: Sum({< Month= {"$(=Month(AddMonths(Max(Date_Field),-1)))"}>}Sales),

Careful with date formats