Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Average of the last 8 days

Hi All,

I want to calculate average of last 8 mondays or tue so on and leaving current monday sum.same for all weekdays

and then replace that average with all the mondays or tue or fri so on in a table

Please help

Thanks,
averagedaily.PNG

Labels (1)
23 Replies
Highlighted

I don't think you have provided me with the correct output... look at this.... I would have expected to see 45.5

image.png

But you seem to have calculated like this

image.png

Did the requirement changed or is that an error?

 

Also, how is average 1 here? There is no previous date... shouldn't this be Null?

image.png

 

Highlighted
Creator II
Creator II

Hi,
sorry my bad,
output which you have provided is correct.
if there is no previous date then same value will replicate as average.
I tried to to this and succeeded for last 8 days ,but it is not calculating for previous dates

Thanks,
Highlighted

Sorry I was not clear before, but can you please provide the updated output file with the correct numbers. This will help me verify if I am getting the right numbers across the board.

Highlighted
Creator II
Creator II

Sure,

 

Please find Attachment.