topic Re: Month comparision in QlikView

Month comparision

Qlik__Vinodh — Sat, 05 Jan 2013 08:10:57 GMT

Dear all,

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

Re: Month comparision

Sat, 05 Jan 2013 08:46:03 GMT

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.

Re: Month comparision

nirav_bhimani — Sat, 05 Jan 2013 08:56:58 GMT

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

Re: Month comparision

CELAMBARASAN — Sat, 05 Jan 2013 13:41:42 GMT

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.