topic Re: Variable Creation in QlikView

Variable Creation

sspawar88 — Wed, 22 Jul 2015 09:34:12 GMT

Hi Community,

Here i want to optimize Following line of Code which i have been put into Gauge Chart.

Count({<param_name={'TEMP'},branch_type={'*'},loc_subtype-={'2'},status_subcode-={'1'},param_value={'<=-18'}>}param_value)/

Count({<param_name={'TEMP'},branch_type={'*'},loc_subtype-={'2'},status_subcode-={'1'},param_value={'<=-1'}>}param_value)

is it right,When i Create Variable like:

Set VindPanN='Count({<param_name={'TEMP'},branch_type={'*'},loc_subtype-={'2'},status_subcode-={'1'},param_value={'<=-18'}>}param_value)';

Set VindPanD='Count({<param_name={'TEMP'},branch_type={'*'},loc_subtype-={'2'},status_subcode-={'1'},param_value={'<=-1'}>}param_value)';

& use this in my Expression of Gauge Chart as

$(VindPanN)/

$(VindPanD)

it is not working.

what changes i need to put into variable creation method?

Re: Variable Creation

marcus_malinow — Wed, 22 Jul 2015 09:39:47 GMT

Satish, if you look in the Variable Overview screen (Ctral + alt + V), what values do you see in these variables?

Re: Variable Creation

sspawar88 — Wed, 22 Jul 2015 09:41:29 GMT

Actually i'm working in Qlik sense.

and there is no options like Ctrl+Alt+V in this version.

so that i'm trying to create it at script.

Re: Variable Creation

Wed, 22 Jul 2015 09:43:19 GMT

Hi Satish,

remove the opening and closing ' within your set statements and give that a try

Set VindPanN=Count({<param_name={'TEMP'},branch_type={'*'},loc_subtype-={'2'},status_subcode-={'1'},param_value={'<=-18'}>}param_value);

Set VindPanD=Count({<param_name={'TEMP'},branch_type={'*'},loc_subtype-={'2'},status_subcode-={'1'},param_value={'<=-1'}>}param_value);

Joe

Re: Variable Creation

marcus_malinow — Wed, 22 Jul 2015 09:46:59 GMT

OK, Try This.

the single quotes are causing your expression to be truncated. Replacing with chr(39) (single quote character code) should work

Set VindPanN='Count({<param_name={' & chr(39) & 'TEMP' & chr(39) & '},branch_type={' & chr(39) & '*' & chr(39) & '},loc_subtype-={' & chr(39) & '2' & chr(39) & '},status_subcode-={' & chr(39) & '1' & chr(39) & '},param_value={' & chr(39) & '<=-18' & chr(39) & '}>}param_value)';

Set VindPanD='Count({<param_name={' & chr(39) & 'TEMP' & chr(39) & '},branch_type={' & chr(39) & '*' & chr(39) & '},loc_subtype-={' & chr(39) & '2' & chr(39) & '},status_subcode-={' & chr(39) & '1' & chr(39) & '},param_value={' & chr(39) & '<=-1' & chr(39) & '}>}param_value)';

Re: Variable Creation

sspawar88 — Wed, 22 Jul 2015 09:59:01 GMT

Thanks Marcus.