Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
innashna
Contributor II
Contributor II

Current Selections show more than one appearance of one field

Hello,

I am using formulas for presenting current selections in one row.

Nevertheless, I get 3 appearance of one field in current selections.

Here are my formulas :

fieldName

 

= if (index(vCurrentSelections,only({1}$Field) & ':')>0,

       textbetween(
       concat(TOTAL DISTINCT  _OldName & ':' & _NewName,'|',_OldName ) & '|'
       ,only({1}$Field) & ':', '|')

 

Selection =TextBetween( vCurrentSelections & '|', only({1}$Field) & ':', '|')

 

innashna_0-1605702156013.png

 

 

Dimension-$Field  -hidden.

 

 

Can you please assist - what is wrong? Why i appears three times?

 

 

Labels (1)
2 Replies
marcus_sommer
MVP & Luminary
MVP & Luminary

It's not quite clear for me what you are trying to do but I assume you want to replace the origin fieldnames with more user-friendly names. If so I suggest to rename the fields already within the script. Applied with a mapping it could be the last work-step in your script and it doesn't need mich efforts whereby within the UI you may need some adjustments. 

- Marcus

EvgeniaZ
Contributor
Contributor

Hi Marcus,

Please see attached model. 

I'm using the Current Selection Alternatives. 

As you can see there duplication on fields on one example or different aperients for the same selected field on other.