Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
lindelanifakude
Contributor
Contributor

Getting the data from the selected date(Year or Quarte) backwards

Hi 

So I want to count the number of active cases but not only per selected quarter  but I want count from the selected quarter backwards. Example I selected last quarter of 2020 (Oct - Dec 2020) I don't want to count the active cases for Oct - Dec but I want to count all the active cases from the last quarter of 2020 back.

I have a quarter on the list box as you can see on the attached pic.

I hope my question make sense. Below is the sample of my expression:

count(if(BV_Ind=1 and GHHInd=1 and ActiveInd=1, CaseId))

 

 

 

 

 

1 Reply
Marcos_Ferreira_dos_Santos

Hello lindelanifakude,

Your need is perfectly feasilble applying Set Analysis, isn't it ?

Best regards

Marcos