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

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
ivanyang25
Contributor III
Contributor III

How to Select Dates which have aged over 2 days

Dear Qlik Sense Experts

I am new to Qlik Sense and I am a front end user

Now I have a form as below and I want to add one filter to select the ones which have aged over 2 days

Let’s say today is 2017/7/29, then I need to exclude 2017/7/27 & 2017/7/28

Then if I refresh data tomorrow, I need to exclude 2017/7/28 & 2017/7/29

May I know how can I achieve it by writing expression in Dimension from front end?

Thank you for your advice in advance

捕获.PNG

10 Replies
vinieme12
Champion III
Champion III

it should be the same are your field format or the default definition for date format in the load script as Antonio pointed out

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.