Skip to main content

Qlik

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
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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
‎2016-06-09 11:32 AM

SET current Period to Previous Period

Hi All,

I have an issue with one of the tables that I am creating. Find the table below. I have formulas calculating the values from Q1 - Q4 and Fy depending on the Year and the Period selected (say Year : 2016 and PEriod : 5 )

I need to create one more column which should recalculate the formulas for Pevious Period.

In the formula there are other variables that are dependent on the period too. Eg: Target Period will be  >=1<=4 for Period 4 and will be >=1<=5 for Period 5.

Is there any way I can force the Period value to be Period -1 in the begining on the caluculations so that I will be able to re use my formulas?

Q1Q2Q3Q4FYFY Pre.Period
203 Views
0 Likes
1 Reply
sunny_talwar
MVP
MVP
‎2016-06-09 11:48 AM

It would be better if you can share some raw data with expected output.

143 Views
0 Likes