topic Re: Remove value in the string in QlikView

Remove value in the string

jsobrinho — Sat, 16 Nov 2024 02:29:45 GMT

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.

Re: Remove value in the string

asinha1991 — Thu, 12 Sep 2019 17:43:11 GMT

maybe a calculated field like this?

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

not sure if I get you though

Re: Remove value in the string

Arthur_Fong — Fri, 13 Sep 2019 05:28:28 GMT

Can you please provide a sample app?

Re: Remove value in the string

StarinieriG — Fri, 13 Sep 2019 08:02:32 GMT

try in this way

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

Re: Remove value in the string

SergeyMak — Fri, 13 Sep 2019 08:10:50 GMT

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)

Re: Remove value in the string

Brett_Bleess — Wed, 25 Sep 2019 13:01:01 GMT

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