topic Re: Problem in expression in QlikView

Problem in expression

geam1988 — Fri, 28 Sep 2018 08:57:30 GMT

Hallo,

Dimensions is VBAP.VBELN and VBAP.POSNR

$(vMEK) =

sum( aggr( sum( {$< KEPH.FLAG_KOSTENRELEVANT = {1} >} KEPH.MEK) / KEPH.LOSGR * sum(VBAP.KWMENG_EFF), VBAP.VBELN, VBAP.POSNR))

Expressions are,

MEK =

If (VBAK.AUART = 'ZSA3' OR 'ZSA4' , aggr (Sum (TOTAL.COSS)+ SUM (TOTAL.COSP) , AUFK.AUART , AUFK.KDAUF) , Sum ({< KONV.KSCHL = {'VPRS'} >} (KONV.KWERT))+ $(vMEK) )

MGK - Zuschlag =

Sum( {< KONV.KSCHL = {'VPRS'} >} KONV.KWERT ) *0.122

3rd expression is [MEK] + [MGK - Zuschlag]

but it is giving wrong data. value from 2nd expression is not there. what should i do ?

if i click expression total, it shows

if i click Sum of Rows, it shows

Re: Problem in expression

prieper — Fri, 28 Sep 2018 09:05:01 GMT

What is the purpose of the AGGR-function in Expression for MEK?

Think that this expression should be preceded by SUM, else this expression may deliver multiple results, which QV cannot handle.

Peter

Re: Problem in expression

geam1988 — Fri, 28 Sep 2018 09:28:24 GMT

i just wanted to show the sum as per AUFK.AUART. AUFK table and VBAP table are connected. AUFK table are connected with COSS and COSP table. So far MEK is still working properly. but i am having problem in 3rd expression ( [MEK] + [MGK - Zuschlag] )

Do you think that is the problem ?

Re: Problem in expression

prieper — Fri, 28 Sep 2018 09:36:39 GMT

might be a spelling issue?

Did you try to repeat simply the columns, i.e.

create one expression only with [MEK] and one with [MGK - Zuschlag].

Else, if one of the expression may result in NULL and is only formatted as 0, you may try

NUMSUM([MEK], [MGK - Zuschlag])

Peter

Re: Problem in expression

geam1988 — Fri, 28 Sep 2018 09:42:52 GMT

If i do not use AGGR . it shows MEK like this.

Re: Problem in expression

prieper — Fri, 28 Sep 2018 09:54:06 GMT

so there is something not correct with the formula.

Suggest to cut the formula into pieces and check, which one is correct and then compose again together.

Peter