Table with X and Y dimmensions

[razvan_brais]

Hey guys , can you please tell me if there is a table where I can have two dimmensions. One as X axis and the other as Y.

What I`m trying to do is something like in this table

ID	CURRENCY	TABLE1	TABLE2	TABLE3
1	EUR	2	5	1
2	USD	3	6	9

So for the first dimmension is ID which will be treated as X axis , and The rest of Headers will be treated as Y axes. Can I do that in qlikview?

Thank you,

Razvan

[MK_QSL]

Use Pivot Table

or

Use Straight table with more than one Expression

[razvan_brais]

Ok , but the problem here is that EUR and USD are columns from table1 , table2 , and table3. I don`t have a column named currency in which I have EUR and USD values.

[MK_QSL · Accepted solution]

Better you provide few lines of sample data to work.

You can use Valuelist function to get the Currency Column

[razvan_brais]

Thank you. I used Syntetic dimensions and it worked.