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
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.
