topic Issue in chart in QlikView

Issue in chart

Thu, 04 Jun 2015 18:46:43 GMT

Hi,

Can someone please help me with this requirement:

I want to remove the current month from my chart.

And my expression is

rangesum(above(sum(NetWorkDays([Fund Start Cycle],[Fund End Cycle])-1),0,12))

rangesum(above(count(NetWorkDays([Fund Start Cycle],[Fund End Cycle])),0,12))

Regards,
Sachin

Re: Issue in chart

sunny_talwar — Thu, 04 Jun 2015 19:00:17 GMT

May be this:

RangeSum(Above(Sum({<DimensionDateField = {"< $(=Date(Max(DimensionDateField), 'MMM YYYY))"}>}NetWorkDays([Fund Start Cycle],[Fund End Cycle])-1),0,12))

RangeSum(Above(Count({<DimensionDateField = {"< $(=Date(Max(DimensionDateField), 'MMM YYYY))"}>}NetWorkDays([Fund Start Cycle],[Fund End Cycle])),0,12))

Re: Issue in chart

Fri, 05 Jun 2015 01:41:51 GMT

It didn't work!!!