Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 218,944 members
  • 6,781 online
  • 1,997,567 posts
  • 149,755 Solutions
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

Welcome to Qlik Community

Recent Discussions

  • 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

    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

    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
  • forum

    Qlik Replicate

    Unable to access the URL for Qlik Replicate.

    Hi Team, We're facing some issues with our Replicate installation on Red Hat Linux. We're unable to stop or restart services, and we're also having tr... Show More

    Hi Team,

    We're facing some issues with our Replicate installation on Red Hat Linux. We're unable to stop or restart services, and we're also having trouble accessing the Qlik Replicate Console. Any assistance you can provide would be greatly appreciated. When we kill process id after that we are able to start service also access URL what can be cause for this 

    Thanks!

    Show Less
  • forum

    New to Qlik Analytics

    Pagination Next URL Not working

    i have dat like below in postman request   in qlik connection i am using nextUrl as my pagination  Next Url path :paging/link it bring only one page ... Show More

    i have dat like below in postman request

    ChannaK_0-1715155076241.png

     

    in qlik connection i am using nextUrl as my pagination 

    Next Url path :paging/link

    it bring only one page can you help here

     

    Show Less
  • forum

    Qlik Replicate

    Value exceeding its max length Error

    We are trying to connect openEdge ProgressDB using ODBC Connection, While Loading the data for  dataset we are getting below error. Error : SQL_ERROR ... Show More

    We are trying to connect openEdge ProgressDB using ODBC Connection, While Loading the data for  dataset we are getting below error.

    Error :

    SQL_ERROR  SqlState: HY000 NativeError: -210012 Message: [DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Column code_value in table PUB.code_mstr has value exceeding its max length or precision. Line: 151 Column: -1

     

    We tried increasing the length of the destination fileds in Qlik, even after that we are getting the same error.

    Show Less
  • forum

    App Development

    How to abstract a measure for all the different employees?

    I made a measure for taking into account the efficiency of certain producers  ( Sum( Aggr( Count( {< ACTION_CODE = {'LABOR_OFF'}>} dist... Show More

    I made a measure for taking into account the efficiency of certain producers 

    (
    	Sum(
        	Aggr(
            	Count( {< ACTION_CODE = {'LABOR_OFF'}>} distinct MainSFC) * Standard_Time,
                MainSFC)
    	)
    )
    /
    (
    	Count( 
        	distinct WorkingDay) 
            * 7.5 * 60)

     

    And it works fine for the single producer. I want to abstract this, make one that takes into consideration ALL of the producers/employees, so in my mind I tried to do: 

     

    (
    	Sum( {<Employee=>}
        	Aggr(
            	Count( {< ACTION_CODE = {'LABOR_OFF'}, Employee=>}} distinct MainSFC) * Standard_Time,
                MainSFC)
    	)
    )
    
    /
    
    (
    	Count( {<Employee=>}
        	distinct WorkingDay) 
            * 7.5 * 60)

     

    But this doesn't work, and gives me null values. How could I fix this? 

    Show Less
  • forum

    App Development

    Show all Value from a Pivot Table even if a cell is selected

    Hello,   i have a pivot table and when I select a cell, Qlik only show the value of the two dimensions who are impacted by the cell. What must I do to... Show More

    Hello,

     

    i have a pivot table and when I select a cell, Qlik only show the value of the two dimensions who are impacted by the cell.

    What must I do to be able to select a cell and in the same time show all the pivot table and the value.

     

    thanks for helping

    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!