Filtrando DATA

[Anonymous]

Bom dia pessoal !

Estou tentando realizar um filtro em minha carga, porém sem sucesso...

Vamos lá,

Eu tenho um campo que contém, um "array" fazendo a contagem de quanto tempo meu serviço ficou online.

Esse é a estrutura do campo:

["07:20:00","07:30:00","07:40:00","07:50:00","08:00:00","08:10:00","08:20:00","08:30:00","08:40:00","08:50:00","09:00:00","09:10:00","09:20:00","09:30:00","09:40:00","09:50:00","13:40:00","13:50:00","14:00:00"]

["06:20:00","06:30:00","06:40:00","06:50:00","07:00:00","07:10:00","07:20:00","07:30:00","07:40:00","07:50:00","08:00:00","08:10:00","08:20:00","08:30:00","08:40:00","08:50:00","09:00:00","09:10:00","09:20:00","09:30:00","09:40:00","09:50:00","10:00:00","10:10:00","10:20:00","10:40:00","10:50:00","11:10:00","11:20:00","12:00:00","12:10:00","12:20:00","12:30:00","12:40:00","12:50:00","13:10:00","13:20:00","13:30:00","13:40:00","13:50:00","14:00:00"]

["09:30:00"]

["09:20:00","12:20:00","12:30:00","12:40:00","12:50:00","13:00:00","13:10:00","13:20:00","13:30:00"]

Preciso que na carga se existir o valor "10:30:00" na linha ele guarde esse valor em um novo campo, se não existir o valor no campo é nulo.

Espero ter conseguido explicar.

Obrigado.

Abraços.

[fernando_tonial · Accepted solution]

Olá Matheus,

Você pode utiliza a função Index().

If(Index(Campo,'10:30:00'),'10:30:00',Null()) AS CampoNovo

Qlikfique-se.

Tonial.