topic Re: Variables don't work properly in QV12 in QlikView

Variables don't work properly in QV12

Anonymous — Sun, 04 Dec 2016 14:05:08 GMT

Hi,

I have problem loading data in QV12. The document works fine in QV11 and doesn't assign values to variables properly in QV12. There many vars in load script looping. Somewhere vars don't get values or get values of previous loop. Tested on different machines and win platforms. Is it a bug or...? Any idea?

Re: Variables don't work properly in QV12

marcus_sommer — Mon, 05 Dec 2016 11:55:10 GMT

AFAIK nothing had changed by the variable-handling. Please provide the script which creates/assigned the variables.

- Marcus

Re: Variables don't work properly in QV12

Anonymous — Mon, 05 Dec 2016 13:59:03 GMT

Hm-m, I realy don't know how to provide it. It's a big script like a loading consol with several thouthand lines of code and hundreds of variables used in looping sql connections. In short, there are many loops one in the other. Variables get values from excel and in some parts of code like

FOR Each ВидДвижения in '+1', '-1'

LET РегистрБухгалтерии.Типовой.Счет = if(ВидДвижения = '+1', '$(РегистрБухгалтерии.Типовой.СчетДт)', '')
      [Таблица0]:
      select
      ,$(НомерБазы)+$(|)+$(РегистрБухгалтерии.Типовой.Организация)+$(|)   as [Организации.Ссылка]
      ,$(НомерБазы)+$(|)+$(РегистрБухгалтерии.Типовой.Субконто2)+$(|)     as [Склады.Ссылка]
      ,$(НомерБазы)+$(|)+$(РегистрБухгалтерии.Типовой.Субконто1)+$(|)     as [Номенклатура.Ссылка]
      ,$(ВидДвижения)                                                     as [ВидДвижения]
   from $(РегистрБухгалтерии.Типовой)                                     as Типовой      (nolock)
      inner join $(ПланСчетов.Типовой)                                    as ПланСчетов   (nolock)        ;

NEXT ВидДвижения

upper variable ВидДвижения doesn't get value '+1' or '-1'. SQL part is not important, I provided it for example

Re: Variables don't work properly in QV12

marcus_sommer — Mon, 05 Dec 2016 17:48:50 GMT

I believe it will be quite difficult with such script-parts to detect an issue with the variables and think you will need to check each of them within the debugger - whereby could imagine that a quite earlier part from the variable-generation failed, maybe an include-variable is missing or something similar.

- Marcus

Re: Variables don't work properly in QV12

Anonymous — Tue, 06 Dec 2016 04:12:00 GMT

Ya, but as I sad this script works fine in 11 version every day and many month. Trying to load it in 12 get errors. Noticed that some vars are empty, i.e FOR Each Var in... doesn't create Var. And somewhere vars have values of previous creating.

Re: Variables don't work properly in QV12

marcus_sommer — Tue, 06 Dec 2016 05:55:28 GMT

You could try to change your QV 12 release (AFAIK SR2 was quite buggy). Otherwise I'm out of ideas unless to post it here: QlikBug and contact the qoncierge service or the customer portal: QlikView Support launches Qoncierge Service.

- Marcus

Re: Variables don't work properly in QV12

Anonymous — Tue, 06 Dec 2016 08:44:07 GMT

Indeed I tried all releases, including SR5 - the same behavior. May be QlikBug will clarify something). Thank you Marcus.

Re: Variables don't work properly in QV12

Anonymous — Fri, 24 Mar 2017 10:11:06 GMT

The bug is fixed in qv 12.10