4 Replies Latest reply: Apr 21, 2017 2:33 PM by Alexander Gorski RSS

    How best to build a stacked bar chart from this data?

    Alexander Gorski

      I currently have indicators across 3 different fields and want to look at the best way to build a stacked bar chart from this data. More specifically I want to understand if transforming the data I pull back is the only option or is there a way to solve this in Qlik charting.

       

      Here is the data in the database format:

         

      IDEMAILABLE_INDICCALLABLE_INDICBAD_ADDRESS_INDIC
      1YNY
      2NNY
      3YYN
      4NNN

       

      Here is what I transformed it to in the data load script to load into the stacked bar chart:

       

      IDYES_NO_FLAGGROUPING
      1YEMAIL
      2NEMAIL
      3YEMAIL
      4NEMAIL
      1NADD
      2NADD
      3YADD
      4NADD
      1YCALL
      2YCALL
      3NCALL
      4NCALL

       

       

      Here was the final result:

      Yes_no.PNG