Change in Front end Expression to Back End Script -Help

kiranpatil123 — Tue, 16 Jul 2019 08:42:24 GMT

hi All ,

I'm Able to achieve the difference in same column in front end , but i need to do in back end as i need to filter for Flag

Front End Expression - This is working

=if(YearMonth=min( TOTAL<ArticleNumber> YearMonth),0,

rangesum(sum( GrossListPrice) - Above( TOTAL sum(GrossListPrice))))

Back End - What am i doing wrong ?

Left Join(OneBI)
load
ArticleNumber ,
min(date(YearMonth,'YYYY-MM')) as MinYearMonth
Resident OneBI
Group by ArticleNumber;

left join (OneBI)
LOAD

GrossListPrice,

sum(GrossListPrice) as GrossListPriceMax
Resident OneBI
Group by GrossListPrice ;

ONEBI__:
LOAD *,

if(YearMonth=MinYearMonth,0,
GrossListPriceMax - Peek('GrossListPriceMax')) as Exp1

I need to Achieve this Exp1 so later i can create Flag

Please help

Advance Thanks

topic Change in Front end Expression to Back End Script -Help in QlikView