topic Re: Variable Creation in QlikView

Variable Creation

sspawar88 — Fri, 26 Jun 2015 08:16:05 GMT

Can we add the following expression in Variable like this :

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

giakoum — Fri, 26 Jun 2015 08:19:20 GMT

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 — Fri, 26 Jun 2015 08:23:39 GMT

Yes but maybe you need SET instead of LET

jonathandienst — Fri, 26 Jun 2015 08:29:04 GMT

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)';

jagan — Fri, 26 Jun 2015 09:26:08 GMT

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 — Wed, 01 Jul 2015 10:57:42 GMT

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 — Wed, 01 Jul 2015 10:58:26 GMT

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 — Wed, 01 Jul 2015 14:47:57 GMT

Try like this

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