Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
manojkumar_mk
Partner - Contributor II
Partner - Contributor II

How to calculate last seven days update dates from date field

Hi Qlik experts,

I am troubling with my new scenario. it is below:

I have a table  with column names like Strategy Name and Last update and Business date.

my scenario is: I want show how many rows are updated in last seven days.

Example: 

Internal Strategy NameLast UpdateBusiness date
MANOJ-TEST06/03/202001/03/2019
MANOJ-TEST06/03/202001/03/2019
MANOJ-TEST06/03/202001/03/2019
MANOJ-TEST06/03/202001/03/2019
MANOJ-TEST06/03/202001/03/2019
MANOJ-TEST06/03/202001/03/2019
MANOJ-TEST06/03/202001/03/2019
MANOJ-TEST06/03/202001/03/2019
MANOJ-TEST06/03/202001/03/2019
MANOJ-TEST09/03/202001/03/2019
MANOJ-TEST09/03/202001/03/2019
MANOJ-TEST03/03/202001/03/2019
MANOJ-TEST13/03/202004/12/2017
MANOJ-TEST13/03/202001/03/2019
MANOJ-TEST17/03/202001/03/2019
MANOJ-TEST05/12/201901/03/2019
MANOJ-TEST05/12/201901/03/2019
MANOJ-TEST05/12/201901/03/2019

 

Output:

Internal Strategy NameLast UpdateBusiness date
MANOJ-TEST 01/03/2019
MANOJ-TEST 01/03/2019
MANOJ-TEST 01/03/2019
MANOJ-TEST-106/03/202001/03/2019
MANOJ-TEST06/03/202001/03/2019
MANOJ-TEST 01/03/2019
MANOJ-TEST-106/03/202001/03/2019
MANOJ-TEST 01/03/2019
MANOJ-TEST06/03/202001/03/2019
MANOJ-TEST09/03/202001/03/2019
MANOJ-TEST 01/03/2019
MANOJ-TEST03/03/202001/03/2019
MANOJ-TEST-113/03/202004/12/2017
MANOJ-TEST 01/03/2019
MANOJ-TEST17/03/202001/03/2019
MANOJ-TEST 01/03/2019
MANOJ-TEST 01/03/2019
MANOJ-TEST-105/12/201901/03/2019

 

Quick replay will be more appreciate guys..

Please provide me a proper solutions for that.

 

Thanks in Advance..!!!!

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

0 Replies