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: 
Not applicable

Expression - Update values into variables

Hi,

I have 4 variables.

vMaxMth1

vMaxMth2

vMaxMth3

vMaxMth4

If I have value in vMaxMth1 = 31/08/2014'. I need other 3 variables file up as below.

vMaxMth2 - 31/07/2014

vMaxMth3 - 30/06/2014

vMaxMth4 - 31/05/2014.

How can I do that?

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

vMaxMth2

=AddMonths('$(vMaxMth1)',-1)

vMaxMth3

=AddMonths('$(vMaxMth1)',-2)

vMaxMth4

=AddMonths('$(vMaxMth1)',-3)

View solution in original post

1 Reply
MK_QSL
MVP
MVP

vMaxMth2

=AddMonths('$(vMaxMth1)',-1)

vMaxMth3

=AddMonths('$(vMaxMth1)',-2)

vMaxMth4

=AddMonths('$(vMaxMth1)',-3)