topic Sub total is not working. in QlikView

Sub total is not working.

Thu, 28 Aug 2014 03:58:21 GMT

Sub total is not working.

qv_jagan — Thu, 28 Aug 2014 04:09:03 GMT

Hi Pragnya,

Please use this.

Sum(iF(INPUTAMT=0,AMT,INPUTAMT))

Thanks,

Jagan. V

jagan — Thu, 28 Aug 2014 04:20:08 GMT

Hi,

Try like this in script

LOAD *

iF(INPUTAMT=0,AMT,INPUTAMT) AS NewField

FROM

(biff, embedded labels, table is Sheet1$);

Now in front end you simply use Sum(NewField).

Hope this helps you.

Regards,

Jagan.

ecolomer — Thu, 28 Aug 2014 04:25:32 GMT

Here you have my proposal