Call variable in script

asamariaekrickl — Sat, 16 Nov 2024 00:09:05 GMT

I have a variable containing set analysis code. I then want to call this variable in the load script.

The variable is called vNSWIPALOS and the code looks like this:
if(Sum({$<[LHD/SHN]=,Facility=,LHD=, EncounterTypeCode = {' & chr(39) & I & chr(39) &'}>} Counter_Activity)=0, '',
Sum({$<[LHD/SHN]=,Facility=,LHD=>} IPLOS)
/
Sum({$<[LHD/SHN]=,Facility=,LHD=,EncounterTypeCode = {' & chr(39) & I & chr(39) &'}>} Counter_Activity))

I have added the chr(39) to replace the ' to get it work when I call it from the script.

I can't get the app to reload unless I call the variable using single quotes.
Like this:
if(IPLOS <= '$(vNSWIPALOS)' / 3 ,Dual('Short',2)
etc etc in the aim to create a new field.

The problem is that that new field comes out empty after the reload instead of containing the value Short etc.

Any ideas what I need to change to get this to work?

Thanks in advance

Asa

Re: Call variable in script

tresB — Thu, 13 Aug 2020 12:20:36 GMT

Set analysis doesn't work in load script.

topic Re: Call variable in script in QlikView

Call variable in script

Re: Call variable in script