topic Re: Missing Bar in accoumulation in QlikView

Missing Bar in accoumulation

agni_gold — Wed, 15 Jun 2016 16:14:18 GMT

Hi guys ,

I am using rangesum function to show cumulative bars but between the chart bar is missing,

can you please help me on this

thanks

sunny_talwar — Wed, 15 Jun 2016 16:16:06 GMT

Would you be able to share you qvw?

agni_gold — Wed, 15 Jun 2016 16:29:15 GMT

Hi sunny ,

the qvw file on client location , i can't but ,

if possible can you tell me the reasons why this is happening , i will try to make correct .

sunny_talwar — Wed, 15 Jun 2016 16:30:21 GMT

Not entirely sure, but may be because the value is missing for that particular period.

agni_gold — Wed, 15 Jun 2016 16:32:37 GMT

for both bars ?

sunny_talwar — Wed, 15 Jun 2016 16:36:33 GMT

It seems blue one might have ended on 15 and not really sure about the grey bar

agni_gold — Wed, 15 Jun 2016 16:57:26 GMT

yes blue will end on 15 but for grey in need cumulative

sunny_talwar — Wed, 15 Jun 2016 16:58:34 GMT

What are your expressions?

agni_gold — Wed, 15 Jun 2016 17:41:08 GMT

for Greay Bar

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

for Blue bar

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

agni_gold — Wed, 15 Jun 2016 18:06:43 GMT

Got the error thanks sunny