topic Re: set analysis(urgent) in QlikView

set analysis(urgent)

Mon, 13 Aug 2012 08:29:06 GMT

can i use 'getfieldselection' in the modifier?

Re: set analysis(urgent)

Mon, 13 Aug 2012 08:37:44 GMT

I think you can use any function in the modifier, so thisone as well. What are you trying to achieve, or what is the problem you run into?

Re: set analysis(urgent)

SunilChauhan — Mon, 13 Aug 2012 08:38:15 GMT

see attached file

Re: set analysis(urgent)

Mon, 13 Aug 2012 08:43:52 GMT

i am trying this function:

sum

({$<[Time Bucket Name] = GetFieldSelections([Time Bucket Name]), [Time Bucket Type] = {'CURRENT'}, [TA Sort Order] =>}NUM_ACTV_PTNT) - sum({$<[Time Bucket Name] = GetFieldSelections([Time Bucket Name]), [Time Bucket Type] = {'PREVIOUS'}, [TA Sort Order] =>}NUM_ACTV_PTNT))

and as u can see, there is some error and the expression editor is also giving the error: Error in set modifier element function.

Please help

Re: set analysis(urgent)

Mon, 13 Aug 2012 08:47:59 GMT

I think it should be like this

sum

({

[Time Bucket Name] = {$(=GetFieldSelections([Time Bucket Name]))},

[Time Bucket Type] = {'CURRENT'},

[TA Sort Order] =>}NUM_ACTV_PTNT

)

sum({$<[Time Bucket Name] = {$(=GetFieldSelections([Time Bucket Name]))},

[Time Bucket Type] = {'PREVIOUS'},

[TA Sort Order] =>}

NUM_ACTV_PTNT))

Please also compare your syntax with Sunil Chauhan's example. THe getFieldSelections() function cannot be used like you use it, but must be surrounded by {} and by $() (dollar sign expansion)

Re: set analysis(urgent)

SunilChauhan — Mon, 13 Aug 2012 08:48:04 GMT

sum

({$<[Time Bucket Name] = {$(=GetFieldSelections([Time Bucket Name]))}, [Time Bucket Type] = {'CURRENT'}, [TA Sort Order] =>}NUM_ACTV_PTNT) - sum({$<[Time Bucket Name] = GetFieldSelections([Time Bucket Name]), [Time Bucket Type] = {'PREVIOUS'}, [TA Sort Order] =>}NUM_ACTV_PTNT))

use this code

hope this helps

Re: set analysis(urgent)

Mon, 13 Aug 2012 08:58:58 GMT

I updated Sunil Chauhan's expression a bit, to support cases in which the field EMP has spaces in the field. See attached example.

Re: set analysis(urgent)

SunilChauhan — Mon, 13 Aug 2012 09:01:32 GMT

its working i thing

what is your problem now

Re: set analysis(urgent)

Mon, 13 Aug 2012 09:08:17 GMT

Thanks for the reply guys but it isn't working for me.

Re: set analysis(urgent)

Mon, 13 Aug 2012 09:19:57 GMT

Can you give some more details?

Ideally a sample QVW, but otherwise a description of what's going wrong?

Re: set analysis(urgent)

senpradip007 — Mon, 13 Aug 2012 09:28:38 GMT

Hi aaabbb,

You can use this. Please go through the attachment.

Cheers

Pradip