topic Re: Apply Input Field value to forward records untill new Input Field value in QlikView

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

Anonymous — Tue, 16 Jun 2015 20:33:21 GMT

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:

PERIODID	Price	PriceInput	NewPrice
201501	10	15	15
201502	15	0	15
201503	20	0	15
201504	10	10	10
201505	30	0	10
201506	25	0	10

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

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

Anonymous — Tue, 16 Jun 2015 21:48:03 GMT

can any one advice on this?

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

MarcoWedel — Tue, 16 Jun 2015 22:56:51 GMT

Hi,

one solution could be:

hope this helps

regards

Marco

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

Anonymous — Wed, 17 Jun 2015 02:16:48 GMT

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

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

Anonymous — Wed, 17 Jun 2015 16:03:31 GMT

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.