Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

avishaiz
New Contributor II

pie chart

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?

Tags (2)
5 Replies
brunobertels
Valued Contributor

Re: pie chart

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

silambarasan130
Contributor II

Re: pie chart

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
New Contributor II

Re: pie chart

thank you

avishaiz
New Contributor II

Re: pie chart

thank you

silambarasan130
Contributor II

Re: pie chart

Always Welcome..

Community Browser