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)
Solved! Go to Solution.
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:
See if the example meets your need.
You can use a QlkiView to QS converter available in the QS 3.2 release:
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