topic Re: Variable in set analysis in QlikView

Variable in set analysis

Fri, 11 Jul 2014 10:10:47 GMT

I have created a variable

vSL =sum(AP_IN_CALLS_HNDLD) + sum(AP_IN_CALLS_ABAND) +sum(AP_ROUTED_OUT_CALLS) + sum(AP_TRANS_AP_CALLS_HNDLD) +sum(AP_OVRFLW_IN_CALLS_HNDLD) + sum(AP_CALL_OVRFLW_OUT) -sum(AP_CALLS_HELD)+sum(ServCalls)) /
(sum(AP_IN_CALLS_HNDLD) + sum(AP_IN_CALLS_ABAND) +sum(AP_ROUTED_OUT_CALLS) + sum(AP_TRANS_AP_CALLS_HNDLD) +sum(AP_OVRFLW_IN_CALLS_HNDLD) + sum(AP_CALL_OVRFLW_OUT)+sum([Answered+Transfered])+sum(Abandoned))

and would like to use it in a set analysis for each region but this does not work.

=sum({$<Region={'Thompson'}$(vSL))

Please assist

Re: Variable in set analysis

alexandros17 — Fri, 11 Jul 2014 10:15:25 GMT

The problem is that you cannot write Sum( ... Sum(...)) and this is what you have done!

You should include the region (declared as a variable) in each sum ...

Re: Variable in set analysis

santhosh_k_n — Fri, 11 Jul 2014 10:19:21 GMT

Hi Mamorex,

Please assign the variable to which field its pointing,

eg:

V_state = ABCD then use it as below

=sum({$<Region={'Thompson'}, State ={'$(V_State)'})

hope this helps...

Re: Variable in set analysis

tresB — Fri, 11 Jul 2014 10:27:44 GMT

Try like this:

vSL = '(AP_IN_CALLS_HNDLD+ .....) / ( ......) '

vPart1= 'Sum({<Region={'&chr(39)

I.e. Take the fields without Sum() in variable declaration and now in the expression try like:

=$(=vPart1&'Thompson'&chr(39)&'}>}'&$(vSL)&')' )

Re: Variable in set analysis

Fri, 11 Jul 2014 10:36:49 GMT

What the error message are you getting?

use if...

if(Region='Thompson', $(vSL))

hope this help!

Regards

Vinay