topic Re: Create From and To Filters from same field in QlikView

Create From and To Filters from fields

qlikwiz123 — Wed, 25 Nov 2020 16:16:04 GMT

I have two Fields that has Countries.

I need to create two Filters (Dropdown boxes)

Source and Destination. How can I create two different List boxes from the these tables such that

1. If I select California in Source, it shouldn't show up in Destination List Box.

2. Also, how can I create One-way and Round trip Radio Buttons and if it is 'Round Trip', it should show Source and Destination Twice based on initial Source-Destination selections?

Example:

California to Floria - Roundtrip

Source Destination

California Florida

Source Destination

Florida California

Re: Create From and To Filters from same field

dena_reavis — Thu, 20 Aug 2020 20:19:35 GMT

If your source and destination are fields on the same record, you would be able to select source as CA in a list box and the other listbox will reduce to only those records that have FL. Here is some sample data. It might be a bit more involved if your field value on your real data is all in one field, but you could pull it apart using SubField, and if source and destination are equal, that might be RT, else OW. Hope this is helpful.

Orders:
LOAD *,
If(Source=Dest,'Roundtrip','Oneway') as Trip_type
;
LOAD *,
SubField(descr,' to ',1) as Source,
SubField(descr,' to ',2) as Dest
;
LOAD * INLINE [
descr, order_id, qty
CA to FL, 123, 2000
CA to GA, 124, 2500
CA to CA, 125, 2100
FL to FL, 126, 2005
GA to FL, 127, 1900
];

Re: Create From and To Filters from same field

qlikwiz123 — Mon, 24 Aug 2020 18:48:38 GMT

@dena_reavis

Hi, this requires changing the existing fields with 'to' combinations, which is a lot of work. Also, this does not meet the requirement I have.

When a user selects One country in Source and another Country in Destination, and selects Roundtrip in a list box, it should show roundtrip as below:

Source Destination

Australia Canada

Source Destination

Canada Australia