Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
While creating maps not able find the dimesnsions
Can any one help me how to create maps in qliksense
I think this is the updated version of Qlik Sense out of box maps.
For line layer maps you'd need 2 dimensions...
To location and From location
Check this video below
@ 02:24 mins
https://www.youtube.com/watch?v=CSPCNfnIMp8
If still doesn;t work, provide us with a sample xl file data and we can try..
Can you post your map script?
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
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);
I think this is the updated version of Qlik Sense out of box maps.
For line layer maps you'd need 2 dimensions...
To location and From location
Check this video below
@ 02:24 mins
https://www.youtube.com/watch?v=CSPCNfnIMp8
If still doesn;t work, provide us with a sample xl file data and we can try..