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:





    FROM [lib://DailyOilPriceConn-WTI]

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




    I really appreciate your time in advance.