topic Re: Using Function in Set Analysis in QlikView

Using Function in Set Analysis

chhavi376 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

=sum({<pat_id =

$(=

Replace(

vInclude,

'P({<TypeDesc={'&chr(39)&TypeDesc&chr(39)&'},'&'Value={'&chr(39)&'1'&chr(39)&'}>}pat_id)',

'P({<TypeDesc={'&chr(39)&TypeDesc&chr(39)&'},'&'Value={'&chr(39)&'*'&chr(39)&'}>}pat_id)'

))

>}Value)

I wanted to use a function in set analysis (Please refer to the expression above)

But it seems that the function is not rightly calculated.

is there a way to fix this?

regards,

Chhavi

Re: Using Function in Set Analysis

felipedl — Wed, 02 May 2018 10:36:37 GMT

Hi Chavi,

As a guess, you're missing the starting / ending bracket for the set analysis expression

=sum({<pat_id =

$(=

Replace(

vInclude,

'P({<TypeDesc={'&chr(39)&TypeDesc&chr(39)&'},'&'Value={'&chr(39)&'1'&chr(39)&'}>}pat_id)',

'P({<TypeDesc={'&chr(39)&TypeDesc&chr(39)&'},'&'Value={'&chr(39)&'*'&chr(39)&'}>}pat_id)'

))

>}Value)

Felipe.

Re: Using Function in Set Analysis

chhavi376 — Wed, 02 May 2018 10:41:25 GMT

Hey,

That was a copy paste error,

This gives me result as '0', Still does not work properly.

Re: Using Function in Set Analysis

felipedl — Wed, 02 May 2018 10:57:33 GMT

See what your expression is returning, put a table chart and paste the expression, to check whats being evaluated.

Example:

As a side note, im assuming that the expression you're using with the identation is getting a false error, this expression worked for me:

sum({<pat_id =

{"$(=Replace(vInclude,

'P({<TypeDesc={'&chr(39)&TypeDesc&chr(39)&'},'&'Value={'&chr(39)&'1'&chr(39)&'}>}pat_id)',

'P({<TypeDesc={'&chr(39)&TypeDesc&chr(39)&'},'&'Value={'&chr(39)&'*'&chr(39)&'}>}pat_id)'))"}

>}Value)

and gave me the picture result, with vInclude having value 1 and using the bellow code for dummy data:

load * Inline
[
pat_id,TypeDesc,Value
x,A,1
2,B,10
1,C,100
]

Felipe.

Re: Using Function in Set Analysis

sunny_talwar — Wed, 02 May 2018 11:19:34 GMT

Would you be able to share a sample to show what exactly are you trying to accomplish?

Re: Using Function in Set Analysis

chhavi376 — Wed, 02 May 2018 11:41:52 GMT

Hi Sunny,

I am attaching the test App

PFB the example to explain the functionality of 'Exp2':

When nothing is selected:

the moment I select anything from Include/Exclude Filters, the value in Exp1 which was appearing befor the selection of that particular filter should appear in Exp2

now if i select anything from Exclude (Say cardiac) the value in Exp2 should be '-1' (Exp1 for cardiac in the above screenshot)

I am trying to use the column 'Test' in the set analysis used in Exp2

Re: Using Function in Set Analysis

sunny_talwar — Wed, 02 May 2018 11:51:57 GMT

Is this sort of what you are looking to do?