Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

chavanqlik
New Contributor II

Qlik sense desktop holding the session variables

Hello All,

I'm writing a script to load current month from the variable in the load script in Qlik desktop, it works fine,

but the problem is even when I tried to comment the code as below it still holds the value in it.

Let vCurrentMonth = Peek('Qvd_vCurrentMonth',vRecordNo-1,'vCurrentMonth');

lib://modified_processed/$(vCurrentMonth)

//Let current month = Peek('Qvd_vCurrentMonth',vRecordNo-1,'vCurrentMonth');

I tried going to Dev tools removed the local storage, session, and cache but nothing works.

I just found this error,

Failed to clear temp storage: It was determined that certain files are unsafe for access within a Web application, or that too many calls are being made on file resources. SecurityError

Please help me to resolve this issue.

Thanks,

Santosh

9 Replies
Digvijay_Singh
Honored Contributor III

Re: Qlik sense desktop holding the session variables

This should clear the variable storage -


Let vCurrentMonth = ;

chavanqlik
New Contributor II

Re: Qlik sense desktop holding the session variables

Hello Digvijay Singh,

Thanks for your response, but the problem not in the logic and I could write a null condition go with the scripting, the problem it's holding previously cache value in the system (Qlik Desktop), which needs to remove implicitly once we refresh the app, but this not happening in this case.  I still tried to disabling cache in the settings, but no resultserror.PNG

Digvijay_Singh
Honored Contributor III

Re: Qlik sense desktop holding the session variables

Bit confused but , as you mentioned-

"even when I tried to comment the code as below it still holds the value in it."

Just commenting won't clear the value, once the variable is created, it remains in visualization until and unless either you move NULL like I did, or you comment (like you did) as well as remove from the variable window in front end.


stascher
Contributor II

Re: Qlik sense desktop holding the session variables

It's important to remember that reload clears out tables, not variables. Once a variable is defined, either by script or the variable editor, it's (nearly?) impossible to delete it. But you can set it to null as Digvijay Singh indicated.

chavanqlik
New Contributor II

Re: Qlik sense desktop holding the session variables

I agree this bit confusing,  I would like to follow the steps I'm working

The below code loads the variable data from the CSV file as you see below. If you follow closely I've commented my code off and it shouldn't load any data or variables data,

// $(must_include=[lib://scripts/common\SetupVariabes.qvs]);

When I open the app and run the scripts the below $(vCurrentMonth) still hold the past data. Even though I commented on the code, I should get an exception there's no data but it's not happening.

Let vCurrentMonth = Peek('Qvd_vCurrentMonth',vRecordNo-1,'vCurrentMonth');

lib://modified_processed/$(vCurrentMonth)

Is this is the last solution for us,

Let vCurrentMonth = ;

Digvijay_Singh
Honored Contributor III

Re: Qlik sense desktop holding the session variables

What is this below statement doing?

Have you commented this as well?

Let vCurrentMonth = Peek('Qvd_vCurrentMonth',vRecordNo-1,'vCurrentMonth');

Digvijay_Singh
Honored Contributor III

Re: Qlik sense desktop holding the session variables

The format of Peek statement is  like - Peek(field_name[, row_no[, table_name ] ])

Do you have table name as vCurrentMonth as well? We don't keep such names for tables, Check if variable name/table names are conflicting, not sure though..

rittermd
Honored Contributor

Re: Qlik sense desktop holding the session variables

You are kind of stuck.  Once a variable is defined in either version of Qlik Sense it does not go away just because you stopped using it.

You have to go into edit mode and click on the variable button and then manually remove any variables that you don't want to use any longer.

chavanqlik
New Contributor II

Re: Qlik sense desktop holding the session variables

please find the below script, I don't have an issue with my script.  the only problem I have is

holding the previous values. Event though the below script is commented.

  • vCurrentYear,
  • vCurrentMonth,
  • vTableName

// $(must_include=[lib://scripts/common\SetupVariabes.qvs]);


Load

    *

    FROM [lib://modified_processed/$(vCurrentYear)\$(vCurrentMonth)\$(vTableName).csv]

Community Browser