3 Replies Latest reply: Apr 15, 2017 1:21 PM by Agnaldo Neves RSS

    City with sale and no sales in LOAD

    Agnaldo Neves

      Create filter

      City store yes, no

       

       

       

      IF NomeMunicipio > VLR_ITEM_FATURAR_TOTAL, 1)  AS Yes

      IF NomeMunicipio =NULL(VLR_ITEM_FATURAR_TOTAL),0)  AS NO

       

       

      I do not know the best way to do this filter?

      2017-04-15_09-48-12.png

       

       

       

      Store:
      LOAD
                       
           Num(Replace(VLR_ITEM, '.', ','))           AS     VLR_ITEM_FATURAR_TOTAL,
           CIDADE                                     AS     NomeMunicipio
      
      FROM [C:\Geral\qvd\QPD_01.qvd] (qvd)
      Where DATA_PEDIDOX >= '2017-01-01';
      
      
      City:
      LOAD ID,
           UF,
           NomeMunicipio,
           NomeMunicipio&' - '&UF as [Mun/UF]
      FROM
      C:\Geral\qvd\mapa\*_Atributos.qvd
      (qvd);