topic Re: expression sum and ? in QlikView

expression sum and ?

selcukcadir — Thu, 08 Nov 2012 08:39:52 GMT

hi all,

//Sum ({$<SAP_ANAGRUP={"JELLY"}>} MIKTAR) >>>> working

I want to do ,

if ( SAP_ANAGRUP="JELLY" and mid(MALZEME_NO,11,2) ="16" and ISTUR2 = "WR" and (ISTUR = "101" OR ISTUR = "102"), MIKTAR )

but it does not work

sum (

{$<

SAP_ANAGRUP={"JELLY"},

mid(MALZEME_NO,11,2) ={"16"},

ISTUR2 = {"WR"},

(ISTUR = {"101"} OR ISTUR = {"102"}),

MIKTAR

)

picture Added

jagan — Thu, 08 Nov 2012 08:53:33 GMT

Hi,

You create another field in your script for MALZEME_NO by using the

mid(MALZEME_NO,11,2) as Dimension1

Now try expression below. If you calculate in load script the performance would be better.

sum (

{$<

SAP_ANAGRUP={"JELLY"},

Dimension1 ={"16"},

ISTUR2 = {"WR"},

ISTUR = {"101, 102"} >}

MIKTAR

)

Hope this helps you.

Regards,

jagan.