topic Line Graph - Selected Month and Previous 2 Months in QlikView

Line Graph - Selected Month and Previous 2 Months

dmohanty — Tue, 14 Apr 2015 23:32:19 GMT

Hi All,

I have to show the Last 3 Months Sales data in a Line Graph. The functionality should be like this - If any Month is selected from the List Box, the graph should show - Sales for selected month and its previous 2 months.

Ex: If I select Dec-14, the graph would Sales for Dec-14, Nov-14 and Oct-14

When nothing is selected, it would show the Latest Month (Feb-15) and previous 2 months (Jan-15, Dec-14).

Could some please help with a demo. Here is the data:

Month	Sales
Mar-14	100
Apr-14	150
May-14	120
Jun-14	240
Jul-14	80
Aug-14	180
Sep-14	110
Oct-14	230
Nov-14	330
Dec-14	190
Jan-15	250
Feb-15	280

Re: Line Graph - Selected Month and Previous 2 Months

dmohanty — Wed, 15 Apr 2015 00:25:37 GMT

Any help here please?

Re: Line Graph - Selected Month and Previous 2 Months

danieloberbilli — Wed, 15 Apr 2015 01:25:16 GMT

Please find an example attached.

You should have a master calendar where you can have a consecutive number for your month so that you can easily calculate max(month_number)-1 , -2 ...and so on

Re: Line Graph - Selected Month and Previous 2 Months

ramoncova06 — Wed, 15 Apr 2015 02:06:41 GMT

is your month a string format ? or a date formatted to as 'MMM-YY' if it is a date format you could use the following expression

sum({<Month = {">=$(=(max(Month,3)))<=$(=(max(Month)))"}}Sales)

Re: Line Graph - Selected Month and Previous 2 Months

jagan — Wed, 15 Apr 2015 02:31:52 GMT

Hi,

Try like this

Script:

LOAD

Date(Date#(Month, 'MMM-YY')) AS Date

FROM DataSource;

Now in chart try like this

Dimension: Month

Expression: Sum({<Month=, Date={'>=$(=MonthStart(Max(Date), -2))<=$(=Date(Max(Date)))'}>} Sales)

Hope this helps you.

Regards,

Jagan.