Hello @FelipeMendes and thank you for your post!
Question:[EN]
if the occurrence is > 1 hour put 1 if not 0
I'm having trouble getting a specific result
example :
I want the number 1 to be placed every time the NRS_VINC+ASSOC>0 and have the travel time greater than 1 hour if not 0.
however, the way I did this is disregarding if the displacement time is greater than 1 hour
I'm still new to qlik and I don't understand metrics very well.
IF(SUM(TOTAL_NRS_VINC+TOTAL_NRS_ASSOC)>0 and (min(timestamp(DATE_ARRIVAL_2))-min(timestamp(DATA_ACION_2))*24)>1,1,0)
another help would be how to put a condition in which the vehicle travel time is greater than 1 hour put 1 if not 0.
travel time field " min(timestamp(DATE_ARRIVAL_2))-min(timestamp(DATA_ACION_2)) "
Solution:[PT-BR]
Bom, eu acredito que seja possível alcançar o resultado desejado usando um if. Ficaria mais ou menos algo desse jeito:
if(Sum([field 1])+Sum([field 2])>0,1,0)
Ou seja, sempre que NRS_VINC+ASSOC>0 então1, senão 0. A função if admite três parâmetros if(condição, então,senão ) e observe que as três foram usadas no exemplo acima.
Para maiores informações sobre o uso do if da uma olhada aqui (https://help.qlik.com/en-US/sense/June2020/Subsystems/Hub/Content/Sense_Hub/Scripting/ConditionalFun...).
Solution:[EN]
I believe that what you're trying to achieve can be done by suing a simple if. It would be something like this:
if(Sum([field 1])+Sum([field 2])>0,1,0)
In other words, every time NRS_VINC+ASSOC>0 then1, else 0. The if function has three parameters if(condition, then and else) and notice that they have all been used in the example above.
For further information regarding the correct use if have a look here (https://help.qlik.com/en-US/sense/June2020/Subsystems/Hub/Content/Sense_Hub/Scripting/ConditionalFun...).
