topic Re: Excluding brackets on Text in QlikView

Excluding brackets on Text

NavinReddy — Tue, 21 Jun 2016 12:05:36 GMT

Dear Experts,

Can some one help how to fix this issue.

i just want to exclude text " (XXX10103) "

# P1 Tickets - All Sources (%)** 2 months lag** (XXX10103) %

disply text like = # P1 Tickets - All Sources (%)** 2 months lag** %

Any suggession on resolving this issue

Many Thanks,

Niru

Re: Excluding brackets on Text

Anonymous — Tue, 21 Jun 2016 12:15:21 GMT

Hi Niranjan,

Try this:

=Replace('# P1 Tickets - All Sources (%)** 2 months lag** (XXX10103) %',' (XXX10103) ','')

Regards!

Re: Excluding brackets on Text

NavinReddy — Tue, 21 Jun 2016 12:19:57 GMT

Hi Manuel,

Thank you so much for your reply

in listbox i have many with the same format,

is this possible to implement same logic on listbox.

Regards,

Niru

Re: Excluding brackets on Text

Colin-Albert — Tue, 21 Jun 2016 12:28:34 GMT

Can you give some more examples so we can offer the best solution.

Does the text you want to exclude always start (XXX ?

Re: Excluding brackets on Text

ciaran_mcgowan — Tue, 21 Jun 2016 12:31:35 GMT

Hi Niru,

Yes, this will work in a listbox if you use <Expression> instead of an existing field. Is the text you are trying to replace always going to be (XXX10103) or will it change? If it does, then you might be better off using something like:

Left(YourFieldName, FindOneOf(YourFieldName, '(', 2)-1) & '%'

This will return everything to the left of the 2nd '(' and add a '%' to the end.

Re: Excluding brackets on Text

sunny_talwar — Tue, 21 Jun 2016 12:33:27 GMT

Can you elaborate a little more on your requirement

Re: Excluding brackets on Text

NavinReddy — Tue, 21 Jun 2016 12:36:47 GMT

Thank You so much its working

Re: Excluding brackets on Text

ciaran_mcgowan — Tue, 21 Jun 2016 12:37:39 GMT

I should point out that if the are not always going to be brackets in the earlier part of the text, or more than 1, then the syntax above would change from

Left(YourFieldName, FindOneOf(YourFieldName, '(', 2)-1) & '%'

Left(YourFieldName, FindOneOf(YourFieldName, '(', SubStringCount(YourFieldName, '('))-1) & '%'

It all depends on the data you are working with.