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:
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
I really appreciate your time in advance.