topic Set analysis in text object in QlikView

Set analysis in text object

Fri, 27 Jan 2012 13:27:47 GMT

i need to show the sum of the amount for the selected period which are positive group by branches in text object.

For Ex, I have the data like

Month Branch Amt

Jan A 10

Feb A -20

Mar A 20

Jan B -10

Feb B 20

Mar B 40

I need to show in text object, the value for the selected period jan is sum(Amt)= 10.(only A is having Positive values)

for feb, sum(amt) is 10 (bcoz only B is having sum(amt) as positive)

for Jan,Feb is 10 (bcoz only B is having sum(amt) is positive A is givining neg value(-10) dont consider)

for jan,feb,mar is 60 bcoz sum(amt) for A (10)and B (50) is Positive.

Hope someone can help me out,

thanks in advance.

Set analysis in text object

CELAMBARASAN — Fri, 27 Jan 2012 13:50:54 GMT

Hi,

Try this

Sum(Aggr(If([Amt]>=0,[Amt]),[Amt]))

Hope it helps

Celambarasan

Re: Set analysis in text object

CELAMBARASAN — Fri, 27 Jan 2012 13:54:39 GMT

Hi,

Try this

Sum(Aggr(If(Sum(Amt)>=0,Sum(Amt)),Month,Branch,Amt))

Hope it helps

Celambarasan

Set analysis in text object

jagan — Fri, 27 Jan 2012 14:32:28 GMT

Hi,

Try this

=Sum(Aggr(If(Sum(Amt) > 0, Sum(Amt)),Branch, Month))

Hope this helps you.

Regards,

Jagan.

Set analysis in text object

Mon, 30 Jan 2012 13:49:15 GMT

thanks for reply...

But its not working...

could anyone help me....

thanks in advance....

Set analysis in text object

kaushiknsolanki — Mon, 30 Jan 2012 13:59:17 GMT

HI,

Try this expression in text box.

=sum({<Branch = {'=sum(Amt)>0'}>}Amt)

Regards,

Kaushik Solanki