Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
DWolsie
Contributor III
Contributor III

Remove brackets and quotation marks with GetFieldSelect

Hello everyone,

I've got a problem that I haven't found a solution to yet. I've got a KPI field where I use the GetFieldSelections like this:

 = 'Aufteilung Budget ' & GetFieldSelections([GJAHR], ', ')

 However, whenever I load the Sheet and 2024 is pre-selected, it looks like this:

DWolsie_0-1728658422494.png

It is only when I deselect and the reselect the GJAHR that it looks correct:

DWolsie_1-1728658482663.png

 

Is there a simple or elegant solution to this problem? Thanks in Advance!

 

 

Labels (1)
1 Solution

Accepted Solutions
sbaro_bd
Creator III
Creator III

Hi @DWolsie ,

Indeed, it's very strange! Use the PurgeChar expression to fix it : 

='Aufteilung Budget ' & PurgeChar(GetFieldSelections([GJAHR], ', '),'()"')

Regards.

View solution in original post

2 Replies
sbaro_bd
Creator III
Creator III

Hi @DWolsie ,

Indeed, it's very strange! Use the PurgeChar expression to fix it : 

='Aufteilung Budget ' & PurgeChar(GetFieldSelections([GJAHR], ', '),'()"')

Regards.

seanbruton

Kudos nice simple solution!!