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

I have a map below, which related food to fcode. fcode is the key that links multiple tables together.

map1:

[food,fcode

apple,a

apple-pie,a

banana,b

banana-float,b

cherry,c

cherry-coke,c];

Let's say

Table 1 -uses fruits (applymap() can be used to turn food into fcode)

Table 2 -uses fcode (can not reverse into food)

Table 3 -uses fcode (can not reverse into food)

How can i create a filter, such that:

1. the filter display the food values. (i.e apple-pie and not 'a')

2. When selecting food values, the filter is applied to all tables (1,2,3). I.e if I select apple-pie (or apple), the filter also set  fcode to 'a' and table 2,3 will display only information relating to 'a'. Note that it is accepted for either apple-pie or apple to be selected to filter for fcode 'a'

If I use applymap() on table 1, and filter by fcode, i lose context for my users who only understands food.

Hello,

similar to my first question, I am applying default filter to my sheet but this time I have several filters. so I wanted to apply actions to my sheet again.

First filter:

Action : select values in a field

Filed name: FY

The value I want to show is the current year, so I wrote this formula in the value section:

FY= '$(=Year(Today()))'

Second filter:

Action : select values in a field

Field: Period

The value I want to show is the pervious month, so I wrote this formula in the value section:

Period='$(=MonthStart(Today(), -1))'

other filters:

Action : select values in a field
Field: ACC_Type
Value: A

Action : select values in a field
Filed: Level
Value: Level 1

when I exit and come back to the sheet, by default ACC_Type and Level filter the sheet and select A and 1, but FY and Period won't be applied.

Just to try, I removed the formulas and instead just put 2024 as value for FY and 3 as value for Period, and it worked. It filters the table by default when I open the sheet, However, that is not what users wants. They want a dynamic default filter.

let me know how to resolve this.

thank you for your help in advance!!

Hello:

We have a need to transform as we replicate using a 3rd party transformer that provides an API. Is there a way to invoke an API for each row as it is being replicated?

Thanks,

Manas.

Tenho a seguinte situação:

Para cada registro tenho um COD, e um ano_inicio e ano Fim, preciso que crie pra cada COD, as linhas informando que ele permaneceu de ano_inicio até ano_fim.

Exemplo:

COD | ANO_INICIO | ANO_FIM

1       |  2002             | 2005

2       |  2006             | 2008

Resultado esperado:

COD | ANO_PERMANC

1       |  2002           

1       |  2003

1       |  2004

1       |  2005

2       |  2006

2       |  2007

2       |  2008

Consegui fazer quando no LOAD filtro apenas um COD, segue QVW.

Hello everyone, 

please refer to snapshot , the input table has dates and classification column along with other columns. I want to create this shown output where latest classification is selected for each key as per week

note: week starts on Mon and ends on Sun. And I have highlighted dates falling in same week.

I want to do it at script level only.

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. 

I've got an automation that uses the GitHub connection. It works fine and then all of a sudden stops working. It seems to be a permissions/token thing from Github, but I cannot find a simple way to fix it. I cannot refresh the connection, I cannot delete the connection and re-connect without first deleting the automations that uses the connection. So, the only way I have currently to fix this issue is to: 1. delete all automations that uses the connection, 2. delete the connection, 3. re-import the automation, 4. re-establish the github connection (and 5. since we trigger the automations from github, reset the variables and settings to match the new instance of the automation). This is an extremely time consuming process to have to do every couple of weeks or so (yes, the connection seems to be failing within a month). Is there anyway to refresh/update the permissions for the github connection without having to just nuke everything and re-build it?

I have sections in my data load script.

Currently, I have two sections, and they are pulling data from entirely different tables. However, they appeared to be linked. When I go to the pivot, it pulls data based on a selection of the other sections.

How can I have each data pulled from their respective sections?

Also, it is slowing the application.