Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
nazaninegogo
New Contributor III

show Latest NOT-NULL Value if last day's value was null

Dears

I have a table that sometimes some value get NULL , because the related table does not load completely.

because of that I want to show, If data was not loaded and was NULL, it should not show the zero value for it, and should the last item that had value.

sum(if("the value was null,show the latest value that is not Null", "else show the current value"),totaldownload)

how it can possible?

please help me.

I've attached my file.