Displaying Values After Filter Selections

qlik_hunter — Tue, 04 Apr 2023 19:37:46 GMT

I'm running into an issue with how my data is displayed in a table, which may need be solved on the data prep side rather than in the app development, but I'm open to suggestions either way.

A simplified version of my data looks like:

Load * Inline [

ID, Letter

1, A

1, B

1, C

1, D

];

In the table, I have the letter column concatenated (=concat(distinct [Letter], ', ')) using a comma so that it appears like:

ID | Letter

1 A, B, C, D

However, when a letter selection is made, the remaining letters disappear since the underlying data is filtered. Would it be possible to have the letters be preserved under filters? My first thought was to make a table that each of the letters map to that contain all letters so the display is static under selection (other than rows being removed if not part of the selection).

Thank you very much for your help!

Re: Displaying Values After Filter Selections

BrunPierre — Tue, 04 Apr 2023 19:53:10 GMT

Hi, try this.

=Concat({1} DISTINCT [Letter], ', ')

Re: Displaying Values After Filter Selections

qlik_hunter — Tue, 04 Apr 2023 20:44:08 GMT

That worked perfectly! Thank you so much BrunPierre!

topic Re: Displaying Values After Filter Selections in Connectivity & Data Prep

Displaying Values After Filter Selections

Re: Displaying Values After Filter Selections

Re: Displaying Values After Filter Selections