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

Apply Input Field value to forward records untill new Input Field value

Hi All,

I have use case where i want to input value and carry the same value until new input value entered.

Can some body advice me how to do this with Rangesum function or any other functions like above()

Input Data

INPUTFIELD PriceInput;

LOAD * INLINE [

    PERIODID,     Price    ,PriceInput

    201501,      10        ,0

    201502,     15        ,0

    201503,     20        ,0

    201504,        10        ,0

    201505,        30        ,0

    201506,        25        ,0

];

Desired O/P:

PERIODIDPricePriceInputNewPrice
201501101515
20150215015
20150320015
201504101010
20150530010
20150625010

In the above example if i enter value 15 at PriceInput at Period 201501 then it should carry forward untill new value 10 entered at 201504.

and same 10 has to carry forward all the way upto new value entered.

Thanks

4 Replies
Anonymous
Not applicable
Author

can any one advice on this?

MarcoWedel

Hi,

one solution could be:

QlikCommunity_Thread_168620_Pic1.JPG

QlikCommunity_Thread_168620_Pic2.JPG

hope this helps

regards

Marco

Anonymous
Not applicable
Author

Hi Marco,

Thanks, I just added one more dimension to the table called ID and if i do sort on PERIOD ID then it is not working and probably i we need to add some aggregation function.

If Sort by ID then it is working properly but when we change sort order to ID then not not

!

Anonymous
Not applicable
Author

Hi Marco,

This works for me when only one dimension with Period and when adding additional dimension and sorting by period then above function not working.