4 Replies Latest reply: Aug 7, 2018 10:56 AM by Shahbaz Khan Mohammed RSS

    Re:Qliksense Maps

    vijay kumar

      Hi all,

       

      While creating maps not able find the dimesnsions

      Can any one help me how to create maps in qliksense

        • Re:Qliksense Maps
          Shahbaz Khan Mohammed

          Can you post your map script?

            • Re:Qliksense Maps
              vijay kumar

              hi,

               

              [StoreLocations]:

              LOAD

              [LocationId] AS [ProductId-LocationId],

              [LocationType],

              [LocationName],

              GeoMakePoint([Latitude],[Longitude]) as [Location],

              [City],

              [StateProvince],

              [Country]

              FROM [lib://Section 4 - Sales Analysis/SalesDimensions.xlsx]

              (ooxml, embedded labels, table is StoreLocations);

               

              this one is the script

               

              Thanks,

              vijay

                • Re:Qliksense Maps
                  vijay kumar

                  hi,

                  [Products]:

                  LOAD

                  //[ProductId] AS [ProductId-LocationId],

                       [ProductId],

                  [ProductName],

                  [ProductDescription],

                  [ProductSubcategoryId],

                  [Manufacturer],

                  [BrandName],

                  [Colour],

                  [Cost],

                  [RetailPrice]

                  FROM [lib://Section 4 - Sales Analysis/SalesDimensions.xlsx]

                  (ooxml, embedded labels, table is Products);

                   

                   

                  [ProductCategory]:

                  LOAD

                  [ProductCategoryId],

                  [ProductCategoryName]

                  FROM [lib://Section 4 - Sales Analysis/SalesDimensions.xlsx]

                  (ooxml, embedded labels, table is ProductCategory);

                   

                   

                  [ProductSubCategory]:

                  LOAD

                  [ProductCategoryId],

                  [ProductSubcategoryId],

                  [ProductSubcategoryName]

                  FROM [lib://Section 4 - Sales Analysis/SalesDimensions.xlsx]

                  (ooxml, embedded labels, table is ProductSubCategory);

                   

                   

                  [StoreLocations]:

                  LOAD

                  [LocationId] AS [ProductId-LocationId],

                  [LocationType],

                  [LocationName],

                  GeoMakePoint([Latitude],[Longitude]) as [Location],

                  [City],

                  [StateProvince],

                  [Country]

                  FROM [lib://Section 4 - Sales Analysis/SalesDimensions.xlsx]

                  (ooxml, embedded labels, table is StoreLocations);