Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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
Specialist II
Specialist II

Re: help in rolling 12 using rangesum in custom report

you could build seperate Bookmarks and use them in your reports

Highlighted
Creator
Creator

Re: help in rolling 12 using rangesum in custom report

Hey Tim,

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

Highlighted
Specialist III
Specialist III

Re: help in rolling 12 using rangesum in custom report

Try like :

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

Highlighted
Creator
Creator

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
Creator
Creator

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
Creator
Creator

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
Creator
Creator

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
Creator
Creator

Re: help in rolling 12 using rangesum in Adhoc report

pls refer this attachment.

kush141087