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
