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?

[#2]

I don't mean to be dense...where do I place the spacer? This works, but

I get AprMay...I would rather see Apr May...

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]

No problem

You can create it as a second parameter. I used ', ' but it could be only a space ' ' or a '-'

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

[#4]

Awesome!! Thanks!!!!

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

[#5]

Ok back to beginning...I have all my currently selected departments as a

concat title within the chart. And it works beautifully!!!

However, if no departments are selected the title box within the chart

is not big enough to show all 25 departments at one time...after playing

with this a while, I have decided that if no departments are selected I

would rather show something like "ALL DEPARTMENTS" rather than show all

25 listed individually...

I am guessing this would involve some sort of 'if' statement; but I have

no clue how to write one that will do this...

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]

Hi, You can write something like this:

if ( count ( distinct  Department) = count( {1} distinct Department, 'All Departments', //You have all departments

if ( count ( distinct  Department) < 10,  concat ( distinct Department, ', ' ) , //You have less than 10 dep.

count ( distinct  Department) & ' of ' & count ( {1} distinct  Department) & ' Departments') ) //You have more than 10

... sorry if I forgot some (, ), ' or ,

Regards,

Erich

[#7]

Am I counting my concatenation? Is this a conditional statement (in the

general tab)?

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]

That`s the expression for your title:

=if ( count ( distinct  Department) = count( {1} distinct Department), 'All Departments', if ( count ( distinct  Department) < 10,  concat ( distinct Department, ', ' ) , count ( distinct  Department) & ' of ' & count ( {1} distinct  Department) & 'Departments') )

Translation:

If all there is all the departments are available ( selection = all posible) then write: All Departments

If not and you selected less than 10, concatenate the names of departments

if not (then you selected more  than 9 but not all), write 'x departments of 25'

The conditional on general tab can block if the expressions on the chart will be calculated or not (this is not the case)

Regards,

Erich

[#9]

OMG you are a genius!!!!!!!

Thank you sooo 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

[#10]

I don't know what I'd do without this forum.

I need to total my monthly Totals...When I view more than one month I

get totals for each month...it's making my chart messy...I want to see a

grand total of all months selected...

When I try to sum my sum expression...I get an error...

Also, how can I get rid of the Total in my straight table...the Total

amount shown is the Total of the actual, budget and variance...this #

means nothing so I want to remove it...

Thanks so much for all your 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

[kaushiknsolanki]

Hi

    What type of chart u r using. and r u using month as dimension.

    If possible Upload the QVW file.

Regards,

Kaushik Solanki