Month comparision

[Qlik__Vinodh]

Dear all,

i need the Month comparision and Growth value chart please help me out.

[#2]

Hi,

For comparing two months (say current month and last month), you can do something like this:

A) Define Two Variables:

1. vCurrentMonth

=Month(Today())

2. vPreviousMonth

=Month(Today()-31)

B) Use The following expression in your chart

sum({<Month={'$(vPreviousMonth)'}>}Value)

sum({<Month={'$(vCurrentMonth)'}>}Value)

For the growth value chart, you can probably try using a Line Chart or a Combo Chart. Use the dimension you want to check the growth against in this chart with the value you are analyzing. For example, this could be something like sum(Profits) in the expression against the Month or Year dimension used in a line chart sorted by Y value Ascending.

Hope that helps.

Regards,

-Khaled.

[nirav_bhimani]

Hi,

Try this,

For Current Month Sales:

=sum({<CalendarYear={$(=max(CalendarYear))},CalendarMonthName={$(=Month(Max(OrdDate)))}>} Sales)

For Last Month Sales:

=sum({<CalendarYear={$(=max(CalendarYear))},CalendarMonthName={$(=month(addmonths((max(OrdDate)),-1)))}>}Sales)

Regards,

Nirav Bhimani

[CELAMBARASAN]

Have a look at alternate states which is a new feature available in Qlikview 11.

You can use two different listboxes and check the comparison for the months selected in two list boxes.