Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
desauv86
Contributor

Overwriting blank fields in dimension

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.

quick.PNG

Stefan

1 Solution

Accepted Solutions

Re: Overwriting blank fields in dimension

May be like this

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

View solution in original post

4 Replies

Re: Overwriting blank fields in dimension

May be like this

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

View solution in original post

Highlighted
payalgosar
Contributor II

Re: Overwriting blank fields in dimension

Can you share the sample source data?

Highlighted
samane_ramezani
Contributor

Re: Overwriting blank fields in dimension

Hi stefan

Do want fill null contract_ID with 33

and

Sum the Revenue of null contract_ID  with 245324?

Highlighted
desauv86
Contributor

Re: Overwriting blank fields in dimension

Thanks a lot Sunny.

This seems to be doing the job

Stefan