QlikView Filter

[Anonymous]

Guys,

When I select a value in multibox, the data should be changed accordingly for the whole sheet. But if I load inline fields, is it possible to add that in multibox and change the data accordingly?

[surendraj]

Yes,you can...

Its possible to add inline fields..

Here you need to join Inline table with other tablea you have...

but there should be a common field in inline table with your table.

[migueldelval]

Hi Siva,

You need to link tables or use getfieldselections();

Regards

Miguel del Valle

[Anonymous]

Plz share any expressions for it...

[migueldelval]

Hi Siva,

It´s better if you attach an example.

But I´m trying to help you. If you want to use a inline table to filter your schema you can use:

A) Link Fields.

            I supose that for example you have a table with. IDEmployee, EmployeeName, HoursWorked, NoCalls, Sales,    

            And you need to add WorkCenter to this information

Load * inline [

            Office, IDEmployee,

               ...];

          And finally you are going to have link Office with your schema.

B) getfieldselections()

          For example you load en excel and you want to use this selecctions to filter your schema (schema and excel table are not linked)             

=sum({<Month_RF={"$(=month(GetFieldSelections(WeekWork)))*"}>}Sales)

Regards

Miguel del Valle