Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
See the attached file for the Sense app !
Just copy the app to the C:\Users\{User}\Documents\Qlik\Sense\Apps folder.
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.
Hi Felip,
Can I open a qvw file on my Qlik Sense?
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
Hi,
See the attached file for the Sense app !
Just copy the app to the C:\Users\{User}\Documents\Qlik\Sense\Apps folder.
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