https://community.qlik.com/t5/App-Development/Projection-forward-keeping-a-value-today-constant-throughout-a/m-p/1867979#M71675 <P>Hey!&nbsp; I'm currently working an app where I've created a timeline trying to project numbers.</P> <P>However, I'm facing a problem trying to get a value calculated today to stay constant throughout future periods.</P> <P>The variable in itself varies with time, but I just need the time calculated today.</P> <P>Then I have another variable, which can only be calculated in future periods (varying with future time) to be multiplied by the constant value throughout the future time.</P> <P>I've currently made an if-else statement, where the blue represent actual values until today, and the red should represent future projections:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="sebHan_0-1638955157427.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/68162i07C8A39F5EC84FC7/image-size/medium?v=v2&amp;px=400" role="button" title="sebHan_0-1638955157427.png" alt="sebHan_0-1638955157427.png" /></span></P> <P>Can anybody help here?</P> <P>&nbsp;</P> <P>&nbsp;</P> Wed, 08 Dec 2021 09:19:30 GMT sebHan 2021-12-08T09:19:30Z https://community.qlik.com/t5/App-Development/Projection-forward-keeping-a-value-today-constant-throughout-a/m-p/1867979#M71675 <P>Hey!&nbsp; I'm currently working an app where I've created a timeline trying to project numbers.</P> <P>However, I'm facing a problem trying to get a value calculated today to stay constant throughout future periods.</P> <P>The variable in itself varies with time, but I just need the time calculated today.</P> <P>Then I have another variable, which can only be calculated in future periods (varying with future time) to be multiplied by the constant value throughout the future time.</P> <P>I've currently made an if-else statement, where the blue represent actual values until today, and the red should represent future projections:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="sebHan_0-1638955157427.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/68162i07C8A39F5EC84FC7/image-size/medium?v=v2&amp;px=400" role="button" title="sebHan_0-1638955157427.png" alt="sebHan_0-1638955157427.png" /></span></P> <P>Can anybody help here?</P> <P>&nbsp;</P> <P>&nbsp;</P> Wed, 08 Dec 2021 09:19:30 GMT https://community.qlik.com/t5/App-Development/Projection-forward-keeping-a-value-today-constant-throughout-a/m-p/1867979#M71675 sebHan 2021-12-08T09:19:30Z