Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Hey,
That was a copy paste error,
This gives me result as '0', Still does not work properly.
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.
Would you be able to share a sample to show what exactly are you trying to accomplish?
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
Is this sort of what you are looking to do?