Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 219,369 members
  • 6,398 online
  • 1,998,234 posts
  • 149,815 Solutions
Announcements
Qlik Community Office Hours - Bring your Ideation questions- May 15th, 11 AM ET: REGISTER NOW

Welcome to Qlik Community

Recent Discussions

  • forum

    New to Qlik Analytics

    How do I organize data and rank it?

    Hello everyoneUserI have the table that contains the following fields:LLAVECP,CENTRO,PLU_SAP,Venta_UNDI need the data to be ranked according to the Ve... Show More

    Hello everyone
    User
    I have the table that contains the following fields:
    LLAVECP,
    CENTRO,
    PLU_SAP,
    Venta_UND
    I need the data to be ranked according to the Venta_UND field value for each LLAVECP

    Show Less
  • forum

    New to Qlik Analytics

    Filtro Fijo

    Buenos diasNecesito ayuda por un tema puntual que no estoy pudiendo resolver en QlikSense (en QlikView era mas simple con macros, por ejemplo)Tengo qu... Show More

    Buenos dias

    Necesito ayuda por un tema puntual que no estoy pudiendo resolver en QlikSense (en QlikView era mas simple con macros, por ejemplo)

    Tengo que fijar una selección para que cuando el usuario ingresa al tablero, ya tenga preseleccionados los filtros por este campo, pero que si quiere despues, pueda cambiarlo

    No encontré como hacerlo en Sense. Solo encontré la opción de bloqueo de selección, pero eso aplica solo seleccionando a mano primero el filtro, y bloquearlo

    Pero no sirve para que venga seleccionado independientemente del usuario que ingrese

    Si alguien puede ayudarme con esto, bienvenido

    Muchas gracias de antemano

    Saludos.

    Show Less
  • forum

    Qlik NPrinting

    Replace complete report(template and metadata) to original version

    Hi, I have migrated a .nsq file from NP-v16 to the Qlik Nprinting 2021 and changes to reports. Now i want to import only one specific Report from .nsq... Show More

    Hi,

    I have migrated a .nsq file from NP-v16 to the Qlik Nprinting 2021 and changes to reports.

    Now i want to import only one specific Report from .nsq zip file to overwrite the recent changes.

    When i clicked on Import NP 16 Report(as in below screenshot), it shows all the other report except the report I want to replace. 

    Capture44.PNG

    Any suggestions, please.

    Show Less
  • forum

    QlikView App Dev

    FirstSortedValue issues

    I am trying to pull my companies fixed assets and it is extremely over stated.  First issue is it is doubling up assets for multiple countries USA and... Show More

    I am trying to pull my companies fixed assets and it is extremely over stated.  First issue is it is doubling up assets for multiple countries USA and Canada.  I have added AffiliateCode = 77048 to the Where clause and that seems to have fixed that issue but our fiscal year ends in 03/31/YY. Before the year rolled over this wasn't an issue.  

    The 2nd issue is there are 2 record dates on some assets and I am trying to pull the newest date only.  I am trying to use FirstSortedValue with a minus weight to get the "last value".  Below is the code I am using.  What am I doing wrong?

     
     
    NoConcatenate
     
    famaster_mst:
     
    LOAD 
    AffiliateCode & '|' & dept as AffiliateCode|dept, 
    Trim(AffiliateCode & '|' & fa_num) as AffiliateCode|fa_num|seq#,
    Trim(AffiliateCode & '|' & dept & '|' & fa_class) as AffiliateCode|dept|fa_class,
    Trim(AffiliateCode & '-' & dept & '-' & fa_class & '-') as AffiliateCode|dept|fa_class|AssetType,
    AffiliateCode, 
         fa_num, 
         type,
         fa_desc, 
         dept, 
         loc, 
         tag, 
         fa_class, 
         acq_date,  // when they bought it not when depr starts
         vend_num, 
         mfg, 
         model, 
         serial, 
         fa_stat, 
         life, 
         units_cur, 
         read_prior, 
         read_curr, 
         insur_val, 
         insur_vnd, 
         insur_pol#, 
         insur_exp, 
         inv_freq, 
         inv_date, 
         dispose_date, 
         dispose_amt, 
         review, 
         post_from_po, 
         NoteExistsFlag, 
         FirstSortedValue(fa_num, -RecordDate) as RecordDate,
        // RecordDate,
           RowPointer, 
         CreatedBy, 
         UpdatedBy, 
         CreateDate, 
         InWorkflow, 
         date_to_start_depr, 
         Uf_SplitAsset, 
         Uf_SplitAssetDate, 
         Uf_Ringi_Number
    FROM
    [..\QVD\famaster_mst.qvd]
    (qvd)
    Where
    AffiliateCode = 77048 and
    fa_stat <>'D' and 
    Uf_SplitAsset <> 1 and // Exclude 'D' for disposals and include 'A' for Active and 'I' for Inactive assets
    fa_num = 412
    ;
     
    Exit SCRIPT;

     

    Show Less
  • forum

    New to Qlik Analytics

    Need help with Len(Trim(Category))

    I have a load script that had dash or -. I want to exclude them from the load script. I know I can do it within the app, but I like to do it on the lo... Show More

    I have a load script that had dash or -. I want to exclude them from the load script. I know I can do it within the app, but I like to do it on the load script.

    Len(Trim(Category))=’-‘ works, but I need the opposite     Len(Trim(Category))<>'-' The opposite does not work.

    Any help will be great.

    Show Less
  • forum

    App Development

    Let's Connect at Qlik Connect 2024: AnyChart Booth #807

    Qlik Connect 2024 is just around the corner, and we're thrilled to announce that AnyChart will be participating as an Emerald sponsor and exhibitor. ... Show More

    Qlik-Connect-AnyChart.png

    Qlik Connect 2024 is just around the corner, and we're thrilled to announce that AnyChart will be participating as an Emerald sponsor and exhibitor. Join us at Booth 807 from June 3–5 at Rosen Shingle Creek in Orlando!

    🚀 We'll be excited to showcase how our latest developments for Qlik Sense can elevate your data analytics efforts — come see our solutions in action!

    🔧 We're also eager to preview what's coming next and discuss how we can tailor our Decomposition Tree, Gantt Chart, Sunburst Chart, and other extensions to meet your specific needs — an excellent opportunity for you to get tools perfectly adapted to your unique data challenges.

    Visit our Qlik Connect event page for more details and to schedule a meeting with us (we'd love to prepare something especially for you).

    See you at Qlik Connect, Booth 807! 

    Show Less
  • forum

    Data Quality, Preparation & Stewardship

    Talend trest Post with body

    Hi,   This is our second week using talend as an organisation after training, so we are very fresh. I am currently sending a body in trest to retrieve... Show More

    Hi,

     

    This is our second week using talend as an organisation after training, so we are very fresh.

    I am currently sending a body in trest to retrieve a token. 

    This is my setup

    Rfoot_1-1715632700537.png

     

    This is my tmap. The response is a string and not json for some unknown reason so textractjson didn't work.

    Rfoot_2-1715632731130.png

     

    I get that token successfully in this format. 

    Rfoot_3-1715632841241.png

    How does one put that string value into a variable? 

     

    Regards,

    Ryan

     

    Show Less
  • forum

    App Development

    Section Access for Specific Users Only

    I am trying to do section access for only a specific user but all other users with access to the app I would like to grant full access. Is there a sim... Show More

    I am trying to do section access for only a specific user but all other users with access to the app I would like to grant full access. Is there a simple way of doing this without managing users in two places?

    Show Less
  • forum

    New to Qlik Analytics

    Selected buttons

    Is there any way that a button can change color it's selected? I have a button that is matched with a favorite and I want for the user to see that the... Show More

    Is there any way that a button can change color it's selected? I have a button that is matched with a favorite and I want for the user to see that the button has been selected instead of looking in the filters. Does this exists?

    For instance, I have the white button here that is not selected but when it does, it has to become grey.

     
    Phara_0-1715630989715.png Phara_1-1715631036867.png

     

    Thanks to all of you for your help!

    Show Less
  • forum

    App Development

    Enter More Than One String Value In A Variable

    Hello, I am trying to input more than one string in a variable and the best I could come with is this... MATCH (     TITLE,         'Engine Annual Re... Show More

    Hello,

    I am trying to input more than one string in a variable and the best I could come with is this...

    MATCH
    (
        TITLE,
            'Engine Annual Requirements',
            'Transmission Annual Requirements',
            'Suspension Annual Requirements',
            'Exterior Annual Requirements',
    )
     
    I am creating this variable in the front end. It is called AnnualCertification, I want to use it in multiple KPIs. One such KPI would have set analysis like this...
     
    COUNT({<CERTIFICATION_TITLE = {$(vAnnualCertification)}>} DISTINCT I_USR)
     
    I am getting an error when I do this. What am I missing here? I have a feeling it's something minor. Thanks in advance.
    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!