Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
sspawar88
Creator II
Creator II

Variable Creation

Can we add the following expression in Variable like this :

Let VCount= 'Count({$<param_name={'Temperature'},param_value={'<=-1'},region_name=>}param_value)';

7 Replies
giakoum
Partner - Master II
Partner - Master II

LET will try to evaluate it. If you just want it as text, use SET

if you then use $(VCount) in a chart expression, it will be evaluated there

alexandros17
Partner - Champion III
Partner - Champion III

Yes but maybe you need SET instead of LET

jonathandienst
Partner - Champion III
Partner - Champion III

Use a pair of single quotes to embed a single quote in the expression:

Set VCount= 'Count({$<param_name={''Temperature''},param_value={''<=-1''},region_name=>}param_value)';

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
jagan
Luminary Alumni
Luminary Alumni

Hi Satish,

LET will evaluate the expression so use SET like below

SET VCount= Count({$<param_name={'Temperature'},param_value={'<=-1'},region_name=>}param_value);


Hope this helps you.


Regards,

Jagan.



sspawar88
Creator II
Creator II
Author

Hi Jonathan,

if i want to use some region_name={'WEST'} in my set analysis.

then how my variable deal with such data ?

Can you explain?

sspawar88
Creator II
Creator II
Author

Hi Jagan,

if i want to use some region_name={'WEST'} in my set analysis.

then how my variable deal with such data ?

Can you explain?

jagan
Luminary Alumni
Luminary Alumni

Try like this


SET VCount= Count({$<param_name={'Temperature'},param_value={'<=-1'},region_name={'WEST'}>}param_value);