unique values into another table

[#1]

Hi everyone,

I'm new to qlikview and I'm struggling with a relatively easy problem.

I have the following chunk of my table.

RowNo	X	Y
1	11	12
2	11	12
3	22	8
4	22	8
5	22	8
6	33	4
7	22	8
8	22	8
9	11	12
10	11	12
11	55	2

I have to do 2 things here:

1- I would like extract from this table, the unique values and get the following table:

X	Y
11	12
22	8
33	4
55	2

How can I do this? I tried to use distinct, but it is not giving me what I want

2- From the new table, I want to create a simple histogram. I guess I should use X as dimension and Y as expression right?

I think I still miss the idea of how qlikview treats dimensions and expressions, can someone guide me to a documentation where this is well explained. Thank you

[#2]

ok this works now, thanks.

How can I add a new column to the NEW table, which represent the frequency of each value of X in the ORIGINAL table?

[tresesco · Accepted solution]

Straight table:

Dim1:X

Dim2:Y                    // you might or might not need this

Exp1: Count(X)