Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Text Object: select fields

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.

c.PNG

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

1 Solution

Accepted Solutions
Digvijay_Singh

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

Here you go -

Capture.PNG

View solution in original post

6 Replies
Digvijay_Singh

Two words work for me. See attached.

Anonymous
Not applicable
Author

Could you send me a print of the screen please?

I can't open a third-party file

Lots of thanks

Jaime

Digvijay_Singh

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

Here you go -

Capture.PNG

Anonymous
Not applicable
Author

Thanks a lot.

Now it works

vishsaggi
Champion III
Champion III

Hey Jamie,

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

Thanks,

V.

Anonymous
Not applicable
Author

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