Current Selections in Chart Title

[#1]

I am new to Design in QV...i have a chart that currently includes the department and date i am looking at.  However, when i select 2 or more departments my title doesn't show ANY departments.  How can i have all my currently selected departments included in my chart title?

[erichshiino · Accepted solution]

Did you put:

= Department

on your title?

This kind of expression can only have results if only one value is selected.

To have more than one result you can use concat().

The syntax is: concat ( expression , [separator] )

For example:

= concat ( distinct Department, ', ' )

This will put the Department names separeted by ', '

Hope it helps,

Erich

[#3]

It worked!!!!!! Thank you!!!!

Karen Stewart | Credit Analyst

Clarion Industries | Clarion Boards, Inc. | Clarion Laminates, LLC

(814) 226-0851 x1204 (p) | 814-226-8186 (f)

Karen.Stewart@ClarionIndustries.com

A diamond is a chunk of coal that made good under pressure

[#4]

Me again...my Production Manager has 9 departments under his

supervision...I can now get @ 6 department into the title but I had to

enlarge my graph...I can also have the title of the chart as a label

inside the chart...can I make either present on 2 or 3 lines? So I can

keep my chart the same width?

Karen Stewart | Credit Analyst

Clarion Industries | Clarion Boards, Inc. | Clarion Laminates, LLC

(814) 226-0851 x1204 (p) | 814-226-8186 (f)

Karen.Stewart@ClarionIndustries.com

A diamond is a chunk of coal that made good under pressure

[kaushiknsolanki]

Hi,

    Try Multiline Caption in Caption Tab in Properties..

     Hope this is what u r looking.

Regards,

Kaushik Solanki

[#6]

That's what I was looking for!!!! Thanks so much!!!!!

Karen Stewart | Credit Analyst

Clarion Industries | Clarion Boards, Inc. | Clarion Laminates, LLC

(814) 226-0851 x1204 (p) | 814-226-8186 (f)

Karen.Stewart@ClarionIndustries.com

A diamond is a chunk of coal that made good under pressure

[kaushiknsolanki]

Hi,

     Can you please mark it as solved, so that other people knows it.

Thanks,

Kaushik Solanki

[#8]

Sure, I just can't seem to figure out how...

Karen Stewart | Credit Analyst

Clarion Industries | Clarion Boards, Inc. | Clarion Laminates, LLC

(814) 226-0851 x1204 (p) | 814-226-8186 (f)

Karen.Stewart@ClarionIndustries.com

A diamond is a chunk of coal that made good under pressure

[#9]

Thanks for the help with the Departmental Names!!! It worked great, now

I am trying to do the same thing with the dates selected.

When I used concat in the following expression:

= ( left(text( GraphData.GMonthName),3) )

(dependent upon where I place it) I either get the first month selected

repeated (ie: FebFebFebFeb...) or I get nothing.

Obviously I am doing something wrong, help...

Karen Stewart | Credit Analyst

Clarion Industries | Clarion Boards, Inc. | Clarion Laminates, LLC

(814) 226-0851 x1204 (p) | 814-226-8186 (f)

Karen.Stewart@ClarionIndustries.com

A diamond is a chunk of coal that made good under pressure

[erichshiino]

Try:

=concat ( distinct  left(text( GraphData.GMonthName),3) )