Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
pinky1234
Contributor III
Contributor III

dynamic Date for 20 days

Hi Team,

I have the data like shown in below. date and Tickets columns. I want to know how many tickets we got it in 20 days. Say for ex: if I refresh the report today I want to know what happened in  last 20 days from today. Like wise I need it dynamically date should change when ever refresh the report. Can any one please help me?

DateTickets
9/1/20211
9/2/20212
9/3/20215
9/4/20216
9/5/20211
9/6/20212
9/7/20211
9/8/20211
9/9/20212
9/10/20211
9/11/20213
9/12/20212
9/13/20210
9/14/20211
9/15/20211
9/16/20210
9/17/20211
9/18/20210
9/19/20210
9/20/20211
9/21/20212
9/22/20211
9/23/20211
9/24/20211
9/25/20211
9/26/20211
9/27/20211
9/28/20211
9/29/20211
8/1/20211
8/2/20211
8/3/20211
8/4/20211
2 Replies
abhijitnalekar
Specialist II
Specialist II

hi @pinky1234 ,

Please use below expression.

 

sum({<date={"$(='>=' & Date(ReloadTime(),'DD-MMM-YYYY') & '<=' & Date(ReloadTime()-20,'DD-MMM-YYYY'))"}>}
tickets)

Regards,
Abhijit
keep Qliking...
AshutoshBhumkar
Partner
Partner

Hi,

Maybe something like below.

sum({<Date={">=$(=Date(ReloadTime()-20,'MM/DD/YYYY')) <= $(=Date(ReloadTime(),'MM/DD/YYYY')))"}>}Tickets)

 

Which will give data from 11-Sep-21 till today (Last 20 days)

 

Thanks,

Ashutosh