Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
rsdhavle
Creator III
Creator III

Count of Rolling Months in Denominator

I am calculating expression based on rolling 12 months, so lets say i have data for 2 years 2015,2016. I want to divide my expression in denominator by 12 till i have data for 12 months available with me however when i am selecting month Nov 2015 i want to divide it by 11 as i have only 11 months rolling data available and when i am selecting Oct 2015 i want to divide by 10..

How can we calculate this count of month dynamically based on a range of rolling months available?

3 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Perhaps: rangemin(12, rowno())


talk is cheap, supply exceeds demand
rsdhavle
Creator III
Creator III
Author

it is giving me 12 for all selections even if i select 2015 Oct, September etc.

sunny_talwar

Would you be able to share a sample to show what exactly are you trying to do?