Hello everyone,
I have a problem with a chart where the results are summed in a range of between 1 and 5000. However, I am only interested in the results that range between 5 and 15, and I want to filter out the rest.
The dimension limit only supports one range, however. As far as I can see. I can either set it to more than 5 or less than 15, not both.
Any idea how I can solve this?
I have attached my script below. Everything works fine except the red part which is one way that I tried to go around the issue by filtering out the lower values in the script as a test. I cannot seem to get RESIDENT to work, but that is probably due to my rather novice skills in QV.
The expression I use in the chart is =NetWorkDays([Last receive date],[Order date]). which gives me the desired result of receive date - order date.
ODBC CONNECT64 TO $(Machine);
LEADTIME:
LOAD
DDIS AS DISTRICT,
DNUM AS DEALER,
DNUM AS PART,
DREC AS RECEIVE,
date(date#(DREC,'YYYYMMDD'),'DD-MM-YYYY') as [Last receive date];
SQL SELECT *
FROM .Library.File
left join(LEADTIME)
Orders:
LOAD
PDIS AS DISTRICT,
PNUM AS DEALER,
PNUM AS PART,
PORD AS ORDERDATE,
date(date#(PORD,'YYYYMMDD'),'DD-MM-YYYY') as [Order date],
NetWorkDays([RECEIVE],[ORDERDATE]) AS [TEST]
Resident LEADTIME
Where Test > 0;
SQL SELECT *
FROM Library.file