Discussion Board for collaboration related to QlikView App Development.
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)loadArticleNumber ,min(date(YearMonth,'YYYY-MM')) as MinYearMonthResident OneBIGroup by ArticleNumber;
left join (OneBI)LOAD
sum(GrossListPrice) as GrossListPriceMaxResident OneBIGroup by GrossListPrice ;
if(YearMonth=MinYearMonth,0,GrossListPriceMax - Peek('GrossListPriceMax')) as Exp1
I need to Achieve this Exp1 so later i can create Flag