topic Re: QlikView Filter in QlikView

QlikView Filter

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

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?

Re: QlikView Filter

surendraj — Wed, 01 Feb 2017 14:45:35 GMT

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.

Re: QlikView Filter

migueldelval — Wed, 01 Feb 2017 14:45:54 GMT

Hi Siva,

You need to link tables or use getfieldselections();

Regards

Miguel del Valle

Re: QlikView Filter

Anonymous — Wed, 01 Feb 2017 15:30:23 GMT

Plz share any expressions for it...

Re: QlikView Filter

migueldelval — Wed, 01 Feb 2017 15:52:16 GMT

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