Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
rohi__
Contributor III
Contributor III

Multiple Line Chart to detect an outlier in the data

Hello, everyone,
I would like to display two graphs with the following data structure.

OrderMaterialProductgroupOpLeadTimeMonthYear
133component102June 2020
133component203June 2020
133component305June 2020
225component101June 2020
225component203June 2020
225component302June 2020
333component108July 2020
333component209July 2020
333component307July 2020
425component102July 2020
425component208July 2020
425component306July 2020


The first would be the average of the product group over time.
The second would be the average of the individual material numbers over time.
I will use the following formula for the average of the product groups.

 

sum(aggr(avg(LeadTime), Op, Productgroup, MonthYear))

 

 

teszt.PNG

how can I use this formula to display material numbers? I want to see many individual lines. The following approach was not working.

 

sum(aggr(avg(LeadTime), Op, Material, MonthYear))

 

I want to get something like this:

ui_gen_LineChart

Thanks in advance!

 
Labels (4)
0 Replies