Hi,

I get these issues when trying to cycle a report over a dimension. And for each run I get different reports that fails, so there seems to be no consistency between the runs. 

I have checked the documentation in https://support.qlik.com/articles/000086598 and followed the list of suggestions.

I have no user filters and only a few object filters in the report. The object filters do not conflict in the Qlik Sense application where the data is being fetched from. 

But since it is different reports that failes for each run it shouldn't be the filter that conflicts with the cycled dimension in my opinion.

Hi everyone,

I'm trying to use Dynamic Views on Qlik Sense 2020 patch 3, I can see the button dynamic Views in sheet edition mode from centralnode but it disappears when i'm accessing from an engine.

Can anyone helps please ?

Thank you,

Regards,

Mehdi

hi all,

so as I understand I cannot use AutonumberHash if the data gets reloaded in 2 separate reloads. What I've seen from Help files is that I should use Hash128 etc, but that returns fields that are very long...

What do you do guys generally do to get a persistent value across loads?

Thanks

Hello,

I have a python script that retrieves the load script from each app in our repository through the JSON API, using certificate authentication. It runs fine for every app except a handful that have section access. I get this response from the API:

{"jsonrpc":"2.0","id":2,"error":{"code":5,"parameter":"","message":"Access denied"}}

Does certificate authentication not give root access to apps? The user account I'm plugging into the authentication header does not have access to these apps, but the script does not get any such error when I run it from a scheduled task on a separate server, using the same user account. However, when I run the script adhoc on the server as an admin, I get the access denied errors.

I found this post Open app error - access denied but I did not find any extra spaces around the section access code.

Hi All,

I need some help in alternate state function. I need to apply both alternate state filter and also common filter into bar chart. Let me know if you know how to perform both filters on Qliksense. Herewith I have attached the picture of issue clearly.

I have an app where I need a column to return "No" for items older than 90 days. I am using the following to create this:

if(LastConnectionTime>=Today()-90, 'No', 'Yes')

Result:

It is working, but it is inaccurate. It is returning "Yes" for items newer than September 2020. As of the posting of this question, 90 days prior to today is January 14, 2021. 

I'm also a bit confused about why I need to use ">" and not "<", but when I use "<" it returns "No" for current date through Sept 2020 and "Yes" for dates Sept 2020 and prior, so I guess ">" is correct? At this point, I am very confused. 

Hello all,

I would like to load many Excel files, but they have different tab names. There has been a change in the source system, hence the difference in names.

The problem is that I cannot identify which sheet name to use by looking at the excel file.

My current code is like this:

for each vfile in dirlist(...)
for each vsheet in 'sheet1', 'sheet_1'

Excel:
load
...
...
from...
...

next vsheet;
next vfile;

Works, but of course I get errors that data is not found if the wrong register name is used.

As an interim solution, I temporarily switch off the error messages via errormode=0 or 1.

I have searched the community, but only found helpful information as soon as you can use odbc.In my case this is unfortunately not possible because we use LibreOffice, so the excel odbc driver is not installed.

Does anyone else have an idea, without errormode etc.?

Thanks and greetings