Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
kiranpatil123
Contributor III
Contributor III

Change in Front end Expression to Back End Script -Help

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

 

 

0 Replies