Mapping Load for variations in target measures

helen_pip — Fri, 13 Jan 2017 13:05:14 GMT

Dear Qlikview User

I have loaded and inline statement which allows me to do a mapping load and align a target to a metric

Inline

Target:

MAPPING LOAD * INLINE [

Metric, Target_Line

A, 3

B, 0

C, 0

D, 2

E, 0.97

];

The mapping load is then applied to a table in my load and results in a field called Safe_Target

I now need to reference the Safe_Target field in order to show under Text Color of an expression as to whether the Metric has hit the target of not. However some of my metrics have a target of >= or <= and some of my metrics are counts, while others are %'s.

My problem is I cannot get the text format to show for each Metric accurately. This is my attempt at trying to apply a Target_Line with lots of different combinations. Only Metric A and D are showing accurately so far

-------

If(Num(sum({$<Metric = {'A', 'D}>}Numerator))

<=Num#(Safe_Target), $(vColour_Green),

-------

If(Num(sum({$<Metric = {'B', 'C'}>}Numerator))

>Num#(Safe_Target), $(vColour_Green),

$(vColour_Fail_Target)

Can anyone provide any advice as to how I can get Metrics B and C to also show the correct text colours. I understand that my expression may not have been written accurately

Kind Regards

Helen

topic Mapping Load for variations in target measures in QlikView

Mapping Load for variations in target measures