Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
cristianj23a
Partner - Creator III
Partner - Creator III

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.

https://www.linkedin.com/in/cristianjorge/
Do not forget to mark as "Accepted Solution" the comment that resolves the doubt.
1 Solution

Accepted Solutions
techvarun
Specialist II
Specialist II

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

View solution in original post

2 Replies
Anil_Babu_Samineni

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
techvarun
Specialist II
Specialist II

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