4 Replies Latest reply: Feb 22, 2017 5:21 AM by Adam Ginza RSS

    Create combo chart from pivot table.

    Adam Ginza

      Dear Qlikview Masters,

       

      Greetings.

       

      I have a Pivot Table which consists of 2 similar Expressions. The only difference is in one of the set analysis.

      The first expression has FACT_SKU = 'SPPD', and the other one has FACT_SKU = 'ND %' in it.

      Here is the sample screen shot of my pivot table.

      Pivot Table sample.PNG

      My goal is to create a combo chart which looks similar to this.

      Combo1.PNG

       

      I have tried to convert my previously shown pivot table into a combo chart. However, it just didn't look like the same.

      Here's my converted pivot table into combo chart.

      Result Combo Chart.PNG

       

      Where did I do wrong?

      If making the combo chart that looks exactly the same as the sample chart is impossible, is there any workaround I can do?

      Please find the attached QVW as the sample.

       

      This issue has been bugging me for the last 2 days.

      Any kind of help would be much appreciated.

       

      Thanks in advance.

       

      Regards,

      Adam Ginza