Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Not applicable

Current Selections in Chart Title

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?

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Current Selections in Chart Title

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

27 Replies
Highlighted
Partner
Partner

Current Selections in Chart Title

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

Highlighted
Not applicable

Re: Current Selections in Chart Title

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

Highlighted
Not applicable

Re: Current Selections in Chart Title

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

Highlighted
MVP & Luminary
MVP & Luminary

Re: Current Selections in Chart Title

Hi,

    Try Multiline Caption in Caption Tab in Properties..

     Hope this is what u r looking.

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Highlighted
Not applicable

Re: Current Selections in Chart Title

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

Highlighted
MVP & Luminary
MVP & Luminary

Re: Current Selections in Chart Title

Hi,

 

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

Thanks,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Highlighted
Not applicable

Re: Current Selections in Chart Title

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

Highlighted
Not applicable

Re: Current Selections in Chart Title

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

Highlighted
Partner
Partner

Re: Current Selections in Chart Title

Try:

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