Last Value of a range date

[Jqlik]

Hi everyone,

I have this example:

	Jun	Jul	Aug	Sep	Oct	Nov	Dec
% e-Sales	20%	10%	10%	40%	60%	null	null
% e-Orders	3%	5%	6%	2%	null	7%	null
% Other e's	40%	35%	15%	null	null	null	null

I want to take the last available value and change it to null values.

I want this final result, :

	Jun	Jul	Aug	Sep	Oct	Nov	Dec
% e-Sales	20%	10%	10%	40%	60%	60%	60%
% e-Orders	3%	5%	6%	2%	2%	7%	7%
% Other e's	40%	35%	15%	15%	15%	15%	15%

How could i create this?

Thanks, 

[Chanty4u]

Hi 

you can try before function. 

https://community.qlik.com/t5/QlikView-Documents/Missing-Manual-Before-and-After/ta-p/1488064