9 Replies Latest reply: Sep 4, 2014 4:28 AM by Manish Kachhia

Bar chart with multiple expression how to make label at X axis ?

Hi All

I need the below label to place at X axis ::-

30 Day       60 Day       90 Day

any idea how to do it ?

Paul

• Re: Bar chart with multiple expression how to make label at X axis ?

Enclosed my QV doc

• Re: Bar chart with multiple expression how to make label at X axis ?

OK... but what result you are expecting?

30 Days will show what in bar chart?

Create a bar Chart

Dimension

Calculated Dimension

=ValueList('30 Day', '60 Day', '90 Day')

Expression

IF(ValueList('30 Day', '60 Day', '90 Day') = '30 Day',

NUM(SUM(

IF(CURRENCY='EUR',DAY30*1.64,

IF(CURRENCY='NT',DAY30/24,

IF(CURRENCY='USD',DAY30*1.25,

IF(CURRENCY='YEN',DAY30*0.012,

IF(CURRENCY='SGD',DAY30*1))

)))),'#,##0'),

IF(ValueList('30 Day', '60 Day', '90 Day') = '60 Day',

NUM(SUM(

IF(CURRENCY='EUR',DAY60*1.64,

IF(CURRENCY='NT',DAY60/24,

IF(CURRENCY='USD',DAY60*1.25,

IF(CURRENCY='YEN',DAY60*0.012,

IF(CURRENCY='SGD',DAY60*1))

)))),'#,##0'),

IF(ValueList('30 Day', '60 Day', '90 Day') = '90 Day',

NUM(SUM(

IF(CURRENCY='EUR',DAY90*1.64,

IF(CURRENCY='NT',DAY90/24,

IF(CURRENCY='USD',DAY90*1.25,

IF(CURRENCY='YEN',DAY90*0.012,

IF(CURRENCY='SGD',DAY90*1))

)))),'#,##0'))))

• Re: Bar chart with multiple expression how to make label at X axis ?

Hi sir

Thank you for your help.  I expect the label to display on below the bar .

And not group in 1 box.

If you open my qv doc . You will notice I have show the chart with label I

manually place there.

Paul

• Re: Re: Bar chart with multiple expression how to make label at X axis ?

Hi,

Please find attached file for solution.

Regards,

Jagan.

• Re: Bar chart with multiple expression how to make label at X axis ?

Hi All

Thank you for your sharing . it work fine for my chart . but i still like to try Rob proposal.

Paul

• Re: Bar chart with multiple expression how to make label at X axis ?

Hi Paul Yeo,

use the  option Ctrl+Shift and drag the legend to the X-axis.

Ctrl+shift on the chart , you can visualize the above chart.

drag and drop the legend to the position u want

• Re: Bar chart with multiple expression how to make label at X axis ?

Manish and Jagan's proposed solutions may certainly work, but I think you are better off remodeling the data to be more flexible and ditching the complex if()s.

1. Create a Currency table that associates Currency Name with the Currency Rate.

2. Make Aging days bucket an attribute of your facts and put the amount into a common Amount field. Then just use "Aging Bucket" as the dimension and "sum(Amount)" as the expression.

If you do it that way, you no longer have to maintain currency rates and bucket names over multiple expressions and calculated dimensions.

-Rob

• Re: Bar chart with multiple expression how to make label at X axis ?

hI rOB