Dimension limit for a range between two values.

Anonymous — Tue, 24 Oct 2017 12:55:27 GMT

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

topic Dimension limit for a range between two values. in QlikView

Dimension limit for a range between two values.