topic Re: previous month in QlikView

previous month

Tue, 20 Dec 2011 19:25:44 GMT

I am attaching a test file for your reference . Here I am want to see in the second table previous months status by selecting consumer no from list box while my first table will show me the selected months data.

Please modify the Month column if necessary .

Regards

Re: previous month

brenner_martina — Wed, 21 Dec 2011 08:13:04 GMT

Hi, Atanumohanty,

you can use the function AddMonths() like this, enter a new dynamic dimension:

=MonthName(AddMonths(END_DT,-1))

Greetings from Munich

Martina

EVACO GmbH

Re: previous month

rohit214 — Wed, 21 Dec 2011 09:21:48 GMT

try this

=month(field,-1)

(monthname(AddMonths(TempDate,-12)) as LastYearDate,

may is helps you

thanks

rohit

Re: previous month

kamalqlik — Wed, 21 Dec 2011 09:42:49 GMT

Hi atanumohanty,

The output you want is known as dynamic in qlikview.

For this you can refer to the set analysis and other dynamic example in qlikcommunity.

I have made the change for you in the second chart.

I hope it will work for you

I am also attaching another QVW application that will help you for the set analysis and dyanamic concept in qlik view...

cheers

Kamal

previous month

Sun, 29 Jan 2012 20:14:35 GMT

Thanks for your reply ,But My problem is not only change the month to previous month but to change all the relative fields to the last month so that I can compare both the months fields side by side.

Awaiting for your replay

Regds

Atanu