Problem in date function

    Hi,

     

    I have uploaded two files in Qlikview one is for price & another one is for some discount.

    In both the table i have made crosstable.but date is coming as text .to convert it in date format i have used following expression

     

    Directory;

    CROSSTABLE(Date, GP, 4)

    LOAD AO,

        Date#(Date,'DD.MM.YYYY') as Date1

        Cnty,

      County,

      [01.02.2016],

      [02.02.2016]

      FROM Billing_022016.xlsx (ooxml, embedded labels, table is Sheet1);

     

     

    But getting some file not found error.

     

    pls  help

    Trapti

    Pricing.qvw (131.9 K) Download