topic Re: Fomula issue with set analysis in QlikView

Fomula issue with set analysis

Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Fomula issue with set analysis

rupamjyotidas — Fri, 09 Jun 2017 17:37:15 GMT

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))))

)

Re: Fomula issue with set analysis

Thu, 15 Jun 2017 14:55:15 GMT

Hi Rupam,

Thanks for your response. However, it doesnt work.

Do you have any other idea??

Many thanks!!

Re: Fomula issue with set analysis

Mon, 19 Jun 2017 16:24:01 GMT

Hi,

Could anybody help me please?

I would really appreciate it.

Many thanks!!

Re: Fomula issue with set analysis

trdandamudi — Mon, 19 Jun 2017 16:37:11 GMT

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

Re: Fomula issue with set analysis

Mon, 26 Jun 2017 08:35:13 GMT

Ey!

It works!

Many thanks

Atonio.

Re: Fomula issue with set analysis

trdandamudi — Mon, 26 Jun 2017 12:29:22 GMT

You are welcome...