Help Needed

Sat, 19 Nov 2011 13:38:25 GMT

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.

Help Needed

Sun, 20 Nov 2011 09:38:32 GMT

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

topic Help Needed in QlikView

Help Needed

Help Needed