Using Set Analisys to limit rows

[eduardo_dimperio]

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

[felipedl]

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_dimperio]

Hi Felip,

Can I open a qvw file on my Qlik Sense?

[vlad_komarov]

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 · Accepted solution]

Hi,

See the attached file for the Sense app !

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

[eduardo_dimperio]

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