topic Text Box displaying results from a set analysis formula in QlikView

Text Box displaying results from a set analysis formula

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Text Box displaying results from a set analysis formula

sunny_talwar — Fri, 29 Apr 2016 17:36:03 GMT

Would you be able to share a sample?

Re: Text Box displaying results from a set analysis formula

Anonymous — Fri, 29 Apr 2016 17:45:32 GMT

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.

Re: Text Box displaying results from a set analysis formula

sunny_talwar — Fri, 29 Apr 2016 17:53:54 GMT

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?

Re: Text Box displaying results from a set analysis formula

sunny_talwar — Fri, 29 Apr 2016 22:57:03 GMT

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?

Re: Text Box displaying results from a set analysis formula

Mon, 02 May 2016 19:16:26 GMT

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.

Re: Text Box displaying results from a set analysis formula

Mon, 02 May 2016 19:19:04 GMT

Hi Bill

Please see my response below that was sent to Sunny.

Re: Text Box displaying results from a set analysis formula

sunny_talwar — Mon, 02 May 2016 19:56:06 GMT

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

Re: Text Box displaying results from a set analysis formula

Thu, 05 May 2016 07:50:50 GMT

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

Re: Text Box displaying results from a set analysis formula

sunny_talwar — Thu, 05 May 2016 14:31:03 GMT

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

Re: Text Box displaying results from a set analysis formula

Fri, 06 May 2016 07:22:40 GMT

Maluleke, Emelina: Absa would like to recall the message, "[New to QlikView] - Text Box displaying results from a set analysis formula".

Important Notice:

Absa is an Authorised Financial Services Provider and Registered Credit Provider,

registration number: NCRCP7. This e-mail and any files transmitted with it may

contain information that is confidential, privileged or otherwise protected from

disclosure. If you are not an intended recipient of this e-mail, do not duplicate

or redistribute it by any means. Please delete it and any attachments and notify

the sender that you have received it in error. Unless specifically indicated, this

e-mail is not an offer to buy or sell or a solicitation to buy or sell any securities,

investment products or other financial product or service, an official confirmation of

any transaction, or an official statement of Absa. Any views or opinions presented

are solely those of the author and do not necessarily represent those of Absa.

This e-mail is subject to terms available at the following link:

http://www.absa.co.za/disclaimer.

The Disclaimer forms part of the content of this email. If you are unable to access

the Disclaimer, send a blank e-mail to disclaimer@absa.co.za and we will send you a

copy of the Disclaimer. By messaging with Absa you consent to the foregoing.

By emailing Absa you consent to the terms herein. This email may relate to or be sent

from other members of the Absa Group.