Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mrchmchr
New Contributor II

Select Values by condition in Qlik Sense

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.

Tags (2)
6 Replies
omarbensalem
Esteemed Contributor

Re: Select Values by condition in Qlik Sense

Like this?

=Col2&' ='&aggr(Count(Col2),Col1)

Capture.PNG

Not applicable

Re: Select Values by condition in Qlik Sense

sumitjadhav
Contributor II

Re: Select Values by condition in Qlik Sense

Hi Marco,

Try this Expression Also,

-->>=Col2 &'='&count( Col2)

Output:

output111.JPG

Thank's & Regards,

Sumit Jadhav.

mrchmchr
New Contributor II

Re: Select Values by condition in Qlik Sense

Thanks Ben,

this is really helpful.

mrchmchr
New Contributor II

Re: Select Values by condition in Qlik Sense

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.

omarbensalem
Esteemed Contributor

Re: Select Values by condition in Qlik Sense

I see, change it as follow then:

=Col2&' ='&aggr(Count (distinct Col1),Col2)

Capture.PNG