how to compare current month sales and previous month sales?

[Akina0929]

Hi,

  I want to compare current month and previous month in bar chart.what the expression need to write please help me.

Thanking you,

[Anonymous]

Hi Anji,

Do you mean you would want to see a graph that showed sales for example, for January to December?

Thanks

[qlikview979]

Comparing two dates data

[Anil_Babu_Samineni]

you will get number of stuff if you start search on Google

Create 2 expressions

1) Sum({<MonthFieldName = {'$(=Max(MonthFieldName))'}>}Sales)

2) Sum({<MonthFieldName = {'$(=AddMonths(Max(MonthFieldName),-1))'}>}Sales)

[avinashelite]

check this document

QlikView App: Set Analysis - Prior Period Comparison

[qlikview979]

HI

Expecting like this right

[Akina0929]

No Mathew this year data only

[Anonymous]

A single expression like this the. Let's use the example that you are looking at sales.

Sum({$<yourDate={'>=$(=MonthStart(AddMonths(Max('yourDate'),-1)))'}>}Sales)

That should do the trick. Only requires one measure and will show you the latest month's sales, with the previous month's sales.