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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2014-09-18 09:18 AM

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?

Labels (1)
Labels
661 Views
0 Likes
1 Solution

Accepted Solutions
MK_QSL
MVP
MVP
‎2014-09-18 09:23 AM

vMaxMth2

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

vMaxMth3

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

vMaxMth4

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

View solution in original post

619 Views
0 Likes
1 Reply
MK_QSL
MVP
MVP
‎2014-09-18 09:23 AM

vMaxMth2

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

vMaxMth3

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

vMaxMth4

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

620 Views
0 Likes