Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Saiteja1
Contributor III
Contributor III

Active and inactive status with lastlogindate

Hi

I have a field called IsActive in that the values are 0 and 1

I have another field called LastLoginDate in that the values are login time of users

IsActive = 0 means Inactive users

IsActive = 1 means active users


Requirement is

if we click IsActive = 0 the we need to see full login time of inactive users except latest 6 months.

if we click IsActive = 1 the we need to see full login time of active users and latest 6 months data of inactive users.

 

0 Replies