What API should I use if I want to obtain a list of all my datasources in Qlik? For example, I configured a Postgres connection and extracted 2 tables. Now I would like to get this info from the API - table names, table columns. 

Hello community, I need to calculate the time between alarm records as expressed in the green column of the following table:

Alarm logs occur on different dates, locations and have different alarm descriptions. I need to calculate the time between the ALM type alarm and the RTN type alarm of the same location and description, and for cases where the last alarm record is of the ALM type (ID:2) I must calculate from the moment I am analyzing (in this case 02/24/2024 00:00). Thank you in advance for any kind of help you can give me.

Hi all,

My Qlik Cloud OneDrive data source connection was working properly, and then all of a sudden, my reload tasks started failing & when I try to extract data from any of my existing files in it, I am getting this error message 

I can still access the OneDrive folder from the load script & see my files. But when I try to pull any one of them in, I am receiving that error message.

Any knowledge on how & why this is happening?

Thank you

Hi, I'm working with Qlik Sense SaaS using an OAuth2 connection to one of my tenants with Python3 in Ubuntu.

The handshake works fine and I'm able to hit the rest connector and get information about my managed spaces.

#Sending params to the API request
payload={'type':'managed'}
response = client.rest(path="/spaces", method="get",params=payload).json()
print(json.dumps(response, indent=4, separators=(". ", " = ")))

I've now tried creating a space. My code is as follows and fails with a bad request error:

payload={"name":"string","type":"shared","description":"string"}
response = client.rest(path="/spaces", method="post", params=payload)
print(response)

I'm hopeful it's a simple fix. The scope I'm using is admin_classic 

Any help would be appreciated!

Hi,

In the Qlik app 'License Monitor', all my users on the 'User Detail' sheet are UNKNOWN.

I have looked in the load editor script and I can see that there is a mapping table to retrieve the user's name. Looking at the information the responses returned for both tables, the user id's do not match leading to the default value in the ApplyMap.

Does anyone has any idea why this may be happening?

Thanks,

Amy 

Olá a todos,  sou novo aqui e não tenho muita experiencia,  ouvi falar que existe uma feramenta para gestão de documents cal  mas não a encontrei para baixar... alguém tem o instalador?  na licença da empresa que trabalho diz que todas estão em uso mas só consigo ver 15. as outras devem estar perdidas/alocadas em algum lugar. poderiam me ajuda?

Hello, Hive Mind, I need your help! I need a Barchart that allows me to format the color of the bars independently via different measures. My example is displaying the productivity of a machine operator vs his goals for a shift. The goal will be a constant - set within the load script, and the customer wants it to be Green, while the other measure is the number of units produced, which needs to be red until it reaches the same value as the goal, at which time it should turn green.

With the standard Barchart included with Qlik sense, I can use the color by Expression to do what is needed for the units produced, but cannot find a way to color the Goal bar a different color while the units produced is Red. 

Anyone have an idea or seen an extension that will allow this?

In our system, there are two single select fields with a parent-child relationship. Selection of the parent with single unique child is not possible, because that particular child selection is not possible as its unique and is not available for the currently selected parent and that particular parent selection  is not possible as it has only one child.Is there a solution that allows users to make this selections.

And even if the selection is made possible by default , it creates a locked scenario where the user cannot alter the selection. This occurs because the parent has only one child, leaving no other options available. Is there a solution that allows users to make different selections in this scenario.

I have a QV report that I inherited.  It uses an Excel template to read in the left side row labels and the expressions for each cell.  Then there is an inline table

This is the excel template-

Then the inline table -

Then the table uses _metric as a dimension.  Here is the QV report

I am trying to format the row labels with indentation.  I can make them bold by including

<b> in the _Format column.

I want to indent particular rows like such –

I have tried to use the format column and &nbsp to insert spaces, but that did not work

Is this possible to do ?

Any thoughts on this would be greatly appreciated.

Thanks,

Brian