Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikviewuser20
Contributor III
Contributor III

Qlikview Less and more than 12 months from selected month and year

Hi Everyone,

 

I have a scenario where i have to show :

-Persons without registrations for less than 12 months

-Persons without registrations for more than 12 months

I am using below Calculated dimensions:

=if(
aggr(max(MonthEnd(Date(Date))),Person)<MonthEnd(AddMonths(aggr(max(TOTAL Date(Date)),Person),-12)),'Persons without registrations for more than 12 months',
if(aggr(max((Date(Date))),Person)>=MonthStart(AddMonths(aggr(max(TOTAL Date(Date)),Person),-11)),'Persons without registrations for less than 12 months',
'Without registrations'))

And below expression :

count(DISTINCT Person)

So when i select for example June 2019 i have to see at the dimension 'Persons without registrations for less than 12 months' , person who have registration between July 2018 and June 2019. But with my expressions i only have persons who have registration between January 2019 and June 2019.

Any idea how to handle that ?

Thank you in advance

Labels (4)
0 Replies