get current month vs previous month

[arulsettu]

hi

i am trying to show current month vs previous month in bar chart

what i did is

sum({<FiscalPeriod={$(=max(FiscalPeriod)),$(=max(FiscalPeriod)-1)}>}Customer)

it shows maximum month and previous month

how can i show current vs previous month any help?

[sushil353]

Try this:

sum({<FiscalPeriod={"<=$(=max(FiscalPeriod)) >=$(=max(FiscalPeriod)-1)"}>}Customer)

[arulsettu]

hi

it showing the same

[sushil353]

what are the values in your FiscalPeriod..

Can u post a sample data

[#5]

I think , you can get the current month and then compare.

like something below:

sum({<FiscalPeriod={"<=$(=Month(date(today()))) >=$(=Month(date(today()))-1)"}>}Customer)

if format is different ,change the format of month accordingly.

Regards,

Raksha

[arulsettu]

months

1 2 3 4 5 6 7 8 9 10 11 12

[anbu1984]

Can you post sample qvw

[senpradip007]

Try like

Sum({<FiscalPeriod={">=$(=MonthStart(AddMonths(Max(FiscalPeriod),-1))) <=$(=Max(FiscalPeriod))"} >} Customer)

[arulsettu]

it shows every month

[arulsettu]

here