topic Re: Select In Field to apply multiple filters to a table in QlikView

Select In Field to apply multiple filters to a table

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

Hi,

I have various buttons on a report which will filter the same table of data in different ways.

I am using the 'Select In Field'. If had 3 Columns - col1, col2, col3 and data was 1 or 0 how could I create one 'Select In field' that would Select 1 of Col1, Col2 & Col3.

I see I could create 3 separate Select Fields. But I wanted to see if I could it in on 'Select In field' as I actually having 13 fields to select all of which I want to select the data 1.

Regards,

Re: Select In Field to apply multiple filters to a table

adamdavi3s — Mon, 10 Oct 2016 08:01:09 GMT

You could concatenate them in your load script and use this as your filter?

Or you could do this with a concatenate expression in a list box to put them into one row and then dissect that concatenation in a set of field triggers?

Re: Select In Field to apply multiple filters to a table

Anil_Babu_Samineni — Mon, 10 Oct 2016 09:24:20 GMT

I can help you here, Try to create one key with the field of 13Field like, So next time just take 13Field as Listbox and then try

AutonumberHash128(Field1, Field2, ...., Field13) as 13Field

Re: Select In Field to apply multiple filters to a table

adamdavi3s — Mon, 10 Oct 2016 09:26:44 GMT

So what I said then?

But slightly worse because by hashing the field becomes nonsense, however if concatenated then at least the individual field values are still visible