Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 😞
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!
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
Buenos dias,
necesito armar un Grafico por mes y por Lugar pero que la ultima columna sea un Total de los otros meses
LUGAR | Mes | Target | Valor Actual | B / (W) |
XXXX | 1 | 52.91416497 | 90 | -61 |
XXXX | 2 | 192.4980829 | 109 | -4 |
XXXX | 3 | 213.8462115 | 210 | -94 |
YYYY | 1 | 57.16937735 | 137 | -105 |
YYYY | 2 | 207.9782521 | 151 | -39 |
YYYY | 3 | 231.0431388 | 122 | 4 |
ZZZZ | 1 | 179.1306451 | 539 | -441 |
ZZZZ | 2 | 651.6649331 | 625 | -273 |
ZZZZ | 3 | 723.934883 | 577 | -185 |
HHHH | 1 | 76.34358409 | 26 | 15 |
HHHH | 2 | 123.3615513 | 24 | 42 |
HHHH | 3 | 307.3236405 | 28 | 138 |
RRRR | 1 | 5.15686373 | 7 | -4 |
RRRR | 2 | 18.76031461 | 7 | 4 |
RRRR | 3 | 20.84084239 | 4 | 7 |
TTTT | 1 | 85.96053278 | 107 | -61 |
TTTT | 2 | 312.71849 | 135 | 35 |
TTTT | 3 | 347.3991187 | 232 | -44 |
YTD | YTD | 3808.044627 | 3131 | -1065 |
El YTD que tengo hoy es el total de los lugares y solo necesito de XXXX
Me podrian ayudar, Muchas gracias!
Hello,
I'd like to add a blank dimension, which mean nothing has to show in that column. What will be the expression for this, or is there any way that I can do this?
The purpose of this is to facilitate the copy of the data in an Excel sheet that has an extra column compare to the original extract in Qlik.
Thanks everyone!
In March of 2024, Snowflake announced that Hybrid Tables are now in QA.
Will the Snowflake target endpoint connector be modified to support replicating data to Hybrid Tables as well as traditional Snowflake tables? Is this on the roadmap?
https://docs.snowflake.com/en/release-notes/2024/other/2024-03-05-hybrid-tables
https://docs.snowflake.com/en/release-notes/2024/other/2024-03-13-hybrid-tables
Bom dia!
Estou tentando criar um campo de comparacao em % em uma tabela dinamica com filtros, onde gostaria de fazer (MES ANTERIOR - MES ATUAL) / MES ANTERIOR por exemplo
mes 1 vendeu-se 499 unidades mes 2 vendeu-se 249 unidades ou seja -50% em comparacao ao mes anterior
oq estou usando é:
(Count(CardCode_Ab) - Above(Count(CardCode_Ab))) / Above(Count(CardCode_Ab)) * 100 mas esta retornando nada
os campos da minha view sao: QT = CardCode_Ab(é um count), MES: Mes_Ab e por fim ANO: Ano_Ab
Hi friends,
how to show last 6 months in current year and the same 6 months in previous year in line chart in Qliksense?
dimension: inv_months
measure1:=Sum({<Inv_Date={">=$(=addmonths(monthstart(Max(Inv_Date)),-6))<=$(=Max(Inv_Date))"}>}Sales)
how to write measure2? for example like below table, need to display in line chart
Hi Team,
one of the Task is dependent on 3 other tasks.. so all the other 3 tasks are dependent on each other..
For example:
So, instead of kicking this one by one...
I have tried to create a trigger " on multiple events completed". but its not working out... Could you please assist..?
Thanks & Regards,
Ranjana
Wondering about Qlik Talend Data Integration Sessions? There are 11, in addition to all of the Data & Analytics. So meet us in Orlando, June 3 -5.
Join us on May 15th at 11 AM ET to discuss the Qlik Ideation Process. Bring your questions.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik enables a frictionless migration to AWS cloud by Empresas SB, a group of Chilean health and beauty retail companies employing 10,000 people with 600 points of sale.
Qlik Luminary Stephanie Robinson of JBS USA, the US arm of the global food company employing 70,000 in the US, and over 270,000 people worldwide.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!