[Help] Pic Chart in Qlik Sense..

[Anonymous]

Sorry for basic question..

Could you please check it and answer to me.. Please

[devarasu07]

Hi,

try like this,

method 1:

measure 1

sum(CorevalueA)/sum(CorevalueA)+sum(CorevalueB)+sum(CorevalueC)+sum(CorevalueD)

measure 1

sum(CorevalueB)/sum(CorevalueA)+sum(CorevalueB)+sum(CorevalueC)+sum(CorevalueD)

similarly other 2 measure

method 2: try to load cross table load (best approach)

CrossTable (Cat,Sales,2)

LOAD CorevalueA,

     CorevalueB,

     CorevalueC,

     CorevalueD

FROM  table;

and create pivot table then add Cat as Dimension and measure like below

sum(Sales)/sum(Total Sales)

[Anonymous]

sorry i can't do that

Could you check it ??

[devarasu07]

Hi,

try to use synthetic dimension

Dimension:

=ValueList('CorevalueA','CorevalueB','CorevalueC','CorevalueD')

Measure:

=if( ValueList('CorevalueA','CorevalueB','CorevalueC','CorevalueD')='CorevalueA',sum(CorevalueA)/sum(total CorevalueA +CorevalueB+CorevalueC +CorevalueD),

if(ValueList('CorevalueA','CorevalueB','CorevalueC','CorevalueD')='CorevalueB',sum(CorevalueB)/sum(total CorevalueA +CorevalueB+CorevalueC +CorevalueD),

if(ValueList('CorevalueA','CorevalueB','CorevalueC','CorevalueD')='CorevalueC',sum(CorevalueB)/sum(total CorevalueA +CorevalueB+CorevalueC +CorevalueD),

if(ValueList('CorevalueA','CorevalueB','CorevalueC','CorevalueD')='CorevalueD',sum(CorevalueB)/sum(total CorevalueA +CorevalueB+CorevalueC +CorevalueD)

))))

[justinphamvn]

Hi 정훈 최,

Try like this

Script Load :

CrossTable(TypeCode, Value, 2)
LOAD
    surveyNo,
    "Age",
    CorevalueA,
    CorevalueB,
    CorevalueC,
    CorevalueD
FROM [lib://Connect/SurveySummary.xlsx]
(ooxml, embedded labels, table is arrangetable);

Chart Funtion

Dimension : TypeCode

Measure : Sum(Value)

This is look like the picture below

Regards,

Justin.