topic Re: month and previous month? in QlikView

month and previous month?

Anonymous — Tue, 14 Oct 2014 14:31:42 GMT

i have month field and sales

i want comapre in single chart for current month sales and previous month sales ?

Re: month and previous month?

JonnyPoole — Tue, 14 Oct 2014 14:34:19 GMT

Can you tell me the format of you the data values in your month field ? Are they dates ? Month Numbers (1-12) ? Month names (Jan-Dec) ? That is the key piece to providing an expression that may work.

Re: month and previous month?

erjohnso — Tue, 14 Oct 2014 14:44:04 GMT

Set analysis using max month and max month -1. As JP stated above, would need the format before sharing any code. You might need to create a date convert crosswalk table for the calc as well.

Re: month and previous month?

Tue, 14 Oct 2014 15:05:33 GMT

Hi,

here we need to write the set analysis,we can dynamically and static also.

for dynamic we can use several ways like directly give month or create a variable and place it in set analysis syntax.

Re: month and previous month?

Anonymous — Tue, 14 Oct 2014 15:12:08 GMT

month numbers

Re: month and previous month?

JonnyPoole — Tue, 14 Oct 2014 15:20:21 GMT

Will the current month be based off Today's month or some other month ? For example, it might be the most recent month in your data .

Still a bit of guess work, but if your data field is 'Month' and it stores values as 1-12, here are your 2 expressions. Sales is the $ amount field of the Sales.

Current Month: Sum ( {$<Month = {'$(=Num(Month(Today())))'}>} Sales)

Previous Month: Sum ( {$<Month = {'$(=Num(month(AddMonths(Today(),-1))))'}>} Sales)