Discussion board where members can get started with QlikView.
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.
May be like this
If(Len(Trim([Contract ID])) > 0 and [Contract ID] > 0, Sum(TOTAL <#, Name>Revenue))
View solution in original post
Can you share the sample source data?
Do want fill null contract_ID with 33
Sum the Revenue of null contract_ID with 245324?
Thanks a lot Sunny.
This seems to be doing the job