Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Partner
Partner

Combined Chart

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

Captura3.PNG

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.

Captura5.PNG

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.

Captura4.PNG

Should have a graphic similar to the image below.

Captura2.PNG

I attached Excel and QVD

Please help me with this topic.

Greetings.

1 Solution

Accepted Solutions
techvarun
Valued Contributor II

Re: Combined Chart

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

2 Replies

Re: Combined Chart

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]))

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
techvarun
Valued Contributor II

Re: Combined Chart

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