topic MonthName() Previous Month in QlikView

MonthName() Previous Month

Wed, 09 Mar 2011 11:26:13 GMT

Hello All,

I have the following data set

| MonthName | Amount | Type

| March 2011 | 100 | Settled

| Feb 2011 | 200 | Settled

| Jan 2011 | 300 | Settled

I need to work out the set analysis to work out 'Previous Month' expression, so the output is as follows:

| MonthName | Amount | Previous Month

| March 2011 | 100 | 200

| Feb 2011 | 200 | 300

| Jan 2011 | 300 |

Any help would be great!

Thanks

MonthName() Previous Month

Miguel_Angel_Baeyens — Wed, 09 Mar 2011 11:31:30 GMT

Hello,

Assuming it's a pivot table, and MonthName is the dimension, and Amount the label of the sum of amount expression,

Below([Amount])

Should return the value as you expect.

Hope that helps.

MonthName() Previous Month

Wed, 09 Mar 2011 12:49:46 GMT

Hey

Thanks for your reply,

Unfortunately it didnt work! im using set analysis on the 'Amount' Column:

AVG({$<Type = {'Settled'}>}Amount)

I have amended my first post to reflect,

Thanks

MonthName() Previous Month

Miguel_Angel_Baeyens — Wed, 09 Mar 2011 13:11:38 GMT

Hi,

The only thing you need is to label the expression, regardless the complexity of it. Clear all selections and see if that changes. You would need to use

Below(TOTAL [Amount])

To get it working.

Hope that helps.

MonthName() Previous Month

Wed, 09 Mar 2011 13:20:20 GMT

Hey,

Yes - without selections, that is now working!

But when select March '2011' - i still need to bring through the previous month (Feb 2011)

Thanks

MonthName() Previous Month

Wed, 09 Mar 2011 14:40:19 GMT

Bump - anyone?

MonthName() Previous Month

Miguel_Angel_Baeyens — Wed, 09 Mar 2011 15:07:25 GMT

Hello,

You will need to create a new field in your script that stores the previous month, since you don't want just display previous month amounts, but making a selection and show always for each record the amount for the previous month. Search the forums for "AsOf" table.

Hope that helps.