Discussion board where members can get started with QlikView.
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.
try something like
You can use the firstworkdate() function.
If 28/09/2014 is selected (which is a monday), the result is 25/09/2014 (friday).