Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Text Box displaying results from a set analysis formula

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))

10 Replies
Highlighted

Re: Text Box displaying results from a set analysis formula

Would you be able to share a sample?

Highlighted

Re: Text Box displaying results from a set analysis formula

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.

Highlighted

Re: Text Box displaying results from a set analysis formula

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?

Highlighted

Re: Text Box displaying results from a set analysis formula

Not sure what the issue is, but your expression seems to work for me

Capture.PNG

Once again are you sure the few lines you shared is not a single ActualNote?

Highlighted
Not applicable

Re: Text Box displaying results from a set analysis formula

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.

Highlighted
Not applicable

Re: Text Box displaying results from a set analysis formula

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

Highlighted

Re: Text Box displaying results from a set analysis formula

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 |);


Capture.PNG

Highlighted
Not applicable

Re: Text Box displaying results from a set analysis formula

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

Highlighted

Re: Text Box displaying results from a set analysis formula

May be this link can help you figure out how to mark correct and helpful answers

Qlik Community Tip: Marking Replies as Correct or Helpful