pie chart

[avishaiz]

hi

i am trying to make a pie chat that will show the different defects on each month

on excell its easy all i have to do is select the data and create a pie chart...

i dont know how to do this on qliksense

can anyone help me on this?

[brunobertels]

Hi

You need to crosstable table your data during the load

see this link

https://community.qlik.com/blogs/qlikviewdesignblog/2014/03/24/crosstable

crosstable(Type,Value)

load

date,

leak,

size,

surface,

broken,

coating,

ingridiants,

etc,

non relevant

from ....

hope it helps

[Silambarasan1306]

Hi Avishai,

Use cross table to get the ans which u required,

get the below coding.

Code:

CrossTable(Status, Data)

LOAD date,

     leak,

     size,

     surface,

     broken,

     coating,

     ingridiants,

     etc,

     [non relevant]

FROM

(ooxml, embedded labels, table is [אי התאמות 2016]);

[avishaiz]

thank you

[avishaiz]

thank you

[Silambarasan1306]

Always Welcome..