requirement

[#1]

Hi All,

I have a requirement

table:

Load* Inline

[Region Sales

S, 200

N,

E, 400

W,

];

Now the requirement is

In Null values, should be replaced by previous sales.(Sales for N 200 and for W 400)

How do we achieve this?

any ideas?

Regards,

Bob Tech

[swuehl]

Maybe like

table:

Load Region, If(Len(Trim(Sales)),Sales,Previous(Sales)) as Sales

Inline

[Region, Sales

S, 200

N,

E, 400

W,

];

[sinanozdemir]

Something like this:

And the data model is:

Hope this helps.

[satishkurra]

Attached

[#5]

Thanks for your quik reply.

Yes that is exactly what I need.. and if you don't mine could you elaborate your expression as am new to qvw.

what exactly does len(trim(sales)?

As I know know Len('qlikview') it returns 8.

[swuehl · Accepted solution]

If( Len(Trim(FIELD)) , ...

is just a method to check if FIELD is not NULL or empty or only contain spaces.

There are other methods to only check for NULL, like

If( IsNull(FIELD), ...