topic expression help... !! in QlikView

expression help... !!

Mon, 06 Apr 2015 07:26:25 GMT

hi all..

need help regarding expression. i am using the below expression

sum(aggr(if(max(VERSION_NUMBER)=MAX_VERSION_NUMBER,
sum(aggr(
(Sum((if((vDebtors-[Invoice GL Date]) >=0,[EXTENDED_AMOUNT])))
)
*(if(max(VERSION_NUMBER)=MAX_VERSION_NUMBER,PERCENTAGE_ALLOCATED/100)),PERCENTAGE_ALLOCATED,PORTFOLIO_MEMBER_NAME,[Project ID]))
-
sum(aggr(
(Sum(if(APPLY_DATE<=vDebtors,AMOUNT_APPLIED)))
*(if(max(VERSION_NUMBER)=MAX_VERSION_NUMBER,PERCENTAGE_ALLOCATED/100)),PERCENTAGE_ALLOCATED,PORTFOLIO_MEMBER_NAME,[Project ID]))
+
sum(aggr(
(Sum(if(GL_DATE<=vDebtors,ACCTD_AMOUNT)))
*(if(max(VERSION_NUMBER)=MAX_VERSION_NUMBER,PERCENTAGE_ALLOCATED/100)),PERCENTAGE_ALLOCATED,PORTFOLIO_MEMBER_NAME,[Project ID]))
)
,PERCENTAGE_ALLOCATED,PORTFOLIO_MEMBER_NAME,[Project ID]))

i think there is sme error with this expression.since it is taking too long to reload thought the values are comin correctly.

Re: expression help... !!

Mon, 06 Apr 2015 07:59:54 GMT

Hi.

I have created expressions :1.Sum(order total)

2.Max(order total)

3.Max(Aggr (Sum([order total],[customer name],[employee Id]))

4.Firstsorted values([customername], - Aggr(sum([order total]),[customername],[employeeId]))

if use ASC order and DES(-)

try your expression .

Thanks,

sreenu

Re: expression help... !!

Mon, 06 Apr 2015 10:20:15 GMT

hi,

thanks for your reply..

bt i didnt get wat yu exactly mean..how can it be dne with my expressions?

Re: expression help... !!

avinashelite — Mon, 06 Apr 2015 10:30:30 GMT

Hi Reena,

Try to push much of the calculation to script so that it will not take much of the time calculating in the front end.

Re: expression help... !!

Mon, 06 Apr 2015 11:11:38 GMT

yea...bt these fields are comin frm different tables tht i am nt able to do it in script..

Re: expression help... !!

Anonymous — Mon, 06 Apr 2015 11:41:45 GMT

making joins can help you bringing the fields from different tables into a single tables off-course that will increase load time but it is your choice if your users want to keep waiting for this calculations to happen or let your server do and keep data ready for the users.

I personally think users are generally with much lesser RAM and we should push this calcs back in script so that server with its bigger RAM can processes this and keep it ready

Re: expression help... !!

nagarjuna_kotha — Mon, 06 Apr 2015 13:14:34 GMT

Hi Reena,

Can u provide what tables u have in data model ...?