5 Replies Latest reply: Aug 26, 2016 11:50 AM by Phaneendra Kunche RSS

    Cross table help in QlikSense

    SENTHIL KUMAR MUNIYAPPAN

      Hello,

       

      This is from a person new to Qlik. Now I am in the process of learning QlikSense.

       

      I need your expert help in generating two separate bar charts using the qualifiers 'Year' and 'Country'.  Product A to E are the attribute fields with 'Sales' data.

       

      - how do I load this data using 'data load editor' or ?

      - and, what should be the script?

       

      Kindly help.

       

      Regards,

      MSK

       

      Source Excel File:

         

      YearCountryProduct AProduct BProduct CProduct DProduct E
      2015Colombia13541683169317691060
      2015Egypt19101455153210131848
      2015Georgia13411308142516711928
      2015Greece16911203126211271568
      2015Guinea-Buissau16541867108513861129

       

       

      Output sample based on Year: