topic Re: Current Selections in Chart Title in QlikView

Current Selections in Chart Title

Wed, 18 May 2011 20:14:08 GMT

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?

Current Selections in Chart Title

erichshiino — Wed, 18 May 2011 20:41:12 GMT

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

Re: Current Selections in Chart Title

Thu, 19 May 2011 11:52:31 GMT

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

Re: Current Selections in Chart Title

Thu, 19 May 2011 11:58:31 GMT

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

Re: Current Selections in Chart Title

kaushiknsolanki — Thu, 19 May 2011 12:13:48 GMT

Hi,

Try Multiline Caption in Caption Tab in Properties..

Hope this is what u r looking.

Regards,

Kaushik Solanki

Re: Current Selections in Chart Title

Thu, 19 May 2011 12:18:57 GMT

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

Re: Current Selections in Chart Title

kaushiknsolanki — Thu, 19 May 2011 12:23:18 GMT

Hi,

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

Thanks,

Kaushik Solanki

Re: Current Selections in Chart Title

Thu, 19 May 2011 12:35:46 GMT

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

Re: Current Selections in Chart Title

Thu, 19 May 2011 13:49:04 GMT

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

Re: Current Selections in Chart Title

erichshiino — Thu, 19 May 2011 13:52:38 GMT

Try:

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

Re: Current Selections in Chart Title

Thu, 19 May 2011 14:03:29 GMT

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

Re: Current Selections in Chart Title

erichshiino — Thu, 19 May 2011 14:23:12 GMT

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

Re: Current Selections in Chart Title

Thu, 19 May 2011 14:39:33 GMT

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

Re: Current Selections in Chart Title

Thu, 19 May 2011 16:01:51 GMT

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

Re: Current Selections in Chart Title

erichshiino — Thu, 19 May 2011 17:27:42 GMT

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

Re: Current Selections in Chart Title

Thu, 19 May 2011 17:42:11 GMT

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

Re: Current Selections in Chart Title

erichshiino — Thu, 19 May 2011 17:55:40 GMT

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

Re: Current Selections in Chart Title

Thu, 19 May 2011 18:04:24 GMT

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

Re: Current Selections in Chart Title

Thu, 19 May 2011 19:12:53 GMT

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

Current Selections in Chart Title

kaushiknsolanki — Fri, 20 May 2011 06:24:15 GMT

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

If possible Upload the QVW file.

Regards,

Kaushik Solanki