topic Re: Variable Creating weird Problem in QlikView

Variable Creating weird Problem

krishna20 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Folks,

My Variable in APP is creating weird issue.

In Variable overview I declared values.

vADMINNTNAME = '001\A','002\B','003\C','004\D';

Dummy:
LOAD CONCAT(CHR(39) & ADMIN_NTNAME & CHR(39),',') AS ADMIN_NTNAME1
RESIDENT ADMINUser;

LET vADMINNTNAME = PEEK('ADMIN_NTNAME1',0);

Test:

LOAD distinct concat(Chr(39)&NTNAME&Chr(39),',') as USER1
Resident Security
Where ACCESS = 'USER'
and wildmatch(upper(NTNAME),$(vADMINNTNAME))=0;

In the above script $(vADMINNTNAME) is creating issue.

I have not changed anything. The same code is using in two different environments.The application is not reloading . It's working in one environment and not in another environment.

Log file :

Where ACCESS = 'USER'

03/08/2016 19:49:35: 0289 and wildmatch(upper(NTNAME),)=0

03/08/2016 19:49:35: Error: Error in expression:

I tried by using '$(vADMINNTNAME)' also , app is refreshing fine but objects are overlapping to users.

Please anyone can light up on this issue.

Updated log file error :

Re: Variable Creating weird Problem

Mark_Little — Wed, 03 Aug 2016 12:58:29 GMT

HI,

What is the weird issue?

Do you get an error message?

If you add a trace command after the variable is created what is returned?

I.e. Trace $(vADMINNTNAME);

Mark

Re: Variable Creating weird Problem

sunny_talwar — Wed, 03 Aug 2016 12:59:18 GMT

How about without dollar sign expansion?

and WildMatch(Upper(NTNAME), vADMINNTNAME) = 0;

Re: Variable Creating weird Problem

ThornOfCrowns — Wed, 03 Aug 2016 12:59:47 GMT

Try here for the syntax:

Variables in an Array | Qlik Community

Re: Variable Creating weird Problem

krishna20 — Wed, 03 Aug 2016 13:04:03 GMT

I tried Trace, it's raising error as field not found.

Re: Variable Creating weird Problem

krishna20 — Wed, 03 Aug 2016 13:04:55 GMT

Hi Sunny,

Used that and it's raising error as field not found. Please find the log file error in parent thread

Re: Variable Creating weird Problem

Anonymous — Wed, 03 Aug 2016 13:06:24 GMT

only a typo error?

vADMINNTNAME = '001\A','002\B','003\C','004\D';

LOAD CONCAT(CHR(39) & ADMIN_NTNAME & CHR(39),',') AS ADMIN_NTNAME1

where does ADMIN_NTNAME is coming from??

wildmatch(upper(NTNAME),$(vADMINNTNAME))=

your log says

03/08/2016 19:49:35: 0289 and wildmatch(upper(NTNAME),)=0

obviously vADMINNTNAME contains empty string

Re: Variable Creating weird Problem

Mark_Little — Wed, 03 Aug 2016 13:08:55 GMT

HI,

Field not found would point to an issue with the field probably the NTNAME field and not the variable.

I would check that these are correct and present in the data, the spelt correct and are the same case.

Mark

Re: Variable Creating weird Problem

krishna20 — Wed, 03 Aug 2016 13:12:29 GMT

Hi Rudolf,

ADMIN_NTNAME is coming from RESIDENT ADMINUser;

ADMIN_NTNAME it's a field combination of Domain and NTLOGIN

Re: Variable Creating weird Problem

Anil_Babu_Samineni — Wed, 03 Aug 2016 13:12:42 GMT

Might be Here is the Problem,

vADMINNTNAME = "001\A","002\B","003\C","004\D";

Re: Variable Creating weird Problem

krishna20 — Wed, 03 Aug 2016 13:13:29 GMT

The same code is finely running in testing but not in production.

Re: Variable Creating weird Problem

Anonymous — Wed, 03 Aug 2016 13:22:57 GMT

where is the difference between resident ADMINUser on TEST and PROD?

your log comes from TEST and Shows that vADMINNTNAME is empty

debug your code and look what is invariable after this line

LET vADMINNTNAME = PEEK('ADMIN_NTNAME1',0);

Re: Variable Creating weird Problem

krishna20 — Wed, 03 Aug 2016 13:26:29 GMT

No coding difference between TEST and PROD.

I just copied file from TEST to PROD. This issue is raised. I tried to debug, it's show the same.

Re: Variable Creating weird Problem

Anil_Babu_Samineni — Wed, 03 Aug 2016 13:31:05 GMT

Wildcard looks , Try to remove or add that Variable over there

Re: Variable Creating weird Problem

krishna20 — Wed, 03 Aug 2016 13:51:31 GMT

Hi Anil,

It not works.

Re: Variable Creating weird Problem

Mark_Little — Wed, 03 Aug 2016 14:11:51 GMT

Hi,

From the screen grab above you can see that your variable is not being populated.

thus the part wildmatch(upper(NTNAME),)=0

I would try the below.

Dummy:
LOAD CONCAT(CHR(39) & ADMIN_NTNAME & CHR(39),',') AS ADMIN_NTNAME1
RESIDENT ADMINUser;

LET vADMINNTNAME = PEEK('ADMIN_NTNAME1',0,'Dummy');

Trace $(vADMINNTNAME);

Test:

LOAD distinct concat(Chr(39)&NTNAME&Chr(39),',') as USER1
Resident Security
Where ACCESS = 'USER'
and wildmatch(upper(NTNAME),$(vADMINNTNAME))=0;

If the variable is still not being populated then you need make Sure you are getting the required data in the ADMIN_NTNAME1 field.

Add an exit script after the Resident and check what values are in the field.

Mark