Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good day
I am using the formula below trying to get the sentences to start with an arrow as a bullet. The result has been displayed below with the heading Testing Bullets. I need each sentence to start with the arrow not only the paragraph. How should I do this ?
=Concat(Distinct{$ <Note_Year = {"$(=max(Note_Year))"}, Note_Month = {"$(vMaxMonthNotes)"},Note_ObjectID= {'Document\TX231'} >} chr(8594) & ' '& ActualNote, chr (10))
Would you be able to share a sample?
I created some test data with this :
LOAD * INLINE [
TestText
One
Two
Three
Four
];
And used this in a Text Box :
=chr(8594) & ' ' & concat(distinct TestText , chr(10) & chr(8594) & ' ' )
Give it a try.
But Bill do you see any issue what what the OP has right now? I think the current one should also work unless the above text is part of one cell. Right?
Not sure what the issue is, but your expression seems to work for me
Once again are you sure the few lines you shared is not a single ActualNote?
Hi Sunny.
Thanks for the feedback.
The formula works when there is one sentence but not on paragraphs e.g: I have added two more sentences to the first row of data below and the arrow or bullet will only be displayed after the first sentence and I would like to see all the sentences to start with the arrow or bullet after every full stop.
Table:
LOAD * Inline [
Note_Year, Note_Month, Note_ObjectID, ActualNote
2016, 4, Document\TX231, Activity from the people, places, and content you are following. What has happened to this formula today. I am currently testing it.
2016, 4, Document\TX231, Social News: new activity by Q On Learning Center.
2016, 4, Document\TX231, Recent Stats for content you've created or contributed to.
2016, 4, Document\TX231, People naturally form groups to share ideas and accomplish goals.
Hi Bill
Please see my response below that was sent to Sunny.
The formula works when there is one sentence but not on paragraphs e.g: I have added two more sentences to the first row of data below and the arrow or bullet will only be displayed after the first sentence and I would like to see all the sentences to start with the arrow or bullet after every full stop.
Table:
LOAD * Inline [
Note_Year, Note_Month, Note_ObjectID, ActualNote
2016, 4, Document\TX231, Activity from the people, places, and content you are following. What has happened to this formula today. I am currently testing it.
2016, 4, Document\TX231, Social News: new activity by Q On Learning Center.
2016, 4, Document\TX231, Recent Stats for content you've created or contributed to.
2016, 4, Document\TX231, People naturally form groups to share ideas and accomplish goals
That was a load issue. Comma is used a default delimiter and your text had comma, so QlikView wasn't able to read the whole thing. Try this (I changed the delimiter to a pipe)
Table:
LOAD * Inline [
Note_Year| Note_Month| Note_ObjectID| ActualNote
2016| 4| Document\TX231| Activity from the people, places, and content you are following. What has happened to this formula today. I am currently testing it.
2016| 4| Document\TX231| Social News: new activity by Q On Learning Center.
2016| 4| Document\TX231| Recent Stats for content you've created or contributed to.
2016| 4| Document\TX231| People naturally form groups to share ideas and accomplish goals.
] (delimiter is |);
Hi Sunny
It is working now. The problem was that I captured a paragraph as one ActualNote.
Thank you very much for your assistance.
I am just struggling to mark it as answered.
Regards
Emelina Maluleke | BI Developer | Barclays Information & Integration Services | Data Systems & Insights : Africa
Tel +27 (0)11 846 9185 | Email Emelina.Maluleke@absa.co.za<mailto:Emelina.Maluleke@absa.co.za>
Barclays Towers East, 2nd Floor, Johannesburg, 2001
P Please consider the environment before printing this email
COMPANY CONFIDENTIAL
May be this link can help you figure out how to mark correct and helpful answers