Hi All,
There is a script in my Qlik sense where I am trying to give relationship between Sales table and targets table based on User_ID, but it's forming circular loop how to reomve that. In front end I want to show revenueper user id as well as target per user id. Let me know if I'm doing anything wrong
[Currency]:
LOAD
Currency,
ExchangeRateToUSD
FROM [lib://DataFiles/Sales Data (1).xlsx]
(ooxml, embedded labels, table is Currency);
[Customers]:
LOAD
Customer_ID,
Customer_Name,
City,
Currency
FROM [lib://DataFiles/Sales Data (1).xlsx]
(ooxml, embedded labels, table is Customers);
[Products]:
LOAD
Product_ID,
Product_Name,
"Price ($)" as Price_USD,
Category
FROM [lib://DataFiles/Sales Data (1).xlsx]
(ooxml, embedded labels, table is Products);
[Sales Items]:
LOAD
Sale_ID,
"Line ID",
"Product ID" as Product_ID,
Qnt,
"Revenue (Customer's Currency)" as Revenue_Customer_Currency
FROM [lib://DataFiles/Sales Data (1).xlsx]
(ooxml, embedded labels, table is [Sales Items]);
[Sales]:
LOAD
Sale_ID,
"Customer ID" as Customer_ID,
"Sales Date" as Sales_Date,
"Owner ID (User ID)" as User_ID
FROM [lib://DataFiles/Sales Data (1).xlsx]
(ooxml, embedded labels, table is Sales);
[Targets]:
LOAD
"User ID" as User_ID,
"Target (User's Currency)" as Target_User_Currency
FROM [lib://DataFiles/Sales Data (1).xlsx]
(ooxml, embedded labels, table is Targets);
[Users]:
LOAD
User_ID,
User_Name,
Manager_ID,
Currency,
Created_date
FROM [lib://DataFiles/Sales Data (1).xlsx]
(ooxml, embedded labels, table is Users);
