Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

choijunghoon
New Contributor

[Help] Pic Chart in Qlik Sense..

Sorry for basic question..

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

4 Replies
devarasu07
Honored Contributor II

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


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)

choijunghoon
New Contributor

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

sorry i can't do that

Could you check it ??

2.png

devarasu07
Honored Contributor II

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)

))))

Capture.JPG

justinphamvn
Contributor II

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

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

Survey.png

Regards,

Justin.

Community Browser