Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Invalid expression help

Hello,

I'm receiving an invalid expression error when trying to create a flag in my script.  I'm not sure what I'm doing wrong.  Can anyone help me?

LOAD

%METRIC_KEY,

if(TARGET_VARIANCE = 'U',

if(if(MASK_DISPLAY = '#.##%', num(sum(NUMERATOR)/sum(DENOMINATOR), '#,##0.00%'),

Median(MEDIAN))<THRESHOLD_TARGET), 'Bad',

  if(if(MASK_DISPLAY = '#.##%', num(sum(NUMERATOR)/sum(DENOMINATOR), '#,##0.00%'),

Median(MEDIAN))>= sum(THRESHOLD_TARGET) and if(MASK_DISPLAY = '#.##%', num(sum(NUMERATOR)/sum(DENOMINATOR), '#,##0.00%'),

Median(MEDIAN))< if(MASK_DISPLAY = '#.##%', num(TARGET, '0.00%'),

TARGET), 'OK', 'Good')),

if(if(MASK_DISPLAY = '#.##%', num(sum(NUMERATOR)/sum(DENOMINATOR), '#,##0.00%'),

Median(MEDIAN))<TARGET, 'Good',

  if(if(MASK_DISPLAY = '#.##%', num(sum(NUMERATOR)/sum(DENOMINATOR), '#,##0.00%'),

Median(MEDIAN))<= THRESHOLD_TARGET and if(MASK_DISPLAY = '#.##%', num(sum(NUMERATOR)/sum(DENOMINATOR), '#,##0.00%'),

Median(MEDIAN))> if(MASK_DISPLAY = '#.##%', num(TARGET, '0.00%'),

TARGET), 'OK', 'Bad'))) as Flag

Resident FACT_temp

Group by %METRIC_KEY;

Thank you in advance.

1 Reply
Clever_Anjos
Employee
Employee

You need to have

TARGET_VARIANCE,MASK_DISPLAY at group by too, since they are not beeing aggregated at expression