Discussion board where members can get started with Qlik Sense.
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 [
] (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
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
SQL SELECT "ADR_ADDITIONAL1",
Then I do:
Name;ADR_NAME1 <<< This must associate with columns from Table DATA
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.