Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 219,084 members
  • 7,839 online
  • 1,997,846 posts
  • 149,777 Solutions
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

Welcome to Qlik Community

Recent Discussions

  • forum

    Qlik Application Automation

    Servicio Qlik Logging Service no inicia

    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 e... Show More

    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 😞 

     

     

     

     

     

    Show Less
  • forum

    App Development

    Filter Chart using dimensions only

    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 f... Show More

    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!

    Show Less
  • forum

    Integration, Extension & APIs

    QRS API: Updating a user's Custom Property values

    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... Show More

    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.)

    {
        "id": "73b349f0-an1b-4f9f-a233-ef14br4361f4",
        "createdDate": "2024-04-15T18:38:41.905Z",
        "modifiedDate": "2024-05-09T15:33:16.282Z",
        "modifiedByUserName": "UserDir\\UserId",
        "customProperties": [
            {
                "id": "579b33b9-f9cd-471l-a9f9-5f51de903855",
                "createdDate": "2024-05-09T15:18:51.308Z",
                "modifiedDate": "2024-05-09T15:31:16.282Z",
                "modifiedByUserName": "UserDir\\UserId",
                "value": "App 1",
                "definition": {
                    "id": "a495a6b1-d351-43b6-b995-a524652d63a3",
                    "name": "UserAppAccess",
                    "valueType": "Text",
                    "choiceValues": [
                        "App 1",
                        "App 2",
                        "App 3"
                    ],
                    "privileges": null
                },
                "schemaPath": "CustomPropertyValue"
            }
        ],
        "userId": "UserId",
        "userDirectory": "UserDir",
        "userDirectoryConnectorName": "",
        "name": "UserId",
        "roles": [
            "RootAdmin"
        ],
        "attributes": [],
        "inactive": false,
        "removedExternally": false,
        "blacklisted": false,
        "deleteProhibited": false,
        "tags": [],
        "favorites": [],
        "privileges": null,
        "schemaPath": "User"
    Show Less
  • forum

    QlikView Administration

    Qlikview upgrade to 12.20 Latest version

    HiI'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... Show More

    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

    Show Less
  • forum

    New to Qlik Analytics

    Crear una columan Total en un Grafico

    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 Actu... Show More

    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

     

    Lucho88_0-1715190208838.png

    El YTD que tengo hoy es el total de los lugares y solo necesito de XXXX

     

    Me podrian ayudar, Muchas gracias!

    Show Less
  • forum

    New to Qlik Analytics

    How to add a blank dimension in a sheet

    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 tha... Show More

    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!

    Show Less
  • forum

    Qlik Replicate

    Snowflake Target Endpoint - Support new Hybrid Tables as Targets

    In March of 2024, Snowflake announced that Hybrid Tables are now in QA. Will the Snowflake target endpoint connector be modified to support replicatin... Show More

    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

     

    Show Less
  • forum

    Brasil

    Comparação em % Mes anterior e Mes Atual - help

    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 ... Show More

    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

    Livia_MF02_0-1715262458452.png

     

    Show Less
  • forum

    New to Qlik Analytics

    how to show last 6 months Sales in current year and previous year 6 months Sales...

    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 measure... Show More

    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

    venky77777_0-1715270418792.png

     

     

    Show Less
  • forum

    Administering and Monitoring

    Trigger in QlikView management control - multiple event

    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 ... Show More

    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:

    Ranjanac1_0-1715275920278.png

    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..?

    Ranjanac1_1-1715275973637.jpeg

    Thanks & Regards,

    Ranjana 

    Show Less
Leaderboard

Customer Story

Qlik Data Integration & Qlik Replicate story

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.

Customer Story

Building a Collaborative Analytics Space

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.

Location and Language Groups

Choose a Group

Join one of our Location and Language groups. Find one that suits you today!

Collaborate

Healthcare User Group

Healthcare User Group

A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..

All are welcome

Japan Group

Japan

Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。

Request to join

Brasil Group

Brazil

Welcome to the group for Brazil users. .All discussions will be in Portuguese.

open to all

Blogs

Community News

Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!