# New to QlikView

Discussion board where members can get started with QlikView.

Highlighted Not applicable

## Fomula issue with set analysis

Hi all,

I am having problems with this formula, which I want to extend to the rest of the months:

((sum({\$<Escenario={ \$(=Only(Esc_1))},Month = {'Jan'},Channel = {'CallCenter'} >} Rental_Days * (1+[vRDs_Av_CALLCENTER_1])))

/

((sum({\$<Escenario={ \$(=Only(Esc_1))},Month = {'Jan'},Channel = {'CallCenter'} >} Rental_Days * (1+[vRA_Av_CALLCENTER_1])))

/

(sum({\$<Escenario={ \$(=Only(Esc_1))},Month = {'Jan'},Channel = {'CallCenter'} >} Contador_RAs))))

+

((sum({\$<Escenario={ \$(=Only(Esc_1))},Month = {'Feb'},Channel = {'CallCenter'} >} Rental_Days * (1+[vRDs_Av_CALLCENTER_2])))

/

((sum({\$<Escenario={ \$(=Only(Esc_1))},Month = {'Feb'},Channel = {'CallCenter'} >} Rental_Days * (1+[vRA_Av_CALLCENTER_2])))

/

(sum({\$<Escenario={ \$(=Only(Esc_1))},Month = {'Feb'},Channel = {'CallCenter'} >} Contador_RAs))))

Just letting this formula like this, if I select the two months (Jan and Feb), I got the right number. However, if I select just one month, the value doesn´t apper. I guess because of the one I dont select result in null, also because of the divide in the formula.

Could anyone help me to try to convert the null in a 0 or something like that?

Many thanks!

Antonio.

Tags (3)
1 Solution

Accepted Solutions
Honored Contributor II

## Re: Fomula issue with set analysis

Can you please try replacing the SUM with NUMSUM and see if it helps..

6 Replies
Valued Contributor

## Re: Fomula issue with set analysis

Use if statement

((sum({\$<Escenario={ \$(=Only(Esc_1))},Month = {'Jan'},Channel = {'CallCenter'} >} Rental_Days * (1+[vRDs_Av_CALLCENTER_1])))

/

((sum({\$<Escenario={ \$(=Only(Esc_1))},Month = {'Jan'},Channel = {'CallCenter'} >} Rental_Days * (1+[vRA_Av_CALLCENTER_1])))

/

(sum({\$<Escenario={ \$(=Only(Esc_1))},Month = {'Jan'},Channel = {'CallCenter'} >} Contador_RAs))))

))<1,0,

((sum({\$<Escenario={ \$(=Only(Esc_1))},Month = {'Jan'},Channel = {'CallCenter'} >} Rental_Days * (1+[vRDs_Av_CALLCENTER_1])))

/

((sum({\$<Escenario={ \$(=Only(Esc_1))},Month = {'Jan'},Channel = {'CallCenter'} >} Rental_Days * (1+[vRA_Av_CALLCENTER_1])))

/

(sum({\$<Escenario={ \$(=Only(Esc_1))},Month = {'Jan'},Channel = {'CallCenter'} >} Contador_RAs))))

)

) Not applicable

## Re: Fomula issue with set analysis

Hi Rupam,

Thanks for your response. However, it doesnt work.

Do you have any other idea??

Many thanks!! Not applicable

## Re: Fomula issue with set analysis

Hi,

Could anybody help me please?

I would really appreciate it.

Many thanks!!

Honored Contributor II

## Re: Fomula issue with set analysis

Can you please try replacing the SUM with NUMSUM and see if it helps.. Not applicable

## Re: Fomula issue with set analysis

Ey!

It works!

Many thanks Atonio.

Honored Contributor II

## Re: Fomula issue with set analysis

You are welcome...