Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mattiat91
Contributor
Contributor

Calculate previous week from a predefined period

Hello,

i need your support.

I have to calculate values of the previous week from a period that the user can define. (ex.1 Month, 1 week, 2 weeks or from day x to day y)

The calendar is built on this format date YYYYMMDD

I made this formula LastWeek = (PeriodTime Variable) - 7

It works if user takes as reference a day of 2nd, 3rd, 4rd week. The problem is when i select day/s from the 1rst week.

Here some screen --> selected period 

mattiat91_0-1650363487401.png

In the previous week formula

mattiat91_1-1650363549566.png

Changing month, format goes to week format. Why?

 

 

 

 

Labels (1)
0 Replies