Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Users, make your voice heard! Participate in Wisdom of Crowds® Market Study: Start Survey
cancel
Showing results for 
Search instead for 
Did you mean: 
sunil-kumar5
Creator
Creator

Last six month activation

Hello All,

I have a table containing partnername, license count, activationdate, date of association

On the basis of this I have to create a interval from 0 to 21+

month - I got from date of association

onboarded partners count- this I just put the partner'sname

now I have to calculate the last six month license count with partner slab  , I am not sure as how can I create the intervals please advise..

  Last 6  months Avg Activation Slab wise Partner Count
MonthCount of Partners Onboadrded01-34-78-1213-2021+
Oct'181712311  
Nov'1826242    
Dec'182311561  
Jan'192415252  
Feb'1924182211 
Mar'19241833   
Apr'19251951   
May'1914842   
Jun'19138 4  1
Jul'19147 421 
Aug'1919113212 
Sep'19752    
1 Reply
saran7de
Master
Master

Please upload the sample data to work upon