Min point work , Max point not working

paulyeo11 — Tue, 06 Aug 2013 11:26:54 GMT

Hi All

I have a GP % chart. the dynamic min GP% working fine and max GP% not working :-

Below is my min dynamic GP% expression :- ( working )

Min(Aggr(( sum({$<year=, month=, date = {">=$(=MonthStart(vSelectedDate, -48))<=$(=vSelectedDate)"}>} sales)/1 - sum({$<year=, month=, date = {">=$(=MonthStart(vSelectedDate, -48))<=$(=vSelectedDate)"}>} cost)/1 ) / sum({$<year=, month=, date = {">=$(=MonthStart(vSelectedDate, -48))<=$(=vSelectedDate)"}>} sales)/1),$(ColumnDim_p)

)

Below is my max dynamic GP% expression :- ( working )

Max(Aggr(( sum({$<year=, month=, date = {">=$(=MonthStart(vSelectedDate, -48))<=$(=vSelectedDate)"}>} sales)/1 - sum({$<year=, month=, date = {">=$(=MonthStart(vSelectedDate, -48))<=$(=vSelectedDate)"}>} cost)/1 ) / sum({$<year=, month=, date = {">=$(=MonthStart(vSelectedDate, -48))<=$(=vSelectedDate)"}>} sales)/1),$(ColumnDim_p)

)

Notice that the major diff are the first wording of the expression , the rest should be same. But it just cannot work.

After typing till here , when i click the Static max to un-tick , it work fine. so in conclusion , the max value don't need to control.

Thank for viewing.

Paul

topic Min point work , Max point not working in QlikView

Min point work , Max point not working