topic Extrapulate data from last known data plot in QlikView

Extrapulate data from last known data plot

tinkerz1 — Wed, 04 Nov 2015 15:13:23 GMT

Hi,

As my data stops mid year on a monthly scale, and I would like to take the last known data point and contuinue it over the entire data range.

Can this be done in set analysis?

=sum(distinct if([Status]='Open',[MSII Threshold Data]))

Thanks

Re: Extrapulate data from last known data plot

Qrishna — Wed, 04 Nov 2015 15:15:20 GMT

=sum({$<[Status]={'Open'}>} DISTINCT [MSII Threshold Data])

Re: Extrapulate data from last known data plot

tinkerz1 — Wed, 04 Nov 2015 16:11:49 GMT

Hi,

Thanks for the set analysis code but the issue is no date data for the Threshold Data, the set analysis code will work only if there is date data, my date column has other dates in it, that means only partial data for the thresholds against the other dates.

Thanks,