Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Remove value in the string

Hi guys,

I have a field called C in my script like Concat(fieldA,'|',fieldB) in my application I have a filter from fieldA, so when I selected a fieldA , my field C show the result concatenated fieldA|fieldB

Its possible remove this result fieldA and show just fieldB without |? because I already selected the fieldA

 

I dont know if its clear, but I need this concatenation in my script to show the result, but I only dont need repeat the value from field A because I already did the filter by list box.

Labels (4)
5 Replies
Highlighted
Creator III
Creator III

Re: Remove value in the string

maybe a calculated field like this?

if(GetSelectedCount(FieldA)>0,FieldB,FieldA&'|'&[FieldB])

not sure if I get you though

 

 

Highlighted
Partner
Partner

Re: Remove value in the string

Can you please provide a sample app?

Highlighted
Partner
Partner

Re: Remove value in the string

Hi 

try in this way

 

if(GetSelectedCount(FieldA)>0,PurgeChar(C,'|'),C)

Highlighted
Partner
Partner

Re: Remove value in the string

Not sure why can't you just show FieldB?
If you still need to display Field C, but just second part, than try Subfield([field C],'|',2)
Regards,
Sergey
Highlighted
Digital Support
Digital Support

Re: Remove value in the string

Jose, did any of the posts help you with what you needed to solve here, or are you still trying to figure things out?  If you need further help, please provide an update and per Arthur's comment, an example app may help a great deal here too.  If someone's post did help, please use the Accept as Solution button on that post to give them credit, you can do more than one post as well if multiple posts helped you sort things out.  If you did something else completely, consider posting what you did and then mark that as the solution so others will know what worked in this case.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.