topic Re: If statement and set analysis in QlikView

If statement and set analysis

renjithpl — Tue, 06 Sep 2016 06:18:48 GMT

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

Re: If statement and set analysis

tresB — Tue, 06 Sep 2016 06:31:00 GMT

Could you share your sample qvw?

Re: If statement and set analysis

renjithpl — Tue, 06 Sep 2016 06:49:44 GMT

Please look at the attached qvw.

Re: If statement and set analysis

tresB — Tue, 06 Sep 2016 06:56:14 GMT

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

Re: If statement and set analysis

Anil_Babu_Samineni — Tue, 06 Sep 2016 07:17:25 GMT

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

Re: If statement and set analysis

renjithpl — Tue, 06 Sep 2016 07:21:06 GMT

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

Re: If statement and set analysis

tresB — Tue, 06 Sep 2016 08:39:14 GMT

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

Re: If statement and set analysis

renjithpl — Tue, 06 Sep 2016 09:27:30 GMT

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...

Re: If statement and set analysis

tresB — Tue, 06 Sep 2016 10:16:48 GMT

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

Re: If statement and set analysis

Anil_Babu_Samineni — Tue, 06 Sep 2016 10:25:55 GMT

Is this you are expecting from dim?

Re: If statement and set analysis

renjithpl — Tue, 06 Sep 2016 21:55:05 GMT

This is exactly i want.

Thanks Anil.