Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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]);
thank you
thank you
Always Welcome..