Solved: Re: Current Selections in Chart Title - Qlik Community

Report Inappropriate Content · ‎2011-05-18

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 · ‎2011-05-18

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

View solution in original post

erichshiino · ‎2011-05-18

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

Report Inappropriate Content · ‎2011-05-19

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

Report Inappropriate Content · ‎2011-05-19

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 · ‎2011-05-19

Hi,

Try Multiline Caption in Caption Tab in Properties..

Hope this is what u r looking.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

Report Inappropriate Content · ‎2011-05-19

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 · ‎2011-05-19

Hi,

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

Thanks,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

Report Inappropriate Content · ‎2011-05-19

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

Report Inappropriate Content · ‎2011-05-19

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 · ‎2011-05-19

Try:

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