Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 217,803 members
  • 9,384 online
  • 1,995,792 posts
  • 149,576 Solutions
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

Welcome to Qlik Community

Recent Discussions

  • forum

    QlikView App Dev

    How to set a different background color based on value comparison with the row a...

    in Qlikview please: For example, if the value in the 2nd row is lower than in the row above to be colored in green.   Thank you
  • forum

    Deployment & Management

    Switch Qlik Sense Licence

    Hello, I plan to uninstall my Qlik Sense Production single node server which currently used the production licence. My new Qlik sense architecture is ... Show More

    Hello,

    I plan to uninstall my Qlik Sense Production single node server which currently used the production licence.

    My new Qlik sense architecture is a multi node architecture with February 2024 release. The licence used for this environment is currently my Test licence.

    Once my production environment will be unistalled, will a be able to activate my production licence on my new architecture ? Can you give me the procedure to follow for this?

    Thanks.

    Show Less
  • forum

    Installing and Upgrading

    Can Talend Open Studio(TOS) desktop version continue to be used by existing user...

    The open-source version of Talend Studio seem to be retired. Can the existing users continue using Talend Open Studio desktop version if have it insta... Show More

    The open-source version of Talend Studio seem to be retired. Can the existing users continue using Talend Open Studio desktop version if have it installed already or have local copy of .exe file?

    Show Less
  • forum

    Qlik Application Automation

    qlik sense on a tv screen with Optisings solution

    hi,  i need help. we want to put a qlik app on  tv screen with a Optisings solution. we have every time a mistake like this. what we can do that we do... Show More

    hi, 

    i need help. we want to put a qlik app on  tv screen with a Optisings solution. we have every time a mistake like this. what we can do that we don t have this? mistake 500. what is it?

    Controller1_0-1714059104214.jpeg

     

    Show Less
  • forum

    New to Qlik Analytics

    Generate code when joining two tables

    Hello communityHow can I generate a code when joining two tables? Example: Tabla 1 (Database) + 200 records Tabla 2(Database) + 200 records Table 3(... Show More

    Hello community
    How can I generate a code when joining two tables?

    Example:

    Tabla 1 (Database) + 200 records

    rmendoza_2-1713958093717.png

    Tabla 2(Database) + 200 records

    rmendoza_1-1713958007413.png

    Table 3(Excel) has the code... depending on the condition. (+ 200 records...many combinations)

    rmendoza_3-1713958176493.png

    thanks for your time.

    cheers

    Renzo

     

     

    Show Less
  • forum

    Deployment & Management

    Qlik Sense disconnection on NLB (F5) with firefox only

    Hello, I'm using Qlik Sense Enterprise February 2024 with a multi nodes deployment. I have some disconnection issues after 5 minutes of inactivity, wi... Show More

    Hello,

    I'm using Qlik Sense Enterprise February 2024 with a multi nodes deployment.

    I have some disconnection issues after 5 minutes of inactivity, with Firefox only, after opening a QS app passing by the NLB (F5) address.

    If I try to connect directly to the address of one of my nodes, I don't have this disconnection issue.

    In the AuditActivity_Proxy log, a specific message is visible each time i'm disconnected :

    Emmanuel_DORR_0-1714057624644.png

    I found some articles about Websocket ping intervall depending on browser, but I really think that it comes more from a parameter at the load balancer level. However, I don't understand why this issue only concerns a particular browser (Firefox) in my case.

    Session inactivity timeout is fixed on 30 minutes on each node :

    Emmanuel_DORR_1-1714057624645.png

    Keep alive timeout is fixed on 10 seconds :

    Emmanuel_DORR_2-1714057624645.png

    Can you give me some ideas to explore in order to resolve this issue?

    Thanks,

    Emmanuel

    Show Less
  • forum

    App Development

    Error referenced measure when nesting master measures more than 1 level deep?

    I have a master measure (let's call it "B"), which references another master measure (let's call it "A"). Master measure "B" works fine. Then when I c... Show More

    I have a master measure (let's call it "B"), which references another master measure (let's call it "A"). Master measure "B" works fine.

    Then when I create a new master measure "C" (which references master measure "B"), I get the error referenced measure, which Qlik has documented here. https://community.qlik.com/t5/Official-Support-Articles/Error-in-expression-Error-referenced-measure/ta-p/1845945

    I've made sure my master measure names are unique and non-overlapping with other names. Is nesting master measures more than one level deep not supported by Qlik?

    Show Less
  • forum

    New to Qlik Analytics

    Loop through a table to check which column has the value

    I have a table with 100 columns I want to check for column 1 = 'ID001' if the other 99 columns has a certain date value say '2025-01-01'   But my code... Show More

    I have a table with 100 columns

    I want to check for column 1 = 'ID001' if the other 99 columns has a certain date value say '2025-01-01'

     

    But my code is throwing the error fieldname not found in the for loop...

    what i did

    // first filter column 1 for ID001

    [TEST]: NoConcatenate LOAD Distinct * Resident[MAIN_TABLE] where column1='ID001';

    // Loop to check for date value =  '2025-01-01' if have flag as 1

    For f = 1 to NoOfFields('TEST')
    LET F1 = FieldName($(f), 'TEST');
    [Fields]:
    Load distinct FieldName($(f), 'TEST') as Field, If(Date(Floor($(F1)))=Date(Floor(' 2025-01-01')),1,null()) as check
    AutoGenerate 1;
    Next f
    DROP Table[TEST];

     

    Any idea how to solve? Thanks in advance!

    Show Less
  • forum

    New to Qlik Analytics

    A join that doesn't surprisingly work

    Hello everyone, I would like to discuss this case and I'm sure someone can explain to me why this happens. In my following script, table1 is a fact ta... Show More
    Hello everyone, I would like to discuss this case and I'm sure someone can explain to me why this happens.
    In my following script, table1 is a fact table of data about Activities that actually have happened and table 2 is a  fact able about all activities, including the ones in table1 and more that are announced but haven't happened yet so they cannot be in table1 yet. Dim_team is a dimension table with team details. The cardinality is many to 1 such as an Event_id can only belong to an ID_Activity, but an ID_Activity and can have many Event_ids.  So the question now is: I tried to right join the tables with a composite key "Activity_Key" (because in fact ID_Activity and ID_for_Activity are the same and so are ID_Team and ID_of_Team) so that I can have all data for Activities even when they have nulls in table1.
    The result I'm getting is not what I expected, it gets partial information, doesn't match info as it should.
    A link table saved the day, but I was -and still am- very confused about that.
     
     
     
     
    dim_team:
     
    LOAD ID_Team,
          Team_Name
          Team_Code
    FROM [$(vPathQVD)team.qvd]
    (qvd);
     
     
     
    fact_table1:   
    //
    LOAD
        "Event_id",
        "ID_Person",
        "ID_Team",
        "ID_Activity",
        "ID_Team"&"ID_Activity" as Activity_Key
     
    FROM [$(vPathQVD)table1.qvd]
    (qvd);
     
     
    right join(fact_table1)
    //fact_table2
    LOAD
     
        "ID_for_Activity",
        "ID_of_Team",
        "ID_of_Team"&"ID_for_Activity" as Activity_Key,
        "Activity_Name",
        "Participants_Number",
         Date,
         Place
     
        
    FROM [$(vPathQVD)Activity.qvd]
    (qvd);
     
     
    I could use some help! Thank you 🙂
    Show Less
  • forum

    New to Qlik Analytics

    Default filter

    Hello, I have used filter panes in one of my sheet in qliksense. One of the filters is to select Gender. The filed name in my data source is Gender an... Show More

    Hello,

    I have used filter panes in one of my sheet in qliksense. One of the filters is to select Gender. The filed name in my data source is Gender and it has rows for F (as female) and M( as male). Previously, I had this expression behind my filter 
    if(Gender='F','Female',if(Gender='M','Male')). it works fine.

    Now user wants that every time they open the sheet it filters out the report automatically or by default to Male. and later, if they need then change and select the Female option in the filter.

    I have set this variable in the main section in data load editor SET vDefaultFilter='Male', and modify the expression like this: if(Gender='F','Female','$(vDefaultFilter)')

    the expression says ok but it does not filter data by default to Male. I still need to go and select Male option.

    could someone help please?

    Thank you!

    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!