pareto chart with seperate value fields

[#1]

Hello,

I have the problem, that i am not sure how to make a pareto chart if i have seperate fields.

This means, i have in my database one line starting with the date and the shift of production and 20 different columns with the failure name and the sum of failure parts per date and shift for each of this errors.

what i want to get is similar to the next picture

hope someone can help me.

for a better understanding my load script looks like

LOAD

  productiondate,

  Week(productiondate) as productionweek,

  year(productiondate) as productionyear,

  month(productiondate) as productionmonth,

      shift,

     failure1,

     failure2,

     failure3,

     failure4,

     failure5,

     productionequipment

FROM

(ooxml, embedded labels, table is Qlikview);

[#2]

Hi. You could try loading your table as a cross table to bring all the sum of failure parts in one field and failure type as another field containing all the 20 types of failure and then making the pareto chart.

see this link on loading cross tables:

Loading Cross Tables

hope this helps!

[ramoncova06]

I think Sana idea could work