topic All Possible values to be shown in current selection object in QlikView

All Possible values to be shown in current selection object

sakshikaul — Thu, 14 May 2020 06:52:34 GMT

Hi,

When I select Filter as dealer code 30109 then all possible values get selected on other filters too ie city as kolkata, brand as Audi and etc..(see fig 1)

I want that all these possible(city-Kolkata,brand-AUDI and etc) and selected values (Dealer code - 30109)should be seen as a filter(In print document) when I will click on print option. Please check fig 2 . In fig 2 only selected filter can be seen . I want possible values also to get selected also with selected filter.

fig 1

fig 2

Re: All Possible values to be shown in current selection object

agigliotti — Thu, 14 May 2020 07:22:32 GMT

you could use something as below:

=concat(DISTINCT fieldName, ';' )

in a text object

for each of your fields (ex city, brand, etc)

I hope it can helps.

Re: All Possible values to be shown in current selection object

sakshikaul — Thu, 14 May 2020 07:47:56 GMT

Hi,

You meant to say I need to create individual text box for each filter?

Re: All Possible values to be shown in current selection object

agigliotti — Thu, 14 May 2020 07:54:18 GMT

Yes, to me is the only way to show all possible field values.

Re: All Possible values to be shown in current selection object

marcus_sommer — Thu, 14 May 2020 11:20:09 GMT

Take a look to getcurrentselections()

- Marcus