Scripiting and logic issue

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

Hi .

I had issue . i had a metric.old_subsystem and metric.new_substem in the table . i want the combination of both in one list box like union and i want distanct values .

so what i had done

Load old_subsystem as subsystem resident table

Concatenate

Load new_subsystem as subsystem resident table .

By this i got distinct values and ccombination of that in list box .

My requirment 2 is

If i select anything from newly derivered substem it should display both old and new selected value .

logic old(seleted value )or new (selected value ).

Can any one help to achieve this .

Find the sample data in attached file .

Thanks in advance !

Re: Scripiting and logic issue

jonathandienst — Mon, 07 Nov 2016 05:07:29 GMT

If you join with the two subsystems, like this:

Subsystems:

LOAD old_subsystem, old_subsystem as subsystem

FROM ...

Join (Subsystems)

LOAD new_subsystem, new_subsystem as subsystem

FROM ...

The full outer join will load all records. This associates the subsystem values with you data model. Selecting a subsystem will be the same as selecting the new and/or old value(s).

topic Re: Scripiting and logic issue in QlikView

Scripiting and logic issue

Re: Scripiting and logic issue