Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
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.
Col1 Col2
a x a x
a x b y
b y c y
b y ->
b y
c y
c 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.
Like this?
=Col2&' ='&aggr(Count(Col2),Col1)
Here's a script and function guide Marco
https://help.qlik.com/en-US/sense/1.1/pdf/Script%20Syntax%20and%20Chart%20Functions%20Guide.pdf
Ben
Hi Marco,
Try this Expression Also,
-->>=Col2 &'='&count( Col2)
Output:
Thank's & Regards,
Sumit Jadhav.
Thanks Ben,
this is really helpful.
Hey Omar,
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.
I see, change it as follow then:
=Col2&' ='&aggr(Count (distinct Col1),Col2)