Qlik Community

Ask a Question

New to QlikView

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

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

Calculating Prior day using formula

I am trying to calculate the prior day using variables.

What is the best way to do this?

I have a table of dates but they are not consecutive as weekends are excluded. If the user select the date for the Monday I would like a variable to calculate the previous day which would be Friday.

2 Replies
Contributor III
Contributor III

try something like

=Max({1<Date={"<$(=Date)"}>}Date)

Creator
Creator

You can use the firstworkdate() function.

136192.png

If 28/09/2014 is selected (which is a monday), the result is 25/09/2014 (friday).