Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

An interesting load question

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

Tags (3)
1 Solution

Accepted Solutions
mov
Esteemed Contributor III

An interesting load question

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.

4 Replies
Not applicable

An interesting load question

Hi Jonathan,

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

Rainer

MVP
MVP

An interesting load question

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

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

mov
Esteemed Contributor III

An interesting load question

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.

Not applicable

An interesting load question

The fill capability in the script worked like a charm

Community Browser