topic set analysis command in QlikView

set analysis command

Thu, 27 Jan 2011 19:21:17 GMT

I want to create an account due where the amount is split up by age in days.

Example

debno total amount days_open < 30 days 30-60 days > 60 days

XXXX 300,00 45 0 300,00 0

YYYY 250,00 11 250 0 0

a try, don't work

Sum( {< days_open < [30] >} Amount)

Sum( {< days_open >= [30] AND days_open < [60] >} Amount)

Sum( {< days_open >= [60] >} Amount)

Can some body give me a hint?

Regards,

set analysis command

Thu, 27 Jan 2011 19:54:53 GMT

You can try this.



Sum( {< days_open = {"<30"} >} Amount)
Sum( {< days_open = {">30 < 60"} >} Amount)
Sum( {< days_open = {">60"}>} Amount)

set analysis command

Fri, 28 Jan 2011 09:54:50 GMT

Sorry but I get all amounts in the first column. (<30)

So the set analysis don't work well

days_open is a computed column

Floor

(if( isnull(BETAALDATUM), Date(Now()) , BETAALDATUM)- FACTDATUM)

set analysis command

Fri, 28 Jan 2011 10:00:21 GMT

Hi,

you can try like this way Try to create the Computation Field in Back end and then apply the set analysis which has sent in previous post by sHi, you can try like this way Try to create the Computation Field in Back end and then apply the set analysis which has sent in previous post by Fernando.

Regards,

Santhosh

set analysis command

Fri, 28 Jan 2011 10:11:59 GMT

In don't understand you

set analysis command

suniljain — Fri, 28 Jan 2011 11:59:50 GMT

can you post your logic ?.

set analysis command

bumin — Fri, 28 Jan 2011 12:24:24 GMT

please find attached your example

regards

Bumin

set analysis command

Fri, 28 Jan 2011 13:08:00 GMT

you try a sum with if, not set analysis


Sum(If(days_open<30,amount))