Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Valued Contributor III

Missing Bar in accoumulation

Hi guys ,

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

Issue.jpg

can you please help me on this

thanks

Tags (1)
9 Replies
Highlighted

Re: Missing Bar in accoumulation

Would you be able to share you qvw?

Highlighted
Valued Contributor III

Re: Missing Bar in accoumulation

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 .

Highlighted

Re: Missing Bar in accoumulation

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

Highlighted
Valued Contributor III

Re: Missing Bar in accoumulation

for both bars ?

Highlighted

Re: Missing Bar in accoumulation

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

Highlighted
Valued Contributor III

Re: Missing Bar in accoumulation

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

Highlighted

Re: Missing Bar in accoumulation

What are your expressions?

Highlighted
Valued Contributor III

Re: Missing Bar in accoumulation

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

Highlighted
Valued Contributor III

Re: Missing Bar in accoumulation

Got the error thanks sunny