3 Replies Latest reply: Oct 20, 2016 2:20 AM by Josephinet Tedesco RSS

    Will "where" work  in the QVD file - it does work in the SQL

    Josephinet Tedesco

      Hi all

      I think my syntax might need tweaking:

      The SQL syntax works beautifully

        FROM [dbo].[xxx]

        where Sts like '%1%'

        and [App_DtTm] >= '2016-09-01 00:00:00'

        and (y= 9 or y= 14 or y= 16)

       

       

      I then try to use QVD file tht has been created:

      From  QVD\SLU.qvd  (qvd)

      WHERE

      Sts like '%1%'

      and [App_DtTm2] >= 42614

      and (y= 9 or y= 14 or y= 16)

      ;

      Changing the conditions it seems that Qlikview does not like Sts like '%1%' - What is the correct syntax for Qlikview please?

      Jo