4 Replies Latest reply: Aug 26, 2016 6:46 AM by Sunny Talwar RSS

    Making cross table in qliksense

    Mandar Sansare

      Hey ,

      As a requirement i have to work on this data for emergency purpose i did make some manual changes in file and completed my task.

      But i was wondering how to create cross table in qliksense?

       

        

      DateJan'15Feb'15Mar'15Apr'15
      Dealer Stock11041218996942
      Manufacturer Stock282721526829
      UnDanned cars >30 days-54-41-71-43
      1386193915221771

       

      This is Data as given

       

      What i made manually with given data is this:

          

      DateDealer StockManufacturer StockUnDanned cars >30 days
      Jan'151104282-54
      Feb'151218721-41
      Mar'15996526-71
      Apr'15942829-43

       

       

      I'm trying to do it through sense scripting, Any help will be appreciated.

      Also is it possible to make stacked bar chart with value on segments of given data points??