topic Overwriting blank fields in dimension in QlikView

Overwriting blank fields in dimension

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All

I have this problem with irregularities in my data, which I'm not able to fix right now.

Therefore I'm trying to make a quick-fix instead.

If a customer has a contract # all the revenue should be registered on that contract #. However, this is not always the case due to human errors.

Would there be any solution where I could overwrite below, and group the revenue on the Contract # 33?

I would prefer to do this in the expression in the front end solution, and not in the script.

I'll appreciate all the help I can get.

Stefan

sunny_talwar — Wed, 20 Dec 2017 13:57:43 GMT

May be like this

If(Len(Trim([Contract ID])) > 0 and [Contract ID] > 0, Sum(TOTAL <#, Name>Revenue))

Anonymous — Wed, 20 Dec 2017 13:57:58 GMT

Can you share the sample source data?

Anonymous — Wed, 20 Dec 2017 14:04:43 GMT

Hi stefan

Do want fill null contract_ID with 33

and

Sum the Revenue of null contract_ID with 245324?

Anonymous — Thu, 21 Dec 2017 08:10:35 GMT

Thanks a lot Sunny.

This seems to be doing the job

Stefan