Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Is there a technique to use set analysis to compare dates - loaded from QVD files?
I load the QVD data using the following script:
LOAD
filename() as FileName,
date(date#(mid(filename(), 12, 10), 'DD-MM-YYYY'), 'DD-MM-YYYY') as OrderDate,
**
FROM
[...Qlik Historic\Bookmaster_*.QVD]
(qvd);
My first formula I wrote is: sum({$<OrderDate={"04-05-2018"}>}[Loan Value(USD)]) - this is not working
Ideally I want to get to a point where the date is 'Today()-7' so that the data constantly rolls everyday.
Is this feasible?
Your assistance is much appreciated
{"$(=Date(Today()-5,'DD/MM/YYYY'))"}
May be try
sum({$<OrderDate={"$(=MakeDate(2018,5,4))"}>}[Loan Value(USD)])
what format of date do you see if you put OrderDate Field in a list box? number? or text
Hi Sasidhar,
That is great and has rectified my first set analysis question!
The OrderDate field is DD/MM/YYYY - which now explains why my original formula was not working with DD-MM-YYYY!
Do you know of a method of not specifying a date but adding "today()-5" for example?
{"$(=Date(Today()-5,'DD/MM/YYYY'))"}