topic Re: Fill null value with previous not null value in expression in QlikView

Fill null value with previous not null value in expression

Anonymous — Wed, 04 Oct 2017 09:26:35 GMT

A sample data set is : (empty cells = null data)

Required output is:

Can I achieve this using expression?

Currently I use "Before", but it doesnt work properly. It worked in August column, but went wrong in Dec.

sergio0592 — Wed, 04 Oct 2017 09:50:59 GMT

And if you try with :

rangesum (before(sum(Your_indicator),1,2))

Anonymous — Wed, 04 Oct 2017 09:55:45 GMT

yes i mean using rangesum with before

exactly like that

sunny_talwar — Wed, 04 Oct 2017 12:06:53 GMT

May be try this

Before(Column(3))

Assuming that the Cumulative (A-B) is your third Measure

Anonymous — Wed, 04 Oct 2017 14:37:21 GMT

my measures are very dynamic, it will appear based on user's selected measure

so Cumulative (A-B) will not always be my third measure

sunny_talwar — Wed, 04 Oct 2017 15:18:51 GMT

May be use the expression label in that case....

Before(LabelName)

Anonymous — Wed, 04 Oct 2017 16:13:02 GMT

I dont think I can use that.

Here I attach my latest qvw.

it went wrong when I select only 1 month, the table will show all month data.

sunny_talwar — Wed, 04 Oct 2017 16:19:40 GMT

To fix this with selection, you will have to perform this action in the script... no way to do this on the front end (at least that's what I think)

Anonymous — Thu, 05 Oct 2017 03:51:17 GMT

Could you help me to fix it by using script?

since I'm not very familiar with it

Thanks

sunny_talwar — Thu, 05 Oct 2017 13:59:55 GMT

Can you check now if this meets your requirement