Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Selecting Previous Month Data

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.

2 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: Selecting Previous Month Data

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


talk is cheap, supply exceeds demand
Highlighted
Contributor II
Contributor II

Re: Selecting Previous Month Data

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