Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 217,255 members
  • 6,457 online
  • 1,994,909 posts
  • 149,493 Solutions

Welcome to Qlik Community

Recent Discussions

  • forum

    New to Qlik Analytics

    How can I color negative values and positive values in QlikView?

    Hello, How can I color negative values red and positive values green in QlikView?       
  • forum

    New to Qlik Analytics

    Não mostrar valores nulos no IF

    Boa tarde comunidade!Eu realizei um 'IF' que foi realizado corretamente, mas ele me apresentou alguns valores nulos.Como poderia fazer para remover es... Show More

    Boa tarde comunidade!

    Eu realizei um 'IF' que foi realizado corretamente, mas ele me apresentou alguns valores nulos.
    Como poderia fazer para remover esses valores?

    Muito Obrigado pela atenção.

    Show Less
  • forum

    App Development

    Sort Data Based on Number of Leading Zeros

    Hi All, How to sort data based on leading zeros and not the actual number in qlik Below is my example Item Num 0064 000670402 0065FR CS-CD-... Show More

    Hi All,

    How to sort data based on leading zeros and not the actual number in qlik

    Below is my example

    Item Num
    0064
    000670402
    0065FR
    CS-CD-PSW-10-00
    010240410

    The data should be sorted based on number of zeros at the start in ascending order.

    My final output should be like the below table

    Item Num
    000670402
    0064
    0065FR
    010240410
    CS-CD-PSW-10-00

    Note : This is just an example . I have more that 30000 item numbers like this and i want to sort based on number of leading zeros

    Show Less
  • forum

    QlikView App Dev

    Auto Triggering of QMC jobs from SAP job completion

    Dear Experts,I would like to trigger some qlikview jobs automatically when the SAP job completed.Do we have a work around for this?I do have a SAP tab... Show More

    Dear Experts,

    I would like to trigger some qlikview jobs automatically when the SAP job completed.

    Do we have a work around for this?

    I do have a SAP table which stores the job completion information.Is there a way qv checks the status of the sap job and trigger when it says "Yes"

    Thanks & Regards

    Jeba

    Show Less
  • forum

    App Development

    Show zero measures in a graph

    (Apologies, this was posted earlier but was my post was so full of flaws, I removed it). I am trying to show a graph of tickets raised over a periiod ... Show More

    (Apologies, this was posted earlier but was my post was so full of flaws, I removed it).

    I am trying to show a graph of tickets raised over a periiod of time.  In my data I have zero 'Open' tickets in October and as a result October does not show on my graph.

    Markbhai_0-1713531709414.png

    I have tried a 'Master Calendar' which works until a filter is applied.  -

    I have also read about adding + sum({1}0) to my measure.

    Count({<[Status]={'Open'}>}id) + sum({1}0)

    and setting the Addons -> Data Handling -> Include zero values 

    Markbhai_1-1713531893301.png

    Any help would be appreciated

     

    Show Less
  • forum

    Security & Governance

    Is there anyway on Qlik SaaS to track the sheet usage by user and session durati...

    We can only see the usage on the app level using the Entitlement analyzer, but we cannot track the sheet usage, is there anyway to do it on SaaS? I kn... Show More

    We can only see the usage on the app level using the Entitlement analyzer, but we cannot track the sheet usage, is there anyway to do it on SaaS? I know it's possible on Enterprise. 

    Show Less
  • forum

    Connectivity & Data Prep

    Unable to access the Catalog Databases for DataBricks Connection

    Hi,   Recently I set up a DataBricks Connection but unable to access the databases inside the Catalog.We are in May 2023 Patch 6 version of Qliksense.... Show More

    Hi,

     

    Recently I set up a DataBricks Connection but unable to access the databases inside the Catalog.We are in May 2023 Patch 6 version of Qliksense. But the same connection could be accessed through SAAS. Please help.

    Show Less
  • forum

    Qlik NPrinting

    Qlik Sense NPrinting POST REST API Connection 403 (Forbidden) Error

    I have created a GET REST connection to NPrinting and it works perfectly. This is the GET REST Connection Setup...GET REST Connection SetupMy problem ... Show More

    I have created a GET REST connection to NPrinting and it works perfectly. This is the GET REST Connection Setup...
    GET REST Connection SetupGET REST Connection Setup
    My problem is that I am not able to set up a POST REST Connection. Everything is the same, except for the Method and the Trusted Locations, which has been loaded into NPrinting. 
    POST REST Connection SetupPOST REST Connection Setup

    I managed to get the POST working in Postman, by first doing a GET login. Then copying the XSRF-TOKEN out of the Cookie and adding it to a X-XSRF-TOKEN key under Headers.

    Postman POST REST SetupPostman POST REST Setup

    This was a manual workaround, the problem is how to do it when setting up a Qlik Sense POST REST login connection... I can't get the XSRF-TOKEN to add it to the connection, to get the connection to authenticate, i.e., not give the 403 (Forbidden) error...

    Show Less
  • forum

    Qlik Replicate

    Job failing with error unable to rename repcmd.log

    We are triggering replicate by using scheduling tool and periodically checking the status if replicate completed or not. Although the replicate load i... Show More

    We are triggering replicate by using scheduling tool and periodically checking the status if replicate completed or not. Although the replicate load is going success the job is failing with the error Failed to rename file repcmd.log to repcmd__240417043324.log .

     

    Show Less
  • forum

    Brasil

    Multiplicar um valor por um rank(Relativo). Não estou conseguindo chegar ao valo...

      Preciso achar o Valor da Coluna 1 * Coluna 2(Relativo). Mas não estou conseguido. Preciso criar um set analysis que trate (Pois o valor correto é di... Show More

     

    Preciso achar o Valor da Coluna 1 * Coluna 2(Relativo). Mas não estou conseguido.

    Preciso criar um set analysis que trate (Pois o valor correto é diferente). 

    Preciso de ajuda. 

    Cod Valor Rank(Relativo) (Column(1)
    *
    Column(2))

    /
    1000000 (Errado)
    Valor Correto
    2061 300000 4,69% 9.689,40 14.070,00
    5277 300000 21,21% 43.817,70 63.630,00
    5543 300000 3,36% 6.932,70 10.080,00
    10757 300000 7,27% 15.025,80 21.810,00
    12305 300000 4,10% 8.461,80 12.300,00
    13248 300000 3,01% 6.213,00 9.030,00
    13697 300000 11,97% 24.739,50 35.910,00
    16923 300000 6,23% 12.882,30 18.690,00
    17459 300000 24,93% 51.509,10 74.790,00
    19201 300000 5,18% 10.710,90 15.540,00
    19303 300000 6,45% 13.333,80 19.350,00
    29976 300000 1,60% 3.307,50 4.800,00
            300.000,00

    2024-04-17_15-38-16.jpg

    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!