Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

jaswantc
Contributor II

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
jaswantc
Contributor II

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

can any one advice on this?

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

Hi,

one solution could be:

QlikCommunity_Thread_168620_Pic1.JPG

QlikCommunity_Thread_168620_Pic2.JPG

hope this helps

regards

Marco

jaswantc
Contributor II

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

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

!

jaswantc
Contributor II

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

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.

Community Browser