Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
sakshikaul
Creator II
Creator II

All Possible values to be shown in current selection object

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

sakshikaul_1-1589438871951.png

fig 2

sakshikaul_2-1589439057530.png

 

 

1 Solution

Accepted Solutions
marcus_sommer

Take a look to getcurrentselections()

- Marcus

View solution in original post

4 Replies
agigliotti
Partner - Champion
Partner - Champion

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.

sakshikaul
Creator II
Creator II
Author

Hi,

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

agigliotti
Partner - Champion
Partner - Champion

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

marcus_sommer

Take a look to getcurrentselections()

- Marcus