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: 
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