If statement and set analysis

[renjithpl]

Hi All,

I have an expression like below

if(

Dim_FY_New = vNYear, 0,

rangesum(above(SUM({<Dim_FY_New = {'$(vCYear)'}>} S_Amount_USD)),0,RowNo()))

I want to restrict the rangesum formula to Current Year which is 2016.

Please see the attachment as per my above formula. Why doesnt it restrict to 2016 quarters.

Appreciate your response.

Thanks

Renji

[tresesco]

Could you share your sample qvw?

[renjithpl]

Please look at the attached qvw.

[tresesco]

Variable vNYear is returning FY17. Is this what you expect it to return? Do you want only the bars for FY 16 quarters?

[Anil_Babu_Samineni]

I have an expression like below

if(

Dim_FY_New = vNYear, 0,

rangesum(above(SUM({<Dim_FY_New = {'$(vCYear)'}>} S_Amount_USD)),0,RowNo()))

I want to restrict the rangesum formula to Current Year which is 2016.

For this, try like

if(

Dim_FY_New = vNYear, 0,

rangesum(above(SUM({<Year -= {"=$(=Max(Year)"}, Dim_FY_New = {'$(vCYear)'}>} S_Amount_USD)),0,RowNo()))

[renjithpl]

I want to show the bars for only FY16 onwards, anything before FY16 should not be shown.

[tresesco]

I see bars for only FY16 onward. Please explain your requirement in more details.

[renjithpl]

Bars are showing only for 16, but i dont want to show any other quarters other than FY16, right now its showing other quarters like, fy 13, 14, 15...

[tresesco]

I am afraid that I could not follow you. In your sample qvw, I can see bars only for FY16 onward.

[Anil_Babu_Samineni]

Is this you are expecting from dim?