4 Replies Latest reply: Jan 10, 2018 10:46 PM by Justin Pham

# [Help] Pic Chart in Qlik Sense..

Sorry for basic question..

• ###### Re: [Help] Pic Chart in Qlik Sense..

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

CrossTable (Cat,Sales,2)

CorevalueB,

CorevalueC,

CorevalueD

FROM  table;

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

sum(Sales)/sum(Total Sales)

• ###### Re: [Help] Pic Chart in Qlik Sense..

sorry i can't do that

Could you check it ??

• ###### Re: [Help] Pic Chart in Qlik Sense..

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)

))))

• ###### Re: [Help] Pic Chart in Qlik Sense..

Hi 정훈 최,

Try like this

```CrossTable(TypeCode, Value, 2)
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.