Discussion board where members can get started with Qlik Sense.
I am having numbers need to be added as cumilatively. Range sum() will do that. After that i need to get average of those numbers monthly. I am having 5 years of data.
In this case if i want to calculate Avg for May-17 i need to consider (72+102)/2 insted of (12+30)/2
How can i achieve this. Thanks in advance.
Go to Solution.
Please Find Attachment.
like this ?
You want that current month avg=(last Month rangesum value + Current month rangesum value)/2
Can you please elaborate more.
To calculate average from januay to may- i need to consider only Sum(Range_sum)
I need an expression here, based on the date selection i need to get the average.
example for May-17 average will be (72+102)/2=87
If i select April and May 2017 average =(60+72+102)/3=78 is my desired output.
Yes neha, based on the months selected by user need to get those month rangesum average
Thanks for your time.
It's not working for me. I am not considering only one month here. even for one month also formula is not working.
Will it only work for time dimension or works for all the dimensions?
It should work for no any selection of month. See the attached file.
You need month to be changes according to your selection.
Can you share QVF file. That will help me. I am using sense server.
ohh...& i'm using Qlikview