Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Partner
Partner

Select in Qlik

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?

2 Replies
Highlighted
Partner
Partner

Re: Select in Qlik

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
Valued Contributor III

Re: Select in Qlik

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

Channa