Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Can anyone help me to display the total showing on top of a bar chart in two lines?

Hi All,

my only one expression in barchart contains two parts, one part showing the count, one  part showing sum. but it is lengthy on bar.

So can anyone help me to display the value on barchart in two lines?

Thanks,

Durga

Tags (1)
1 Solution

Accepted Solutions
Highlighted

Re: Can anyone help me to display the total showing on top of a bar chart in two lines?

Hi

Try like this

Expression1:

= DaysExpression

Check bar Checkbox and unCheck the Value on Data Points Checkbox


Expression2:

=DaysExpression & 'Days'& Chr(10) & ReviewExpression &'Reviews'

UnCheck bar Checkbox and Check the Value on Data Points Checkbox

Hope it helps

View solution in original post

7 Replies
Highlighted
MVP
MVP

Re: Can anyone help me to display the total showing on top of a bar chart in two lines?

Not sure I understand. Do you mean the legend text is too lengthy, or the dimension text?

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted
Specialist
Specialist

Re: Can anyone help me to display the total showing on top of a bar chart in two lines?

Use Chr (10) between your expressions. exp1  & Chr(10) & exp 2

Highlighted
MVP
MVP

Re: Can anyone help me to display the total showing on top of a bar chart in two lines?

try below expression

=dual(SUM({$<%_CDD_STAT_CDE5*={'Complete','Cancelled'}>} ACTV_DURATION)&' Days, '&COUNT({$<%_CDD_STAT_CDE5*={'Complete','Cancelled'}>} DISTINCT %_PRFL_CTXT_ID)&'Reviews',

\SUM({$<%_CDD_STAT_CDE5*={'Complete','Cancelled'}>} ACTV_DURATION)/ COUNT({$<%_CDD_STAT_CDE5*={'Complete','Cancelled'}>} DISTINCT %_PRFL_CTXT_ID))

Highlighted
Creator III
Creator III

Re: Can anyone help me to display the total showing on top of a bar chart in two lines?

Hi Kush,

it is showing error in expression.


Highlighted
MVP
MVP

Re: Can anyone help me to display the total showing on top of a bar chart in two lines?

The expression looks OK, except for the backslash which you should remove. Looks like a typo.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted

Re: Can anyone help me to display the total showing on top of a bar chart in two lines?

Hi

Try like this

Expression1:

= DaysExpression

Check bar Checkbox and unCheck the Value on Data Points Checkbox


Expression2:

=DaysExpression & 'Days'& Chr(10) & ReviewExpression &'Reviews'

UnCheck bar Checkbox and Check the Value on Data Points Checkbox

Hope it helps

View solution in original post

Highlighted
Creator III
Creator III

Re: Can anyone help me to display the total showing on top of a bar chart in two lines?

Thanks for responses.

its working. when i keep two expressions in line by line in one expression.