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.

[sunny_talwar]

Would you be able to share the updated qvf file?

[Anonymous]

Done.

Thanks

[sunny_talwar]

Not sure if you will have any expressions in your tables or not... but if you don't plan to have any expressions, you can change your fields (Origin & Dest) to this

IMPORTS table Origin field

=Aggr(Only({<Origin = p(Location)>} Origin), Origin)

EXPORTS table Dest field

=Aggr(Only({<Dest = p(Location)>} Dest), Dest)

[Anonymous]

I do have expressions on the tables.

[sunny_talwar]

Then use set analysis within your expressions

for IMPORTS

{<Flag = {'Origin'}>}

For EXPORTS

{<Flag = {'Destination'}>}