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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
sunil-kumar5
Creator II
Creator II

Average of last three months

Hi All,

I have a below table where I need a count of partnername who installed average 1 license in last three months.

Like we are in feb currently so the count should be taken from Jan2021, dec2020 and nov2020, and 1 license installed each month which leads to average count 1.

License Number - License number installed against sale (so it is basically 1 license number = 1 sale)

Partnernamelicensenumberinstallationdate
A1656Jan-21
B1654Feb-18
C1590Jan-21
D1361Feb-19
A1234Feb-21
B1571Apr-21
C1981Apr-21
D1636Jan-21
D1602Feb-21
A1921Jan-21
B1725Feb-19
B1732Dec-20
C1706Nov-20
D1996Mar-18

 

Thanks

1 Reply
sunil-kumar5
Creator II
Creator II
Author

Can anyone please look into it?