topic Re: RangeSum issue in QlikView

RangeSum issue

agni_gold — Fri, 20 May 2016 13:34:14 GMT

Hi All,

I have issue like below , as we can see extra days are coming , i am trying to restrict days till it has data

Actual :

= RangeSum(above(Sum({<[Segment Entity]-= {""},Date= {">=$(=Min([Month Start Date]))<=$(v_Date)"}> }[ERP Amount USD])/1000000,0,
Sum({<Date= {">=$(=Min([Month Start Date]))<=$(v_Date)"}> }Day)) )

AOP:

= RangeSum(above(Sum({<[Segment Entity]-= {""},Date= {">=$(=Min([Month Start Date]))<=$(v_Date)"}> }[Target Budget])/1000000,0,
Sum({<Date= {">=$(=Min([Month Start Date]))<=$(v_Date)"}> }Day)) )

Please help.

Re: RangeSum issue

marcus_sommer — Fri, 20 May 2016 13:49:30 GMT

There are several possibilities, for example the way you create the day-dimension and if show all values is enabled and/or the surpressing of NULL witin the tab presentation isn't enabled and I would probably change the expression to:

= RangeSum(above(Sum({<[Segment Entity]-= {""},Date= {">=$(=Min([Month Start Date]))<=$(v_Date)"}> }[ERP Amount USD])/1000000,0,
Sum({<Date= {">=$(=Min([Month Start Date]))<=$(v_Date)"}> }Day) rowno(total)) )

- Marcus

Re: RangeSum issue

Kushal_Chawda — Fri, 20 May 2016 13:54:45 GMT

try this

= RangeSum(above(Sum({<[Segment Entity]-= {""},Date= {">=$(=Min([Month Start Date]))<=$(v_Date)"}> }[Target Budget])/1000000,0, rowno())
Sum({<Date= {">=$(=Min([Month Start Date]))<=$(v_Date)"}> }Day))

Re: RangeSum issue

agni_gold — Fri, 20 May 2016 14:06:29 GMT

No friend it does not making any change

Re: RangeSum issue

Kushal_Chawda — Fri, 20 May 2016 14:11:01 GMT

this?

= RangeSum(above(Sum({<[Segment Entity]-= {""},Date= {">=$(=Min([Month Start Date]))<=$(v_Date)"}> }[Target Budget])/1000000,0, rowno(Total)),
Sum({<Date= {">=$(=Min([Month Start Date]))<=$(v_Date)"}> }Day))

Re: RangeSum issue

agni_gold — Fri, 20 May 2016 14:14:04 GMT

I have tried both , but same answer