Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

How to carry forward while substracting the value from current month result.

Hi Expert,

    I have small requirement that In my data file I have fields like below

Month,sales

Jan,10

Feb,20

Mar,30

Apr,40

May,50

Jun,60

July,70

 ***********************

Requirement is I have keep one input box to enter dynamic values.

Ex: current month is Jan so if user enter some value like 12 then 10(jan) value has to be replace with 12 and in next month value should be change with result like below

-->Input box    [In the input box user enter like 12]

Month,sales     Result

Jan,10                   12           

Feb,20                    18  [ it will get 12(input box vlaue)-10(jan value)] =2----> 20-2 == 18

Mar,30

Apr,40

******************

up to this I achieved

but if user enter like below how carry forward into next months like mar,apr,may...

-->input box     [if user enter 34]

Month,sales          Result

Jan,10                        34       -->it is replacing with input box value

feb,20                           0      --- (34(inputbox value)-10(jan value)=24(remain value)) -->20(feb value)-24 =0 this month result and 4 is remain value

mar,30                        26    -- remaing value (4)-30(Marvalue=  26)

apr,40

 

Kindly give some suggestion.

Thanks in advance...........