Single Filter for Multiple Non-Keyed Fields

toyokogyo12aturbo — Wed, 02 Jun 2021 20:26:23 GMT

Hello,
I have two Tables that I'm trying to apply a date filter at the same time, but the data sources are not linked (I'm trying to avoid a Cartesian Join). I'd like to be able to filter a single date field (or List Box) and have that filter applied to both Tables.

Thanks for your help. Shaun.

SHIPPED:
LOAD * INLINE [
ShipID, ShipPN, ShipDate
GJHL, C, 1/1/2020
WIJS, B, 3/1/2020
HNNI, A, 1/1/2020
RCMR, B, 2/1/2020
YNRQ, C, 3/1/2020
DDOQ, C, 1/1/2020
QUNS, B, 2/1/2020
KXWO, B, 1/1/2020
VSPB, A, 1/1/2020
TUDR, A, 3/1/2020
SSMT, A, 1/1/2020
YZUW, B, 1/1/2020
DSQQ, A, 1/1/2020
YJTA, B, 3/1/2020
EEQS, A, 3/1/2020
JMGH, C, 2/1/2020
FJXW, C, 3/1/2020
YVJH, B, 3/1/2020
RJVH, C, 1/1/2020
WEAK, C, 3/1/2020
GUTT, C, 2/1/2020
OOOF, C, 2/1/2020
CZTN, A, 2/1/2020
QSHF, C, 3/1/2020
DOWN, A, 2/1/2020
WKXI, C, 1/1/2020
HFSE, B, 2/1/2020
];

SOLD:
LOAD * INLINE [
SoldPN, SoldQty, SoldDate
A, 5, 1/1/2020
B, 10, 2/1/2020
A, 8, 1/1/2020
B, 7, 1/1/2020
C, 9, 3/1/2020
C, 5, 3/1/2020
C, 5, 3/1/2020
B, 9, 1/1/2020
B, 7, 2/1/2020
C, 9, 2/1/2020
C, 10, 1/1/2020
C, 10, 3/1/2020
B, 9, 3/1/2020
C, 10, 3/1/2020
B, 10, 1/1/2020
A, 10, 1/1/2020
A, 8, 1/1/2020
C, 9, 2/1/2020
C, 10, 1/1/2020
C, 8, 3/1/2020
B, 6, 3/1/2020
C, 5, 1/1/2020
A, 10, 1/1/2020
C, 10, 2/1/2020
C, 7, 1/1/2020
C, 5, 3/1/2020
A, 6, 3/1/2020
];

Re: Single Filter for Multiple Non-Keyed Fields

jwjackso — Wed, 02 Jun 2021 21:44:18 GMT

Create a calendar from your data:

TempCalendar:
LOAD ShipDate as [Date]
Resident SHIPPED;
Concatenate
LOAD SoldDate as [Date]
Resident SOLD;

Calendar:
LOAD [Date]
,[Date] as ShipDate
,[Date] as SoldDate;
LOAD Distinct [Date]
Resident TempCalendar;

DROP Table TempCalendar;

topic Single Filter for Multiple Non-Keyed Fields in QlikView

Single Filter for Multiple Non-Keyed Fields

Re: Single Filter for Multiple Non-Keyed Fields