mytestCSV.csv

    QlikSense is a new BI tool to us and i am loading data from a web file then wish to do the following:

     

    - Show data that arrived between yesterday & now. [This data will be from the Settle Column of the file i attached)

        From the File I attached:  Take 6/11/2015 as yesterday but we know that yesterday will always change as new data comes.

    -Show data that are available for the last 30days & now.  [This data will also be from the Settle column of the file i attached]

     

    Look at how my data is loaded:

     

    LOAD

        "Date",

        Settle

    FROM [lib://DailyOilPriceConn-WTI]

    (txt, codepage is 1252, embedded labels, delimiter is ',', msq);

     

     

     

    I really appreciate your time in advance.

    Thanks.