Select in Qlik

[RaulSouza]

Look at them all. Well I'm starting at qlik sense and I would like to know the following. The user wants me to create a table and for this I passed a select command to pull the required data.

SELECT NVL (SUM (m.value_total_measured), 0)

FROM dhxtb053_medical INNER JOIN dhxtb031_obra_servico o ON o.iden_obra_servico = m.iden_obra_servico

FROM m.flag_situation = 'ACTIVE' AND m.flag_tipo_medicao = 'MEDICAO_PRECO_INICIAL'

AND o.iden_contrato = c.iden_contrato) AS initial_preaction_value

how would I do that select in qlik?

[martinpohl]

That's not Qlik.

In Qlik you select all datas into your application.

Then the user select values and if there is a new question, selections dropped and a new search begins. Without a new oad of data because databases are too slow to load.

QLIK and enjoy!

[Channa]

SELECT NVL (SUM (m.value_total_measured), 0) as initial_preaction_value

FROM dhxtb053_medical INNER JOIN dhxtb031_obra_servico o ON o.iden_obra_servico = m.iden_obra_servico

FROM m.flag_situation = 'ACTIVE' AND m.flag_tipo_medicao = 'MEDICAO_PRECO_INICIAL'

AND o.iden_contrato = c.iden_contrato