Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I don't know for last 2 days I am not getting mails on replies, something wrong in community app.
Here you go -
Two words work for me. See attached.
Could you send me a print of the screen please?
I can't open a third-party file
Lots of thanks
Jaime
I don't know for last 2 days I am not getting mails on replies, something wrong in community app.
Here you go -
Thanks a lot.
Now it works
Hey Jamie,
Can you close the thread if you have got the answer marking helpful/correct answers.
Thanks,
V.
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