Bar Chart don't show proper graph

[madnanansari]

I have created a bar chart with the value list:

ValueList('CY', 'LY')

where CY stands for Current Year and LY stands for Last Year.

for values the below formula is used:

if(ValueList('CY', 'LY')='CY',

SUM(AGGR(if(($(vSalesLYYTD))>0 and ($(vSalesYTD))>0, ($(vSalesYTD)),0),[Unit Key])),

if(ValueList('CY', 'LY')='LY',

SUM(AGGR(if(($(vSalesLYYTD))>0 and ($(vSalesYTD))>0, ($(vSalesLYYTD)),0),[Unit Key]))

)

)

where vSalesLY is:

Sum({$<[Year] = {"$(=Year(Today())-1)"} >} [Sales])

and vSalesCY is:

Sum({$<[Year] = {"$(=Year(Today()))"} >} [Sales])

The graph is not showing properly. The first bar shows the rights size and figures but for the second bar it just shows zero.

If I switch the values for CY and LY; again the first bar shows the right values whereas the second bar is zero.

[shraddha_g]

try This:

Pick(Wildmatch(ValueList('CY', 'LY'),'CY','LY'),

SUM(AGGR(if(($(vSalesLYYTD))>0 and ($(vSalesYTD))>0, ($(vSalesYTD)),0),[Unit Key])),

SUM(AGGR(if(($(vSalesLYYTD))>0 and ($(vSalesYTD))>0, ($(vSalesLYYTD)),0),[Unit Key]))

)

[shraddha_g]

Or

if(Wildmatch(ValueList('CY', 'LY'),'CY'),

SUM(AGGR(if(($(vSalesLYYTD))>0 and ($(vSalesYTD))>0, ($(vSalesYTD)),0),[Unit Key])),

if(Wildmatch(ValueList('CY', 'LY'),'LY'),

SUM(AGGR(if(($(vSalesLYYTD))>0 and ($(vSalesYTD))>0, ($(vSalesLYYTD)),0),[Unit Key]))

)

)

[madnanansari]

it brings the same result as before

[madnanansari]

it brings the same result as before. Even if I put the same :

SUM(AGGR(if(($(vSalesLYYTD))>0 and ($(vSalesYTD))>0, ($(vSalesYTD)),0),[Unit Key]))

for both CY and LY, the second bar is zero.

[shraddha_g]

What does these expression do?

why you are not using

vSalesLY:

Sum({$<[Year] = {"$(=Year(Today())-1)"} >} [Sales])

and vSalesCY:

Sum({$<[Year] = {"$(=Year(Today()))"} >} [Sales])

[madnanansari]

If I directly use these statements then the graph shows the right values.

The below statement actually covers a business requirement where we need to show CY Total and LY Total only for those stores (Unit Key) where there is sales in the current year as well as last year. It skip those stores where either last year or the current year sales dont exists.

SUM(AGGR(if(($(vSalesLYYTD))>0 and ($(vSalesYTD))>0, ($(vSalesYTD)),0),[Unit Key]))

[shraddha_g]

Does this expression work in KPI object?

[madnanansari]

Yes this works in KPI object. both of them.

[shraddha_g]

what are the other dimensions you have in chart?