topic Re: missing values to build an continue trend in QlikView

missing values to build an continue trend

Mon, 29 Dec 2014 13:57:59 GMT

hello,

i explain my problem... i ve some lines which represent the mouvement of my stock for an article and an site..

In this line i ve the information of the values and the quantity of my stock for the article and the site..and for the date of the movement...

So if i don t have an movement i don't have the information of the value of my stock....

Or the direction wants to have an trend for every day...

So i ve put the information missing (quantity and Value) of my stock into new lines for every day and every couple (article/Site) in the script...

It looks goods fpr some months but the script stop or put too many time for more than 6 month of data.... and the final application are too heavy...

Is there any other solution to solve this problem maybe with an some set analysis?

Re: missing values to build an continue trend

MarcoWedel — Mon, 29 Dec 2014 15:07:49 GMT

please post sample data/app

Re: missing values to build an continue trend

Mon, 26 Jan 2015 13:38:46 GMT

sorry for the delay but i was in holidays and after i ve worked on others problems...

Anyway, i ve joined an part of the app. with some datas...

You ll se the indicators (quantity= mvt.QteStockJour and Value=mvt.ValStockJour) wich permit to know at an date the quantity and the value of my article for an site....