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

    [Help] Pic Chart in Qlik Sense..

    정훈 최

      Sorry for basic question..

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

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

          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)

            • Re: [Help] Pic Chart in Qlik Sense..
              정훈 최

              sorry i can't do that

              Could you check it ??

              2.png

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

                  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

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

                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.