topic Compare current month vs previous month in QlikView

Compare current month vs previous month

Thu, 19 Nov 2009 10:18:55 GMT

Hi all,

I do have a field in where I'm stored sales info for last 2 years. The idea is to build a chart showing the current (selected month) and the previuos month.

I have not access to the database to create a new field Sales_PM (Sales previous month).

So, I wondering if there is any way to create a chart with 2 dimensions (Month & Month-1)

Thanks in advance!!!

Compare current month vs previous month

Thu, 19 Nov 2009 14:55:31 GMT

Hi Diego,

I've attached an example of something which may help you.

Thanks

Compare current month vs previous month

Thu, 19 Nov 2009 22:47:32 GMT

Hi Xena,

thanks a lot for your example.

Just another little question, because I'm not familiar with the $ behavior.

In my case I write down something like this:

Sum(Month = {$(=Month(Addmonths(MakeDate([Calendar Year], [Calendar Month Number]), -1)))>} CustProd_SaleAmtLocalCurr)

But my column stills blank. The question is if the structure of the sentence is ok.

Thanks in advance!!

Compare current month vs previous month

Wed, 02 Dec 2009 23:17:02 GMT

Is it possible to get that kind of sintax with older QV version (e.g. 7.20)?.

When I write expressions like ...

sum({$} variable)

sum( {$<Month = {"$(=Num(Month-1))"}>} amount )

QV application crashs, i.e. it is not taken into account because of a possible error?.

Any suggestion? Thanks in advance.

Compare current month vs previous month

rwunderlich — Thu, 03 Dec 2009 00:25:18 GMT

The Set Analysis syntax {} is only available in QV8 (8.5?).

-Rob