Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Dimension limit for a range between two values.

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

Tags (1)