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: 
erivera10
Creator
Creator

Gráfico de líneas, Line chart

I need to create a line chart, where the 'dimension' will be a field 'week', and the expression is a sum of a field called 'APPROVED', with a condition, compare fields, process and approved, of which, in the process there are three possible values, 'date', 'doctor', psychometric. I need to evaluate Sum ('approved') of 'Doctor' and 'psychometric', so throw me the lowest value of each week of the two.

That is, if in week 9, I have:

process = 'Doctor' and approved = 50

process = 'psychometric' and approved = 55

and at week 10

process = 'Doctor' and approved = 30

process = 'psychometric' and approved = 25

Result of the sum

week:   9 = 50

week: 10 = 25

WEEK    PROCESS        APPROVED

9            Interview            60

9            MEDICAL          50

9            Psychometric     55

10          Interview            50

10          Medical              30

10          Psychometric     25

Necesito crear una gráfica de líneas, donde la 'dimension' será un campo 'semana', y la expresión será una suma de un campo llamado 'aprovados', con una condición,

comparar los campos,  proceso y aprobados, de los cuales, en proceso hay tres valores posibles, 'cita', 'medico', sicometrico. Necesito evaluar Sum('aprobados') de 'MEDICO' y 'SICOMETRICO', de modo que me arroje el valor menor de cada semana de estos dos.

Es decir, que si en la semana 9, tengo:

proceso = 'Medico' y aprobados=50

proceso='sicometrico' y aprobados=55

y en la semana 10

proceso = 'Medico' y aprobados=30

proceso='sicometrico' y aprobados=25

Resultado de la suma

semana:   9=50

semana: 10=25

WEEK    PROCESS        APPROVED

9            Interview            60

9            MEDICAL          50

9            Psychometric     55

10          Interview            50

10          Medical              30

10          Psychometric     25

1 Solution

Accepted Solutions
Not applicable

Try Like Below:

RangeMin( Sum({<PROCESS={"Medical"}>}APPROVED) , Sum({<PROCESS={"Psychometric"}>}APPROVED) )

Make sure that PROCESS have same type of values for each week.

View solution in original post

3 Replies
Not applicable

Try Like Below:

RangeMin( Sum({<PROCESS={"Medical"}>}APPROVED) , Sum({<PROCESS={"Psychometric"}>}APPROVED) )

Make sure that PROCESS have same type of values for each week.

Not applicable

Please find the attached qvw for reference.

erivera10
Creator
Creator
Author

Hi dathu.qv‌,

Thank you very much, it has served me very useful tool.

Best regards,

Erick Rivera Salamanca Erivera10