topic Text Object: select fields in QlikView

Text Object: select fields

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Text Object: select fields

Digvijay_Singh — Wed, 07 Mar 2018 23:55:47 GMT

Two words work for me. See attached.

Re: Text Object: select fields

Anonymous — Thu, 08 Mar 2018 00:15:40 GMT

Could you send me a print of the screen please?

I can't open a third-party file

Lots of thanks

Jaime

Re: Text Object: select fields

Digvijay_Singh — Thu, 08 Mar 2018 23:53:09 GMT

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

Here you go -

Re: Text Object: select fields

Anonymous — Sat, 10 Mar 2018 11:55:42 GMT

Thanks a lot.

Now it works

Re: Text Object: select fields

vishsaggi — Sat, 10 Mar 2018 15:48:25 GMT

Hey Jamie,

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

Thanks,

Re: Text Object: select fields

Anonymous — Tue, 20 Mar 2018 11:01:48 GMT

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