previous month

[#1]

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

[brenner_martina]

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

[rohit214]

hi

try this

=month(field,-1)

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

may is helps you

thanks

rohit

[kamalqlik]

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

[#5]

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