Text Object: select fields

[Anonymous]

Hi,

Im working with QlikView trying to create a text object in order to make an action to select a category of a field:

Field: ProductName

Category: Debt collection

It happens that If i write one word on text chain (Buscar cadena de texto) it works perfectly (for example credit) but If I write two words as debt collection, it does not work.

I tried to put these two words  between parenthesis, quotation marks, underscore, asterisk but without success.

Could you help me please?

Thanks a lot,

Jaime

[Digvijay_Singh]

Two words work for me. See attached.

[Anonymous]

Could you send me a print of the screen please?

I can't open a third-party file

Lots of thanks

Jaime

[Digvijay_Singh · Accepted solution]

I don't know for last 2 days I am not getting mails on replies, something wrong in community app.

Here you go -

[Anonymous]

Thanks a lot.

Now it works

[vishsaggi]

Hey Jamie,

Can you close the thread if you have got the answer marking helpful/correct answers.

Thanks,

V.

[Anonymous]

Hi im having the same issue, please below ..

='GROUP: '& DealerGroup.name & '\n DEALERSHIP: ' & IF(GetSelectedCount(Dealer.name)=0,'ALL', Dealer.name) & '

Business Manager: ' & IF(GetSelectedCount(Deal.fiName)=0,'ALL', Deal.fiName) &'

Period: ' & day(monthstart(makedate(Deal.payout.year,min(Deal.payout.month)))) & ' ' & month(monthstart(makedate(Deal.payout.year,min(Deal.payout.month)))) &  ' - ' & if(month(today())=month(monthend(makedate(Deal.payout.year,max(Deal.payout.month)))),day(today()-1) & ' ' & month(today()), day(monthend(makedate(Deal.payout.year,max(Deal.payout.month)))) & ' ' & month(monthend(makedate(Deal.payout.year,max(Deal.payout.month))))) & ' ' & Deal.payout.year