Qlikview application that capture the failure of SSIS package loading data in Data warehouse

[AH]

Hi,

Is the Govenrance application capable to capture the load failure of SSIS package in Data warehouse? If its cant then, could you please suggest me any application which can help me with that?

Thanks for your help.

Thanks,

Shan

[AH]

Hi Charles,

Thanks for your valuable feedback. The expression you provided perfectly makes sense but i cant somehow achieve to my goal.

Please see the attach qvw and advise.

Thanks,

Ahmed

[cspencer3]

You are using SET vYellow = 'RGB(255,155,0)' for example, but you need to use: LET vYellow = RGB(255,255,0). Your current way is setting the variable as a string rather than setting it equal to what RBG() will return. If you keep the color variable as a string you would have to use $(vYellow) as your color in your If statement.

[AH]

Its totally working now. Thanks for the great feedback Charles.

I understood the variable in a wrong way.

Thanks Again.

Ahmed

[cspencer3]

You are Welcome and I am glad I could help. Thank you for marking the Answers as correct and helpful for the further benefit of other Qlik Community Users.