Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Sure...attached is the QVW
HI
Sum({<rcptdate={">=$(=timestamp(MonthStart(Today(),-12)))<=$(=timestamp(Today()))"}>}extcost)
Hope it helps
That worked! Thank you so much...still getting the hang of QlikView
I appreciate the assistance
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.
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