Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Together,
I have a table loaded from my database and want to Show a Count of a value in a bar Chart. Now i will Change the x achsis dynamically.
Therefore I loaded this:
LOAD * INLINE [
AreaScale3 RegionDrill_ID3
Countries; Country
Regions; Region
Products; Product
] (delimiter is ';')
Country, Region and Product exist in my other table.
Now my Question: How can I link this Values to my other table?
Thanks in advance
Mathias
Can somebody help?
You would link them by the name that you gave the columns in your inline table. If they match a field in another table then they will associate by default.
Thats what I did. But my bar Chart interprets Country, Region, Product as a String and there is no assiciation with the coumns from my other table.
Please post a sample of your app
[DATA]:
LOAD
[ADR_CITY],
[ADR_COUNTRY_CODE],
[ADR_NAME1],
[ADR_NAME2],
[ADR_NAME3],
[ADR_STREET1],
[ADR_STREET2],
[ADR_ZIPCODE],
[AMOUNT];
SQL SELECT "ADR_ADDITIONAL1",
"ADR_CITY",
"ADR_COUNTRY_CODE",
"ADR_NAME1",
"ADR_NAME2",
"ADR_NAME3",
"ADR_STREET1",
"ADR_STREET2",
"ADR_ZIPCODE",
"AMOUNT",
...
FROM "DB"."TABLE";
Then I do:
LOAD * INLINE [
AreaScale; RegionDIM
Name;ADR_NAME1 <<< This must associate with columns from Table DATA
Zipcode; ADR_ZIPCODE
Country; ADR_COUNTRY_CODE
] (delimiter is ';')
Then I create a bar chart and as Dimension I use RegionDIM. The measure sum(AMOUNT) is once grouped by ADR_NAME1, another time by ZIPCode and so on.
I cant use a drill dimension because i want to change the x axis dynamically.