HELP...Variable

[Anonymous]

Hi All,

I have created an app and require a variable but unsure how this is done.

My app has two sheets, one for imports and the other for exports. The import sheet has a filter for dest (destination) and the export has one for origin. I would like to create one filter, so if LHR is selected it will filter the import destination as LHR then the origin on export sheet as LHR.

Sheet 1 Imports:

Filter: Dest

Sheet 2 Exports:

Filter: Origin

Filter: LHR

Attached is a qvf of my app.

Thanks in advance for any help.

[agigliotti]

why don't use the same field on both tables ?

[Anonymous]

Hi Andrea,

The imports and exports are two different datasets. So if I set dest as LHR for imports, the origin would be LHR for exports.

Which field do you mean I should use for both?

Thanks

[BalaBhaskar_Qlik]

May be like this:

Sum({<Origin = {'$(=GetFieldselections(Destination))'}>}[Net Price])

One field selection into another field value.

[BalaBhaskar_Qlik]

Try this too:

Sum({<Origin = p(Destinations)>}[Net Price])

[agigliotti]

could you define a single row as import or export ?

is there such a way to separate import rows from export rows ?

[sunny_talwar]

I think you can do this using the concept of LinkTable...

LinkTable:

LOAD ID,

Dest as Location,

     'Destination' as Flag

Resident Imports_Exports;

Concatenate (LinkTable)

LOAD ID,

Origin as Location,

     'Origin' as Flag

Resident Imports_Exports;

And now have Location as filter on both tabs and select LHR in Location

[Anonymous]

Hi Sunny,

So I can keep my original script and create the below in a new section in data load editor?

LinkTable:

LOAD ID,

Dest as Location,

     'Destination' as Flag

Resident Imports_Exports;

Concatenate (LinkTable)

LOAD ID,

Origin as Location,

     'Origin' as Flag

Resident Imports_Exports;

[sunny_talwar]

Yes

[Anonymous]

Hi Sunny,

I added the script as suggested but for imports, it is filtering on 'Origin' instead of 'Dest'. The exports column seem to be filtering fine.