We are trying to do CDC process in qlik with ODBC connection and backend is ProgressDB.

For CDC we found in source connections, under Change processing we have Context Column settings and Expressions to identify Update and Delete Operations.

What is the definition of context column, what if we have all the column at source apart from primary key any non-primary key changes how will qlik identify the changes. Is it possible or do we have to ive update expression.

and if we have to provide update expression please let provide us an example how the update expression.

Thanks,

snigdha

Hi,

This is my first partipation in the Forum. I need some help with my app.

I have a master measure to count dengue cases from December 2022 to April 2023. The problem is that to filter the months I use a variable that contains the aggregation with an analysis set that filters the months, and I call it as a function with the year as a parameter (to be able to apply it to 2023/24) but with this I end up taking the months of the year that passed as a parameter, that is, if it is 2023 it takes: January, February, March, April and December, instead of taking : December (2022), January, February, March and April, that is, December is also 2023. 

I tried to solve it by making a condition in my master measure so that when the month is December, I pass the previous year and the month of December as parameters, and if the month is any of the remaining months, I pass the current year and those months. I think it can work but when I spend several months as the 2nd parameter, it cuts off at the first comma it finds.

I give you a bit of the code of how I have proposed it. Notice for the abbreviations and names of variables, measures and dimensions are in Spanish

My master measure

if(Mes='Dic',${vCantCasos(2022,'Dic')},${vCantCasos(2023,${vSetMesesSinDi})})

The error

 

First simple solution but didnt work by the single quotes:

 

='Ene,Feb, Mar, Abr' (this would be a variable)

 

Second solution that almost work but I have the issue with the comma:

 

 

 Finally, I share this other alternative because I need for the set analysis for the month values ​​to be passed as strings with single quotes, but from the beginning it did not work (I also share the error it gives me).

 

 

I don't know how to move forward and I've already looked for the solution but I can't find anything that is useful to me. I hope that with what I shared you can understand everything and someone can give me a hand. From already thank you very much

 

 

 

I can not get my QlikView desktop (edition info below) to lease a license from the server.  When trying to connect to the server I get this pop up error.  What am I doing wrong?

========================= QlikView Info ==========================
Client Version
Server Version
QlikTech Product QlikView 64-bit Edition (x64)
License Key [Personal Edition]
Production Date 2024-01-01
QV_BUILD_INFO release/QV12-80/55
PE Recoveries Remaining 1
CPU Target x64
======================= Local System Info ========================
Operating System Microsoft Windows 10 Pro (64 bit edition)
Operating System Version 10.0.19045
Wow64 mode Not using Wow64
IE Version 11.3636.19041.0
MDAC Version 6.3.9600.16384
MDAC Full Install Version 6.3.9600.16384
ComCtl32 version 6.16.10586
Current Theme C:\windows\resources\themes\Aero\Aero.msstyles
Graphics 1 1920*1080 pixels. 2 Monitors.
Graphics 2 32 Bit Color Depth. 96 XDpi. 96 YDpi.
Local Time 2024-05-09 15:46
GMT Time 2024-05-09 20:46
Country USA United States United States
Language 0409 English English
Physical RAM(MB) 16016
VMCommitted(MB) 88
VMAllocated(MB) 4983
VMFree(MB) 6378
VMLargestFreeBlock(MB) 6378
RecommendedFree(MB) 0
Number of CPUs 12
CPU 0 13th Gen Intel(R) Core(TM) i5-1345U 2496MHz
CPU 1 13th Gen Intel(R) Core(TM) i5-1345U 2496MHz
CPU 2 13th Gen Intel(R) Core(TM) i5-1345U 2496MHz
CPU 3 13th Gen Intel(R) Core(TM) i5-1345U 2496MHz
CPU 4 13th Gen Intel(R) Core(TM) i5-1345U 2496MHz
CPU 5 13th Gen Intel(R) Core(TM) i5-1345U 2496MHz
CPU 6 13th Gen Intel(R) Core(TM) i5-1345U 2496MHz
CPU 7 13th Gen Intel(R) Core(TM) i5-1345U 2496MHz
CPU 8 13th Gen Intel(R) Core(TM) i5-1345U 2496MHz
CPU 9 13th Gen Intel(R) Core(TM) i5-1345U 2496MHz
CPU 10 13th Gen Intel(R) Core(TM) i5-1345U 2496MHz
CPU 11 13th Gen Intel(R) Core(TM) i5-1345U 2496MHz

Good afternoon, I'm trying to make a comparison between the current period - past period / past period * 100. The goal is to obtain the variation in sales in %. For example, in my filter, I'm comparing the same period in different years: February 2023 and February 2024.

THE EXPRESSION I'M USING IS:

( ( Sum({<Ano_DC={"$(VAnoAtual_DC)"}, Mes_DC={"$(VMesAtual_DC)"}>} TOTAL_ITEM_DC) - Sum({<Ano_DC={" $(VAnoAnterior)"}, Mes_DC={"$(VMesAtual_DC)"}>} TOTAL_ITEM_DC) ) ) / Soma({<Ano_DC= {"$(VAnoAtual_DC)"}, Mes_DC={"$(VMesAtual_DC)"}> } TOTAL_ITEM_DC)

VARs
VAnoAtual_DC:
=MAX(Ano_DC)
VAnoAnterior:
=MAX(Ano_DC) -1
VMesAtual_DC:
=MAX(Mes_DC)

Boa tarde, Estou tentando fazer uma comparação entre o período atual - período passado / período passado * 100, o objetivo é conseguir uma variação de vendas em %, por exemplo, em meu filtro estou comparando o mesmo período em anos diferentes Fevereiro de 2023 e Fevereiro de 2024

A EXPRESSÃO QUE ESTOU USANDO É: 

( ( Sum({<Ano_DC={"$(VAnoAtual_DC)"}, Mes_DC={"$(VMesAtual_DC)"}>} TOTAL_ITEM_DC) - Sum({<Ano_DC={" $(VAnoAnterior)"}, Mes_DC={"$(VMesAtual_DC)"}>} TOTAL_ITEM_DC) ) ) / Soma({<Ano_DC= {"$(VAnoAtual_DC)"}, Mes_DC={"$(VMesAtual_DC)"}> } TOTAL_ITEM_DC)

ENVIANDO AS VARIAVEIS
VAnoAtual_DC:
=MAX(Ano_DC)
VAnoAnterior:
=MAX(Ano_DC) -1
VMesAtual_DC:
=MAX(Mes_DC)
 

Hi all, 

I have this sample dataset from one source.  I want to show in a straight chart, just the Store and Systems columns.  But I want them to be filtered by the dimension Function that has the value of only 'Fixed Ops'.  Any help here would be appreciated, thanks in advance!

Buena tarde.

Estoy haciendo un modelo con qlikview  v11. Como puedo poner un filtro fijo a una tabla y en una segunda tabla poner otro filtro. En ambos casos el filtro es sobre el mismo campo. Por ejemplo.

Tengo una tabla simple que tiene como dimensión: Catálogo

Sus valores de la dimensión Catálogo son: Pago, Devolución, Nota de Crédito

Entonces, quiero tener una tabla con un filtro fijo, el valor Pago. Que la tabla solo muestre el resultado de valores que tengan que ver con ese valor y en la segunda tabla que muestre Devolución y Nota de crédito.

Saludos

Buenas tardes, tengo un detalle en mi servidor, anteriormente ya me había pasado, investigando en el foro, encontré que el que provocaba el problema era el protocolo (TCP/IPV6), lo que hice fue desactivarlo desde el adaptador ethernet y solo dejar el (TCP/IPVv4 ), reinicie servicios y con eso se soluciono. 

Ahora me volvió a suceder despues de mas de un año, pero no he podido encontrar la solución, lo ultimo que he realizado es intentar modificar el archivo 

pg_hba.conf de la ruta C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\9.6

# TYPE DATABASE USER ADDRESS METHOD

# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
host all all ::1/128 md5
# Allow replication connections from localhost, by a user with the
# replication privilege.
#host replication postgres 127.0.0.1/32 md5
#host replication postgres ::1/128 md5

host all all fe80::3154:e42:5c:875%7/128 md5

host all all 172.17.52.237/32 md5

La ip es la misma, ayuda 😞 

Hello,

I have been working with the Qlik Sense Repository API and making API calls using Postman. Currently, I am trying to make an API call that will update a user's Custom Property values. For example, if a user has Custom Property "UserAppAccess" which allows them to see an app, and they already have "App 1" as a value assigned to them through UserAppAccess, I need an API call that can add "App 2" and "App 3" to the CP as well, so that they can see all 3 apps.

I have tried different kinds of requests, but the most success I've had was using a PUT call following a GET call, where the GET call gets the existing custom properties and their values based on a user id, and then the PUT call essentially copies the entire body of the GET call, changes the modifiedDate of the assigned CP to the user (in this case, the date when UserAppAccess was assigned to user) to the current time, copies and pastes the body for the CP values (body for App 1) and then changes the value to App 2, or App 3 etc. and lastly, changes the "id" of the body so that its a different random id. Clearly, this process is not ideal as it relies on randomizing the id of the CP value, and may potentially have conflict with other ids in the env (CPs, Users, Apps etc,?). 

Are there any alternative methods, maybe with PATCH or otherwise, which avoids having to deal with ids and can successfully update a user's assigned Custom Property values? Ideally, it could directly access a CP without dealing with dates, ids etc. and can simply add/remove a CP value.

For reference I am using certificate authentication to a Qlik Sense Enterprise server where I'm RootAdmin.

(Example below of the body for a user's CP where one value, App 1, is assigned. Info anonymized.)

Hi

I'm planning to upgrade the QlikView server and QlikView Publisher, and the version is 12.20. I need to know the best way to upgrade. Furthermore, I would like to upgrade to May 2021. What are your recommendations, please?

Greetings