topic An interesting load question in QlikView

An interesting load question

Fri, 30 Oct 2009 20:10:21 GMT

I'm trying to load a file where the metrics are grouped by the first column, grouped as showen below

So for example, I sold Fords on 10/1-10/5. How can my QV Load regonized 10/2/-10/5 as belonging to Ford?

My result should look like the following

An interesting load question

Fri, 30 Oct 2009 20:18:06 GMT

Hi Jonathan,

is it an excel file or is it a database table?

Rainer

An interesting load question

johnw — Sat, 31 Oct 2009 04:07:28 GMT

Probably peek() or previous(). I always get confused on which is which:

if(len(trim("Model")),"Model",previous("Model")) as "Model"

An interesting load question

Anonymous — Sat, 31 Oct 2009 08:55:29 GMT

I answered a similar questiong here in the past - search for "fill with previous". I think it was peek() function. And load should be sorted correctly.

An interesting load question

Wed, 04 Nov 2009 03:45:23 GMT

The fill capability in the script worked like a charm