Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Show past 12 months

I need to show data for the past 12 months of the current date (including current month)

Currently, my dimension for my chart is a calculated dimension:

=date(MonthName([rcptdate]), 'MM-YY')

How do I only show the past 12 months?

14 Replies
Not applicable
Author

Sure...attached is the QVW

MayilVahanan

HI

Sum({<rcptdate={">=$(=timestamp(MonthStart(Today(),-12)))<=$(=timestamp(Today()))"}>}extcost)

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

That worked!  Thank you so much...still getting the hang of QlikView

I appreciate the assistance

CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

Please make sure that set analysis expression value and field are same format.

MonthStart returns only date but your date field has both date and time means timestamp format.

This should be considered on using date comparison in set analysis.

Anonymous
Not applicable
Author

HI Ram,

i need last 12 months remaining due  for trx date can you please write the syntax

vtrx date is nothing but today date i need to to get last 12 months remaining due can u please write the syntax.

=rangesum(above(Sum(If(TRXDATE>addmonths(vTrxDate,-12) and  DATE>vTrxDate and REMAININGDUE)),0,RowNo()))/100000

can u please any one help me its urgent requirement

Thanks,

krishna