Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help Needed

Hi,

   I have a starigh table with  Actual Incentive amount for certain Rule Id's. Now I want to fill the actual to all projected values for same Id. Basically in a straight table if the value ebists in the column I want to fill all fields with the same value. Any method to do this will be appreciated. Thanks

Eg:

Rule   FAN Actual Incentive

1        A       100

1        B        100

I have now

Rule   FAN Actual Incentive

1        A       100

1        B        100

1        C        -

1        D        -

I want to fill the null values with 100.

1 Reply
Not applicable
Author

Hi Kakarotto

Try something like:

=only(Total <Rule> ActualIncentive)

as an expression. This would look for a single value in ActualIncentive for A particular rule, and populate it for all FANs, regardless if the FAN value is null. If you are after an average of the existing values, replace "only" with "average"

Hope this helps

Erica