8 Replies Latest reply: May 6, 2014 3:48 PM by Deepak Vadithala RSS

    Syntax Qlikview

    Alessandra Coelho

      Hello,

      I'm new in QlikView .  Can you help me to adapt this SQL for QlikView?



      PEDIDOS FINALIZADOS
      :

      SELECT IPD_NUMPED FROM ITPEDIDOS

      WHERE IPD_CDEMP = 1

      AND IPD_TPPED = 'V'

      GROUP BY IPD_NUMPED

      HAVING SUM(IPD_BASE) > 0


      PEDIDO PENDENTE TOTAL (NENHUMA QUANTIDADE ENTREGUE)

      SELECT IPD_NUMPED FROM ITPEDIDOS

      WHERE IPD_CDEMP = 1

      AND IPD_TPPED = 'V'

      GROUP BY IPD_NUMPED

      HAVING SUM(IPD_QTDENT) =0 AND SUM(IPD_BASE) = 0


      Thanks.