Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

eduardo_dimperi
Valued Contributor II

Using Set Analisys to limit rows

Hi !

I need to show only rows where the AVG  are <-90 and The distance of Distancia_Torre_Ativa> Distancia_Torre_Inativa

So, if i use 'IF' on the measure, i get AVG(SIGNAL) or '-' and i can't eliminate '-' because it's a measure and QS doesn't give the option 'not show null' to measures and i can't either use in the dimension because is an agregation.

How can i do to show only the rows that satisfy this condition?

Avg(SIGNAL)<-90 AND Min(Distancia_Torre_Ativa)>Min(Distancia_Torre_Inativa)


Thank you

Tags (1)
1 Solution

Accepted Solutions
felipedl
Valued Contributor III

Re: Using Set Analisys to limit rows

Hi,

See the attached file for the Sense app !

Just copy the app to the C:\Users\{User}\Documents\Qlik\Sense\Apps folder.

5 Replies
felipedl
Valued Contributor III

Re: Using Set Analisys to limit rows

Hi Eduardo,

I've built a sample file for you to play around since I have no sample data to test it with.

The condition Distancia_Torre_Ativa> Distancia_Torre_Inativa was tested on the  load statement as a flag to consider [Flag Consider] or not on the expression.


The set analysis is the following:


avg({<SIGNAL={"<=$(=-90)"},[Flag Consider]={1}>}SIGNAL)


See if the example meets your need.


Felipe.

eduardo_dimperi
Valued Contributor II

Re: Using Set Analisys to limit rows

Hi Felip,

Can I open a qvw file on my Qlik Sense?

vlad_komarov
Valued Contributor III

Re: Using Set Analisys to limit rows

Eduardo,

You can use a QlkiView to QS converter available in the QS 3.2 release:

https://help.qlik.com/en-US/sense/3.2/Subsystems/Hub/Content/LoadData/create-app-from-document.htm

Regards,

Vlad

felipedl
Valued Contributor III

Re: Using Set Analisys to limit rows

Hi,

See the attached file for the Sense app !

Just copy the app to the C:\Users\{User}\Documents\Qlik\Sense\Apps folder.

eduardo_dimperi
Valued Contributor II

Re: Using Set Analisys to limit rows

Felip, Thank you so much for your help. Now i understant what i was doing wrong.

Because i had other fields, even if filters the null values it always be there. So i did like your example and keeped only 1 dimension and 1 measure.

Again, thank you