Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 218,945 members
  • 7,361 online
  • 1,997,573 posts
  • 149,756 Solutions
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

Welcome to Qlik Community

Recent Discussions

  • forum

    New to Qlik Analytics

    Simplifying a table structure

    I have a spreadsheet to load into Qlik in the following format: Order ID Org1 OrgType1 Amount1 Org2 OrgType2 Amount2 Org3 OrgType3 Amount3 1000... Show More

    I have a spreadsheet to load into Qlik in the following format:

    Order ID Org1 OrgType1 Amount1 Org2 OrgType2 Amount2 Org3 OrgType3 Amount3
    10001 AAA Internal 1000 BBB Internal 300 CCC External 600
    10002 DDD Internal 1500 AAA Internal 200 EEE External 900
    10003 EEE External 800 FFF Internal 700 AAA Internal 1200

    ...and so on.

    But what I really want to work with in Qlik is a table like this:

    Order ID Org OrgType Amount
    10001 AAA Internal 1000
    10001 BBB Internal 300
    10001 CCC External 600
    10002 DDD Internal 1500
    10002 AAA Internal 200
    10002 EEE External 900
    10003 EEE External 800
    10003 FFF Internal 700
    10003 AAA Internal 1200

     

    Can anyone tell me how to get my data into that format?

    Thanks in advance,
    Dan

    Show Less
  • forum

    Integration, Extension & APIs

    Embedded Sheets Qlik on Web Site

    Hello, Someone can help me: I'm trying to paste the iframe on an html page of my domain, but trying to log in, this page always returns the error mess... Show More

    Hello,

    Someone can help me: I'm trying to paste the iframe on an html page of my domain, but trying to log in, this page always returns the error message "connection denied nametenant.eu.qlikcloud.it"

    Is there any setting to set up?

    In practice: I made the sheet public, I took the embedded, I pasted it on my web page www.dominio.it/qlik.html and I pop up the notice described.

    Show Less
  • forum

    Deployment & Management

    Tabular Reporting - Creating a Filter based on a dimension

    When trying to create a filter in the 'Filter' section of Reporting, I have trying to filter based on a dimensional value. When I select the dimension... Show More

    When trying to create a filter in the 'Filter' section of Reporting, I have trying to filter based on a dimensional value.

    When I select the dimension, it just appears as my if statement in the dimension.  I chose search, evaluate, etc. to find the value that I want but it keeps telling me it is invalid.

    How do I filter based on a dimension

    Show Less
  • forum

    Qlik Replicate

    SQL Server - MERGE

    I have a SQL Server database that has merge replication configured with another SQL Server, I need to replicate some tables using Qlik Replicate, we k... Show More

    I have a SQL Server database that has merge replication configured with another SQL Server, I need to replicate some tables using Qlik Replicate, we know that CDC cannot be activated, I would like to know what the restrictions are in relation to transactional replication, if This impacts merge replication that already exists, if Qlik uses other logs than the one already being used by MERGE.

    Show Less
  • forum

    App Development

    I would like to replace Nested "previous" (script function)

    Hi, I'd like to replace in my script some nested previous used to find the last value for a field (in this case, the supply source) in a table that ha... Show More

    Hi,

    I'd like to replace in my script some nested previous used to find the last value for a field (in this case, the supply source) in a table that have values similar to:

    Tab:
    Load *,
    If(len(trim(Source2))= 0 or Source2='NULL' or Source2='-', Null(), Source2 ) as Source
    INLINE [Trip Stop Type Source2 Pickup Delivered
    a1 1 1 a 20 -
    a1 2 2 - - 11
    a1 3 2 - - 6
    a1 4 2 - - 2
    a1 5 3 b 18 -
    a1 6 2 - - 16
    a1 7 4 - - 3
    ](delimiter is ' ');

    This would be a tipical trip, in which there are 4 types of Stops: 1 for initial product pickup, 2 for delivery to customers, 3 for others product pickup (e.g. in a provider) and 4 for product returned to plant.

    I need to identify the source for each stop (that would be the previous source untill the truck stop in a provider, changing the source, type 3) and I solve this situation by using nested "previous" function as follow. Could you help me to simplify this scrip? (maybe with peek function or using other one).

    My initial solution was:

    Source:
    Load
    Trip&Stop as TripStop,
            if(isNull(Source),
        if(isnull(Previous(Source)),
            if(isnull(previous(Previous(Source))),
                if(isnull(previous(previous(Previous(Source)))),
                    if(isnull(previous(previous(previous(Previous(Source))))),
                        if(isnull(previous(previous(previous(Previous(previous(Source)))))),
                            if(isnull(previous(previous(previous(Previous(previous(previous(Source))))))),
                                if(isnull(previous(previous(previous(Previous(previous(previous(previous(Source)))))))),
                                    if(isnull(previous(previous(previous(Previous(previous(previous(previous(previous(Source))))))))),
                                        if(isnull(previous(previous(previous(Previous(previous(previous(previous(previous(previous(Source)))))))))),
                                            if(isnull(previous(previous(previous(Previous(previous(previous(previous(previous(previous(previous(Source))))))))))),
                                                if(isnull(previous(previous(previous(Previous(previous(previous(previous(previous(previous(previous(previous(Source)))))))))))),
                                                    if(isnull(previous(previous(previous(Previous(previous(previous(previous(previous(previous(previous(previous(previous(Source))))))))))))),
                                                        if(isnull(previous(previous(previous(Previous(previous(previous(previous(previous(previous(previous(previous(previous(previous(Source)))))))))))))),
                                                        if(isnull(previous(previous(previous(Previous(previous(previous(previous(previous(previous(previous(previous(previous(previous(previous(Source))))))))))))))),
                                                            if(isnull(previous(previous(previous(Previous(previous(previous(previous(previous(previous(previous(previous(previous(previous(previous(previous(Source)))))))))))))))),
                                        if(isnull(previous(previous(previous(Previous(previous(previous(previous(previous(previous(previous(previous(previous(previous(previous(previous(previous(Source))))))))))))))))),
                                                                    if(isnull(previous(previous(previous(Previous(previous(previous(previous(previous(previous(previous(previous(previous(previous(previous(previous(previous(previous(Source)))))))))))))))))),
                                                                    if(isnull(previous(previous(previous(Previous(previous(previous(previous(previous(previous(previous(previous(previous(previous(previous(previous(previous(previous(previous(Source))))))))))))))))))),
                                                                    previous(previous(previous(previous(Previous(previous(previous(previous(previous(previous(previous(previous(previous(previous(previous(previous(previous(previous(previous(Source))))))))))))))))))),
                                                                                      previous(previous(previous(previous(Previous(previous(previous(previous(previous(previous(previous(previous(previous(previous(previous(previous(previous(previous(Source)))))))))))))))))))
                                                                ,previous(previous(previous(previous(Previous(previous(previous(previous(previous(previous(previous(previous(previous(previous(previous(previous(previous(Source))))))))))))))))))             
                                                                ,previous(previous(previous(previous(Previous(previous(previous(previous(previous(previous(previous(previous(previous(previous(previous(previous(Source)))))))))))))))))   
                                                                ,previous(previous(previous(previous(Previous(previous(previous(previous(previous(previous(previous(previous(previous(previous(previous(Source))))))))))))))))
                                                                ,previous(previous(previous(previous(Previous(previous(previous(previous(previous(previous(previous(previous(previous(previous(Source)))))))))))))))
                                                                ,previous(previous(previous(previous(Previous(previous(previous(previous(previous(previous(previous(previous(previous(Source))))))))))))))     
                                        ,previous(previous(previous(previous(Previous(previous(previous(previous(previous(previous(previous(previous(Source)))))))))))))
                                        ,previous(previous(previous(Previous(previous(previous(previous(previous(previous(previous(previous(Source))))))))))))
                                        ,previous(previous(previous(Previous(previous(previous(previous(previous(previous(previous(Source)))))))))))
                                        ,previous(previous(previous(Previous(previous(previous(previous(previous(previous(Source))))))))))
                                        ,previous(previous(previous(Previous(previous(previous(previous(previous(Source)))))))))
                                          ,previous(previous(previous(Previous(previous(previous(previous(Source))))))))
                                ,previous(previous(previous(Previous(previous(previous(Source)))))))
                                    ,previous(previous(previous(Previous(previous(Source))))))
                            ,previous(previous(previous(Previous(Source)))))
                           ,previous(previous(Previous(Source))))
                       ,previous(Previous(Source)))
                    ,Previous(Source))
                ,Source) as SourceOk

    RESIDENT Tab;

    DROP TABLE Tab;

    Show Less
  • forum

    App Development

    Chart labels are chopped up

    I recently started seeing a problem in bar charts and line charts: the value labels are not visually all there. Two examples:   If I resize the char... Show More

    I recently started seeing a problem in bar charts and line charts: the value labels are not visually all there. Two examples:

    Lauri_0-1694631828372.png

    Lauri_1-1694631860210.png

     

    If I resize the chart or the web browser, I can eventually get it to look good. It doesn't happen with tables, and I haven't noticed it in other visualizations. It happens on other computers and in different web browsers. It doesn't happen outside of Qlik. We're on Sense Enterprise February 2023, client-managed.

    Are others having this problem? 

    Show Less
  • forum

    Qlik Reporting Service

    Creating a Measure from a Dimension

    I have a dimension that I created called Proposed Bucket. Here is my if statement: =If(Excp_Category='6-Attempted','2-CUSTOMER ACTION', if(Excp_Categ... Show More

    I have a dimension that I created called Proposed Bucket.

    Here is my if statement:

    =If(Excp_Category='6-Attempted','2-CUSTOMER ACTION',
    if(Excp_Category = '1-Manifest','5-APPLE ACTION',
        If(Excp_Category='5-Out for Delivery','3-OUT FOR DELIVERY',
        if(Current_Scan_Activity_Record_Type='Out For Delivery','3-OUT FOR DELIVERY',
        IF(Excp_Category='7-Delivery','1-DELIVERED', [Exception_Resolution_Proposed_Bucket])))))
     

    I want to create a measure that adds up certain elements of this proposed bucket. 

    Show Less
  • forum

    Water Cooler

    [Article] The Rise of Language-Centric Analytics

    In the wake of the recent surge in the adoption and advancement of Large Language Models (LLMs), I've found myself contemplating the profound implicat... Show More

    In the wake of the recent surge in the adoption and advancement of Large Language Models (LLMs), I've found myself contemplating the profound implications for the field of analytics and the evolving role of data and business analysts.

    With each stride made in natural language processing technology, my fascination with its transformative potential only deepened. However, as I delved into the current applications of LLMs and Generative AI, I couldn't shake the sense that something vital was missing.

    Despite the undeniable capabilities exhibited by these models, their relevance to real-world business scenarios often seemed nebulous. The disconnect between the touted examples and the practical needs of businesses left many questioning the applicability of these technologies.

    It was amidst this backdrop of uncertainty that the concept of Language-Centric Analytics began to crystallize in my mind, after much reflection, discourse, and experimentation. This paradigm shift places language at the heart of the analytical process, recognizing its innate familiarity and accessibility as a means of interaction. By reframing analytics around language, we pave the way for a more intuitive and inclusive approach to data exploration and interpretation. The journey towards Language-Centric Analytics holds the promise of reshaping not only how we analyze data but also how we perceive and harness its potential to drive meaningful insights and informed decisions.

    About that topic, I just published a short article in the Data Voyagers blog. This text serves as an introduction to this concept. I hope you all enjoy it.

    The Rise of Language-Centric Analytics (datavoyagers.net)

     

    Show Less
  • forum

    Qlik NPrinting

    Dynamic tables with calculated dimensions,org chart extension objects are not re...

    I am using NPrinting May2023 SR2 version, org chart extension, dynamic tables with calculated dimensions in adhoc reporting are not not supported in e... Show More

    I am using NPrinting May2023 SR2 version, org chart extension, dynamic tables with calculated dimensions in adhoc reporting are not not supported in excel, objects or tables are not rendering properly ,Do you have any solution?

    Show Less
  • forum

    Qlik NPrinting

    NPrinting issues with Qliksense Container, straight Table with Chart Exploration...

    1. I am using container having 3 different charts ,In NPrinting report first and last tab are rendering, but middle one NOT rendering , this occurs in... Show More

    1. I am using container having 3 different charts ,In NPrinting report first and last tab are rendering, but middle one NOT rendering , this occurs in other containers as well in my Qliksense application.?

    2. Cannot apply alternative dimensions in Barchart,in NPrinting -only return/render Barchart with default dimension. ?

    3. Straight Table with Chart Exploration: NPrinting only return the 3 default columns, which is available in chart Exploration in straight Table?

    4. Straight Table Extension with chart exploration is an extension? Can you confirm same extn supported by NPrinting May 2023 SR2 Version.? 

    My core Qliksense application version is May 2023 Patch 6 . 

    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!