topic Re: requirement in QlikView

requirement

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have a requirement

table:

Load* Inline

[Region Sales

S, 200

E, 400

];

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 — Thu, 30 Jun 2016 17:15:37 GMT

Maybe like

table:

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

Inline

[Region, Sales

S, 200

E, 400

];

sinanozdemir — Thu, 30 Jun 2016 17:16:49 GMT

Something like this:

And the data model is:

Hope this helps.

satishkurra — Thu, 30 Jun 2016 17:23:48 GMT

Attached

Thu, 30 Jun 2016 17:27:45 GMT

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 — Thu, 30 Jun 2016 17:30:14 GMT

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), ...