Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

show something in diagram if field is selected

Hi togehter,


is it possible to write "error" in a diagram, if a field is selected ?


goal:
I want to build a chart for all my Qlikview ETL processes using a traffic light graphic shows the current status.

By the way I've already seen here in the forum well-functioning applications. Unfortunately, these are far too complex for me and therefore need a smaller application.


I have here in the forum already a macro that select a field on errors when my applikation starts ( macro autostart).

This macro will automatically detect if an error has crept. So far so good



Now I have to rely on your advice.


My Question: How can I in dependence with that illustrated selection (see chart), a value written in my diagram ?


For example, something like that:



Note: In this example I am assuming that the other fields are not selected and therefore no error is shown.


Thank you very much for advice.

Best Regards,

1 Solution

Accepted Solutions
Not applicable

Re: show something in diagram if field is selected

Here the Solution:

=if( index ( GetFieldSelections (ERROR_TYPE_ETL_Process_3), 'General Script Error') > 0, 'General Error Occurred', 'No Errors')

1 Reply
Not applicable

Re: show something in diagram if field is selected

Here the Solution:

=if( index ( GetFieldSelections (ERROR_TYPE_ETL_Process_3), 'General Script Error') > 0, 'General Error Occurred', 'No Errors')

Community Browser