topic Re: Expression in QlikView

Expression

upaliwije — Tue, 04 Aug 2015 11:17:55 GMT

Hi,

sum(IF(DESCRIPTION='NET_PROFIT')<0,{<DESCRIPTION={'NET_PROFIT'}>}ACTUAL)

my above expression does work. Pls help me to correct it

sunny_talwar — Tue, 04 Aug 2015 11:19:48 GMT

May be this:

=Sum({<DESCRIPTION={'NET_PROFIT'}>}ACTUAL)

puttemans — Tue, 04 Aug 2015 11:24:49 GMT

What exactly do you want to realize? Seems like you're mixing up bracket types and syntax.

upaliwije — Tue, 04 Aug 2015 11:29:09 GMT

Tks

What Exactly I want to get is If Description='NET_PROFIT'<0 then sum Actual where Description='NET_PROFIT'

sunny_talwar — Tue, 04 Aug 2015 11:36:21 GMT

Try this may be:

=Sum({<DESCRIPTION={"=NET_PROFIT<0"}>}ACTUAL)

puttemans — Tue, 04 Aug 2015 11:39:03 GMT

This is a bit strange. What is the name of you variable? Description or net_profit?

If net_profit and Actual are variables, then the formula should look like :

sum( If( NET_PROFIT < 0, Actual, 0))

If your variable is Description, then how can NET_PROFIT be a variable together with '0'?

upaliwije — Tue, 04 Aug 2015 11:41:01 GMT

It also does not work

sasiparupudi1 — Tue, 04 Aug 2015 11:54:06 GMT

This May be

if (Sum({<DESCRIPTION={'NET_PROFIT'}>}ACTUAL)<0,Sum({<DESCRIPTION={'NET_PROFIT'}>}ACTUAL),0)

krishna20 — Tue, 04 Aug 2015 12:34:54 GMT

Hi,

This may be

If(DESCRIPTION='NET_PROFIT'<0,SUM({<DESCRIPTION={'NET_PROFIT'}>}ACTUAL))

NavinReddy — Tue, 04 Aug 2015 13:23:04 GMT

try like this

If(DESCRIPTION='NET_PROFIT'<0,SUM({<DESCRIPTION={'NET_PROFIT'}>}ACTUAL),0)