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

[paulyeo11]

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

[paulyeo11]

Enclosed my QV doc

[MK_QSL]

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

[paulyeo11]

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

[jagan · Accepted solution]

Hi,

Please find attached file for solution.

Regards,

Jagan.

[#6]

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

[rwunderlich]

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

[paulyeo11]

hI rOB

Thank you for your offer.

On the step 2 i cannot understand , may be you can help me by show me how the table will be look like.

Paul

[paulyeo11]

Hi All

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

Paul

[MK_QSL]

Just wondering, was my answer different from Jagan's answer?