Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor

help in rolling 12 using rangesum in Adhoc report

Hi ,

We have created a custom report were we have used rolling 12 month logic in the expression.

for every selected dimension i have written separate expression due to which the for one metric i have to write 6 different expressions.

Can someone suggest a simpler way to do so.

Thanks in advance.

kush141087

9 Replies
Highlighted
Valued Contributor II

Re: help in rolling 12 using rangesum in custom report

you could build seperate Bookmarks and use them in your reports

Highlighted
Contributor

Re: help in rolling 12 using rangesum in custom report

Hey Tim,

Sorry My bad i meant Adhoc Report and not custom report.

Highlighted
Valued Contributor III

Re: help in rolling 12 using rangesum in custom report

Try like :

Sum({<Date<={$(=AddMonths(max(Date),-12))}>} [Value Field])

Highlighted
Contributor

Re: help in rolling 12 using rangesum in Adhoc report

Hi Pradip ,

The logic for rolling 12 is working fine but in the [Value Field] , how will it take the list of all the Pick Dimensions selected with a comma seperator

Highlighted

Re: help in rolling 12 using rangesum in Adhoc report

Please post your sample application

Highlighted
Contributor

Re: help in rolling 12 using rangesum in Adhoc report

Hi

it just means that the user is empowered to decide what they wants to see. They can basically pick from multiple dimensions

below is my expression :

sum(aggr(RangeSum(Above( Sum({<MONTH_SHORT_NAME=,Year=>}Sales),0,12)),ID,Year,MONTH))


Whatever i select in the Pick Dimension should populate in the place of (ID,Year,MONTH) with a comma separator,


I just want to understand is there any possible way to do it.


Highlighted
Contributor

Re: help in rolling 12 using rangesum in Adhoc report

Hi

it just means that the user is empowered to decide what they wants to see. They can basically pick from multiple dimensions

below is my expression :

sum(aggr(RangeSum(Above( Sum({<MONTH_SHORT_NAME=,Year=>}Sales),0,12)),ID,Year,MONTH))


Whatever i select in the Pick Dimension should populate in the place of (ID,Year,MONTH) with a comma separator,


I just want to understand is there any possible way to do it.


Highlighted
Contributor

Re: help in rolling 12 using rangesum in Adhoc report

Hi kushal,

Attached is the sample QVW.

I tried using Concat and GetFieldSelections but the output is null.

Highlighted
Contributor

Re: help in rolling 12 using rangesum in Adhoc report

pls refer this attachment.

kush141087