topic Re: Combined Chart in QlikView

Combined Chart

cristianj23a — Wed, 02 Aug 2017 21:52:26 GMT

Hello, the lines are not appearing in my combined graph.

I have created 3 variables.

vMaxDia: In this variable I get the number of days of the last selected month.

vMaxMes: In this variable I get the last month of the selected year

vMaxAño: In this variable I get the maximum year selected.

When I select a material, the dot with the exact value appears, but when I remove the filter the lines disappear.

I was analyzing the code and identify the cause of the inconvenience, but I can not think of any other way to enter the logic, the objective is to have the line graph for each material.

Should have a graphic similar to the image below.

I attached Excel and QVD

Please help me with this topic.

Greetings.

Re: Combined Chart

Anil_Babu_Samineni — Thu, 03 Aug 2017 02:32:47 GMT

I don't think so problem is with Variables. I assume, For that year and month you may don't have data points. Could be the reason is that

Will you try this? and check in real application

Sum(Aggr((fabs(sum({<[MSEG.Clase de movimiento_BWART]={'201','221','261'},[Año EM]={'2017'},[Mes EM]={'May.'}>}MSEG.Cantidad_MENGE))/

$(vMaxDia))

(

90//$(vClMov)

($(vMaxDia)/

(fabs(sum({<[MSEG.Clase de movimiento_BWART]={'201','221','261'},[Año EM]={'2017'},[Mes EM]={'May.'}>}MSEG.Cantidad_MENGE))

FirstSortedValue(Aggr(Avg(Aggr(RangeSum(Above(Sum({$<[Año EM],[Mes EM]>} MSEG.Cantidad_MENGE), 0, RowNo())),

[Material EM], ([Fecha EM], (NUMERIC)))), [Mes EM], [Año EM]),-Aggr([Mes EM] + ([Año EM]*100), [Mes EM], [Año EM])))))

,[Material EM],[Mes EM],[Año EM]))

Re: Combined Chart

techvarun — Thu, 03 Aug 2017 04:44:50 GMT

for 2017 May. your numerator returns 0 that's the reason the line is not showing up.