Hello,

I have following table:

I would like to have 3 columns in my application according to following rules:

If planned end date > calculated delivery date then Sum the Quantity and show it as  "late orders"

If planned end date = calculated delivery date then Sum the Quantity and show it as  "on time orders"

If planned end date < calculated delivery date then Sum the Quantity and show it as "in advance"

Could you please help?

thanks in advance and regards

Hi there,

I have a table like the following (generalised data):

With an extract of relevant pairs as follows (assume that a and d are pairs that indicate the start and end of relevant data):

These tables continue for multiple rows, and there are multiple instances of "a" and "d" with data in between.

The positions and counts of a and d can change depending on the source data.

I wish to load the above table but include the data that appears between the pairs, i.e:

What is the easiest way to solve this? I figure I might be able to use a loop that relies on the StringCount, but wondering what ideas you have.

Cheers,

Prog

Hi - Right now we have Qliksense enterprise May 2022 version.

Does anyone know when will be the updated version of Qliksense enterprise release planned?

Thanks

buenas trades 

quiero ver si me pueden apoyar en poder limitar la carga de informacion de solo tres años en mi QVD, ya que actualmete me carga todo el Historico

G_Table:
LOAD OrigenTabla,
ID,
Mov,
MovOrigen,
MovOrigenID,
MovID,
FechaEmision,
FechaRegistro,
VentaUsr,
FechaFinConteo,
FechaInicioConteo,
MovConcepto,
Proyecto,
UEN,
Upper(Cliente) as Cliente,
ClienteEnviarA,
Almacen,
len(Almacen) as AN,
Articulo,
OpcionSubCuenta,
Cantidad,
Observaciones,
Referencia,
Estatus,
Agente,
OrdenCompra,
Causa,
Precio,
Ejercicio,
Periodo,
PrecioUnitario,
SubTotalVentas,
RFC,
ClaveOpcionVenta,
ClaseClaveOpcion,
ListaPreciosEsp,
Fabricante

FROM
[C:\Users\doc02\Desktop\Qvd\1\MovimientosV1.qvd]
(qvd)Where Sucursal = '1'
and not UEN= '1' and not UEN ='6' and not UEN ='7'
and FechaEmision <= '01/01/2019' and Estatus= 'CONCLUIDO' and Cliente <>'CMEX1871';

quiero cargar 2017, 2018, y 2019 solamente ?

espero me puedan apoyar

Is there any way to disable or make a chart unclickable/uninteractable in qliksense?  Believe it or not, I've been given a requirement to render a chart unclickable if possible. The end user wants it static.

Thanks,

Hi All, 

Not sure if I've assigned this to the correct location but I'm not sure where to look. 

I'm trying to figure out when a connection has been created or assigned to a specific user, then that person leaves the company, what happens to that connection? 

When I've created connections in the past, I've always gone to the QMC and changed the owner to sa_repository and then removed the owner from the name but this is purely because when I was brand new to Qlik, the person before me did this. 

Is there a best practice for things like this and if so, are there any useful resources or links available?

Many thanks, 

V