I am having some trouble with data selections in Qlik sense desktop.
First of all, is there a comprehensive overview for all functions? The Qlik Help seems a little obscure to me.
One of my problem is, I want to show values in a diagram where a corresponding value is unique. e.g.
a x a x
a x b y
b y c y
b y ->
So I want to filter for distinct values in Col1 (which I can do by DISTINCT) but I want to show the frequency of the values in Col2.
which would be x=1, y=2
Is there maybe something like Rs  selector in Qlik Sense?
I am glad for any input.
Here's a script and function guide Marco
thanks for your suggestion but that is not quite what I meant. Maybe I did not put my question clear enough.
I want to aggregate over all values. In my example you can treat the rows with the same values as duplicates and I want to have the count of x and y after removing the duplicates based on col1.
So the result would be x=1, because only a has the value x and y=2 because (ignoring duplicates) b and c have the value y.