topic pareto chart with seperate value fields in QlikView

pareto chart with seperate value fields

Thu, 23 Apr 2015 17:51:30 GMT

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

Re: pareto chart with seperate value fields

Fri, 24 Apr 2015 02:51:18 GMT

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!

Re: pareto chart with seperate value fields

ramoncova06 — Fri, 24 Apr 2015 02:54:36 GMT

I think Sana idea could work