topic Line Chart, different and multiple expression in QlikView

Line Chart, different and multiple expression

jose_vargas — Wed, 08 Feb 2017 15:58:34 GMT

Hello again community.

I attach a file, where i have 4 line chart in different graphics, each one have a different expression whit different variables.

I wanto to show in a 1 graph the 4 lines.

Any idea? what should i do?

Thanks

jayanttibhe — Wed, 08 Feb 2017 16:10:16 GMT

Check attached - You dont need the calculated Dim. Instead just use Set Analysis for the Expressions. PFA. Second TAB for the new chart.

sunny_talwar — Wed, 08 Feb 2017 16:11:07 GMT

One dimension with 4 expression?

kaushiknsolanki — Wed, 08 Feb 2017 16:27:08 GMT

Convert your expressions to below.

1. (Avg({<GrupoUsuarioEnvio = {"ANALISTA N2"}>}TiempoEnvio))

2.(AVG({<GrupoUsuarioRespuesta={"PEX"}>}TiempoRetorno))

3. (AVG({<GrupoUsuarioRespuesta={"OPERACIONES"}>}TiempoRetorno))

4.(Avg({<GrupoUsuarioEnvio={"ANALISTA N2"}>}Aggr(FirstSortedValue(TiempoConclusion, -Fecha_Respuesta), GrupoUsuarioEnvio, NumProcesso)))

Regards,

Kaushik Solanki

jose_vargas — Wed, 08 Feb 2017 16:29:05 GMT

Thanks to all users. I was used a stament "IF", because of that my chart was empty.

kaushiknsolanki — Wed, 08 Feb 2017 16:31:22 GMT

Always Prefer Set analysis over If statement. That will help you in improving the performance of your application.

Regards,

Kaushik Solanki