hi all,

I am trying to set up an external task to run .bat file from the qmc but not working for me nor I can see why.

I am able to run the task by double clicking to it using the Qlik service account with no issues. Any idea what do I need t do differently?

Hi,

I'd like to replace in my script some nested previous used to find the last value for a field (in this case, the supply source) in a table that have the values shown below:

Trip Stop Type Source Pickup Delivered

a1 1 1 a 20 null

a1 2 2 null null 11

a1 3 2 null null 6

a1 4 2 null null 2

a1 5 3 b 18 null

a1 6 2 null null 16

a1 7 4 null null 3

This would be a tipical trip, in which there are 4 types of Stops: 1 for initial product pickup, 2 for delivery to customers, 3 for others product pickup (e.g. in a provider) and 4 for product returned to plant.

I need to identify the source for each stop (that would be the previous source untill the truck stop in a provider (changing the source, type 3) and I solve this situation by using nested previous as follow. Could you help me to simplify this scrip? (maybe with peek function or in other way)

Oi galera.

Integrei uma base de dados My SQL de um servidor local no Qlik Cloud.

Algumas tabelas consigo adicionar pelo Gerenciador de dados em outros casos aparecem a mensagem de que os dados não podem ser adicionados.

Eu acho que pode ser Timeout.

Alguém já passou por isso? Podem me dar algumas dicas, sou novato no Qlik.