topic Selecting Previous Month Data in QlikView

Selecting Previous Month Data

Muthu — Wed, 17 Dec 2014 10:41:13 GMT

Hi,

I have a table which have the values for some months and also the ids for particular month

In the list box I wanted to show only the values which is current slecton month - 1.

I have created a variable for getting the previous month of current seleciton but stil im not getting any value.

Please help.

Gysbert_Wassenaar — Wed, 17 Dec 2014 12:37:04 GMT

I don't understand what you're trying to do. Can you post an example document that demonstrates the problem?

gartigas — Wed, 17 Dec 2014 22:56:20 GMT

I've made it defining variables.

Like the following:

LET vMonth_present = Month(AddMonths(Today(),0)); // gives the present month

LET vMonth_prior1 = Month(AddMonths(Today(),-1)); // gives the last month

LET vMonth_prior2 = Month(AddMonths(Today(),-2)); // gives the month before

**********************************************

regards. gustavooooo