Ad Hoc Filter using $Field and List Box referencing variable

[kerkying]

Hi all,

We are implementing Qlikview server and in our ad hoc reporting solution want to allow filtering from a list of fields.

We cannot place multiple list boxes for each field as there are too many fields.

Currently thinking of displaying all the fields with a list box showing $Field and having a variable vAdHocFilter to store the field name selected from the list box.

We then have another List Box that has a field expression =vAdHocFilter but the listbox does not recognize the value in vAdHocFilter as a field.

Any ideas to make this work?

Thanks!!

[trdandamudi]

Might be you can do as follow:

1) Create a list box and select expression and type =$Field     <--- You will see all the fields in data model in this list

2) Create a second list box and select expression and type  =GetFieldSelections($Field)  <-- It will show the field selected in the first list box.

Hope this helps...

[trdandamudi · Accepted solution]

The other option that you can try based on your question:

"We then have another List Box that has a field expression =vAdHocFilter but the listbox does not recognize the value in vAdHocFilter as a field. "

In the field expression type =$(=vAdHocFilter)

          OR

In the field expression type =$'(=vAdHocFilter)'

          OR

In the field expression type =$'(vAdHocFilter)'

Note: Assuming that you defined your variable vAdHocFilter =GetFieldSelections($Field)

Hope this helps....

[sunny_talwar]

Or you can do Aggr($Field, $Field) for your second list box. What if I may, what is the purpose of your second list box? Will you be making further selections in the second list box or is this just to display what is selected?

[kerkying]

Hi Dandamudi,

Thanks for the suggestion - its close but we want to still be able to make selections for the values of the selected field in the second list box. The =GetFieldSelections($Field) only displays the selected field, not showing the values in it.

[kerkying]

Hi Sunny,

I wanted to still be able to list the values within the field in my second list box.

I think above comment by Dandamundi seems to be able to make it work - using a variable vAdHocFilter =GetFieldSelections($Field), and In the field expression for the second list box type =$(=vAdHocFilter)

[trdandamudi]

If you want to show the values in the second list box then use the below expression:

=$(=GetFieldSelections( $Field ))

Hope this helps...