Function column doesn't return correct smiley colour.
Hello All,
When I am using the below condition: = IF(Column([Previous Week]) > Column([Target(T1)]), '$(v_LoadImagePath)'&'\Smiley_Red.jpg', IF(Column([Previous Week]) < Column([Target(T)]), '$(v_LoadImagePath)'&'\Smiley_Green.jpg','$(v_LoadImagePath)'&'\Smiley_Orange.jpg'))
in the column W3 status(see attached chart) I am getting orange smiley for both values, that is, for high risk PSR and IC. As per the formula, PSR the smiley should be orange which is correct when we see the table but the value of IC should have been green as 16 is less than 17.
I think the function column is not comparing values for each specific column. When the first condition is matched it doesn't evaluate the second column.
Can you please help me on this issue? I want Qlikview to evaluate PSR and IC values with the values of column Previous Week and give me the correct smiley colour as per the conditions below.
IC Target is 17 and PSR target is 0.05 The conditions are: 1. Smiley green when IC and PSR < T 2. Smiley red when IC and PSR > T + 10% 3. Smiley orange when IC and PSR < T + 10% and IC and PSR > T