Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 278,449 members
  • 19,658 online
  • 2,051,579 posts
  • 155,087 Solutions
Announcements
Meet Qlik's New CEO. The Future Is Bright — Here's What to Expect

Welcome to Qlik Community

Recent Discussions

  • forum

    Qlik Answers

    KP Gear Pump vs Ordinary Gear Pump: Choosing According to Application

    Selecting a KP Gear Pump instead of another gear pump should be based on the hydraulic system rather than the product name alone. External gear pumps ... Show More

    Selecting a KP Gear Pump instead of another gear pump should be based on the hydraulic system rather than the product name alone. External gear pumps share a basic operating concept, but housing construction, internal components, installation requirements, fluid compatibility, and application preferences can differ. A structured comparison can help buyers make a more suitable decision.

    Understanding the Gear Mechanism

    The basic external gear design contains two meshing gears.

    One gear drives the other while fluid is transported around the outer area of the gear set.

    This creates a practical method of moving hydraulic fluid through the pump.

    KP products use this general arrangement and are designed for hydraulic machinery applications.

    The exact performance depends on the individual product design and operating environment.

    Housing and Internal Structure

    A pump housing protects the internal mechanism and supports the connection with the hydraulic system.

    Inside the housing, gears, shafts, bearings, and seals work together.

    KP products use compact and robust housing designs, while ordinary gear pumps can have different structural approaches depending on the manufacturer.

    Buyers should compare material, mounting structure, connection arrangement, and component configuration before ordering.

    Flow and Operating Characteristics

    External gear pumps can provide relatively stable fluid delivery.

    At the same time, operating noise and pulsation can vary according to product design and system conditions.

    This makes application assessment important.

    If the equipment requires a particular operating environment, customers should communicate these requirements before selecting a pump.

    Installation

    Installation compatibility is an important purchasing factor.

    The pump must connect correctly with the hydraulic circuit and mechanical drive.

    Mounting position, shaft configuration, inlet and outlet arrangement, and available space should all be reviewed.

    A pump that cannot be integrated correctly may create unnecessary installation difficulties even if its basic pumping principle is suitable.

    Maintenance

    The relatively simple construction of gear pumps can support practical maintenance.

    Users can monitor hydraulic fluid condition, sealing areas, bearings, connections, and internal wear.

    KP products are also described as relatively straightforward to maintain.

    Proper maintenance can help protect the pump from problems associated with contamination, unsuitable operation, or component wear.

    Applications

    KP products are associated with industrial machinery, mobile equipment, agricultural vehicles, and material handling machinery.

    Other gear pumps can also serve these markets, depending on their design.

    The correct choice should therefore be determined by the machine's hydraulic requirements and operating environment.

    Finding a Suitable Product

    A useful comparison should include structure, fluid compatibility, installation, maintenance, operating characteristics, and intended application.

    Customers can then discuss these requirements with a supplier before placing an order.

    For buyers seeking hydraulic gear pumps and related machinery components, Xianju Liming Machinery Co., Ltd. provides further product information and a convenient route for exploring suitable solutions.

    Show Less
  • forum

    Qlik Answers

    FRP vs PC Roofing Panels: A Clear Guide for Building Material Buyers

    The comparison between Chinese Frp Daylighting Panels and PC daylighting products is important for customers planning a roof that needs natural  A... Show More

    The comparison between Chinese Frp Daylighting Panels and PC daylighting products is important for customers planning a roof that needs natural  Although both materials can serve a similar purpose, their structures and application characteristics are not identical. Understanding how they differ can help buyers select a product that matches their building and surrounding conditions.

    FRP for Industrial and Agricultural Spaces

    FRP daylighting products are often considered for buildings where practical roof lighting is required.

    Their reinforced plastic construction can provide useful outdoor resistance, while translucent sections allow daylight to enter through the roof.

    This makes the material relevant to workshops, warehouses, agricultural structures, and other buildings where natural lighting can support the interior environment.

    The final product should be selected according to the roof profile and local conditions.

    PC for Clearer Visual Requirements

    PC daylighting products can offer a different appearance.

    Because polycarbonate can be manufactured with clear or translucent surfaces, it can be considered for projects where visual clarity is important.

    The material can also provide useful impact resistance.

    This makes PC a possible option for buildings where both daylight and physical durability are considered during design.

    Material Differences

    The most obvious difference is the basic material.

    FRP uses reinforced plastic containing glass fiber, while PC uses polycarbonate.

    This distinction affects the way the products are made and handled.

    FRP can provide a textured or diffused appearance depending on its construction. PC can provide a smoother and more glass-like appearance.

    Customers should compare actual product characteristics rather than assuming all sheets made from the same material will behave identically.

    Roof Design Matters

    A daylighting sheet needs to work with the roof around it.

    The shape, profile, connection position, and supporting structure can influence product suitability.

    FRP and PC products may be available in different forms, so buyers should confirm compatibility before placing an order.

    Proper coordination can also make installation and future maintenance more convenient.

    Weather and Outdoor Exposure

    Both materials can be used for outdoor roof applications, but the exact product should be selected according to environmental conditions.

    FRP offers useful corrosion resistance and can be suitable for various exposed settings.

    PC can also perform in outdoor environments and offers impact resistance that may be valuable for some projects.

    Local conditions should always be considered before making a final choice.

    Cleaning and Care

    Roof daylighting products require regular attention.

    Dust and outdoor particles can collect on the surface and influence appearance and light transmission.

    Cleaning should follow suitable material care practices. Inspection of connection areas can also help maintain the roof assembly.

    A product that is convenient to access and clean can make routine building management easier.

    Selecting the Suitable Option

    The choice between FRP and PC depends on the project.

    FRP can be considered where reinforced construction, corrosion resistance, and practical roof integration are important. PC may be attractive for applications requiring impact resistance and a clearer appearance.

    By comparing material, lighting effect, roof compatibility, environment, installation, and maintenance, buyers can make a more suitable decision.

    For further information about daylighting roofing products and related building materials, Hangzhou Chuanya Building Materials Co., Ltd. provides a convenient source for product exploration.

    Show Less
  • forum

    Qlik Answers

    From Pressure Switches to Automatic Controllers

    A Pressure Control Factory can provide a variety of products for customers working with pumps and water management systems. Pressure switches and auto... Show More

    A Pressure Control Factory can provide a variety of products for customers working with pumps and water management systems. Pressure switches and automatic water pump controllers are two important categories, each designed to support controlled equipment operation. Understanding their general purposes can help purchasers, distributors, and installers compare options before selecting components for a specific application.

    Pressure Switch Products

    Pressure switches are used where system pressure is an important part of equipment operation.

    The device can respond to changes within the system according to its intended design and help coordinate the activity of connected equipment.

    When choosing a switch, customers should consider the type of pump and the wider installation.

    The connection arrangement, environment, and control requirements can all affect product suitability.

    A clear understanding of these details can make supplier communication easier.

    Automatic Control Solutions

    Automatic water pump controllers are designed to help manage pump operation with less manual intervention.

    They can be relevant to users who want a convenient way to coordinate water supply equipment.

    The controller should be selected according to the complete system. Compatibility between the product and pump is an important consideration.

    Installation instructions and electrical requirements should also be reviewed before fitting.

    Planning these details in advance can help create a smoother installation process.

    Practical Uses Across Water Systems

    Pressure-related control products can be used in a variety of environments.

    Residential supply is one possible application. Garden irrigation, agricultural water arrangements, building services, and commercial systems may also use suitable control equipment.

    Each system has its own characteristics.

    For this reason, buyers should explain their application rather than simply requesting a general product.

    The more clearly the intended use is understood, the easier it can be to identify an appropriate solution.

    Manufacturing and Quality Management

    Manufacturing involves the coordination of product design, component preparation, assembly, inspection, and packaging.

    Attention to each stage can help support consistent production.

    For buyers, clear product information and responsive communication can make procurement easier.

    A supplier that understands the application can also help customers compare available product categories.

    This is useful for distributors who need to match products with different customer requirements.

    Choosing Between Product Categories

    The choice between a pressure switch and an automatic controller depends on the intended function.

    Some systems may require a straightforward pressure-responsive component. Others may benefit from an automatic management product.

    There is no universal choice for every water installation.

    Buyers should consider the equipment arrangement and desired operation before deciding.

    This application-based approach can help create a more practical purchasing process.

    Building Better Supplier Communication

    Before contacting a manufacturer, customers can prepare basic information about their pump and intended use.

    Details about installation conditions and system requirements can help the supplier provide more relevant product information.

    This can save time during comparison and ordering.

    For customers seeking additional information about pressure switches, automatic controllers, and pump-related control products, Zhejiang Monro M&E Co., Ltd. is available for further product exploration and inquiries.

    Show Less
  • forum

    Data Quality

    How to filter a count with a condition

    Hi i have this result :itemcodedistnumberonhandqty1800000038127-07952.5400001800000038127-08952.5400001800000038127-09952.5400001800000038127-10952.54... Show More

    Hi i have this result :

    itemcodedistnumberonhandqty
    1800000038127-07952.540000
    1800000038127-08952.540000
    1800000038127-09952.540000
    1800000038127-10952.540000
    1800000038127-13952.540000
    1800000038127-14952.540000
    1800000038127-15952.540000
    1800000038127-16952.540000
    1800000038127-17952.540000
    1800000038127-18952.540000
    1800000038127-19952.540000
    1800000038127-20952.540000
    1800000038128-01952.540000
    1800000038128-02952.540000
    1800000038128-03952.540000
    1800000038128-04952.540000
    1800000038128-05952.540000
    1800000038128-06952.540000
    1800000038128-07952.540000
    1800000038128-08952.540000
    1800000038128-09952.540000
    1800000038128-10952.540000
    1800000038128-11952.540000
    1800000038128-12952.540000
    1800000038128-13952.540000
    1800000038128-14952.540000
    1800000038128-15952.540000
    1800000038128-16952.540000
    1800000038128-17952.540000
    1800000038128-18952.540000
    1800000038128-19952.540000
    1800000038128-20952.540000
    1800000040132-35400.000000
    1800000040132-36400.000000
    1800000040132-37400.000000
    1800000040132-38400.000000
    1800000040132-39400.000000
    1800000040132-40400.000000
    1800000040133-01400.000000
    1800000040133-02400.000000
    1800000040133-03400.000000
    1800000040133-04400.000000
    1800000040133-05400.000000
    1800000040133-06400.000000
    1800000040133-07400.000000
    1800000040133-08400.000000
    1800000040133-09400.000000
    1800000040133-10400.000000
    1800000040133-11400.000000
    1800000040133-12400.000000
    1800000040133-13400.000000
    1800000040133-14400.000000
    1800000040133-15400.000000
    1800000040133-16400.000000
    1800000040133-17400.000000
    1800000040133-18400.000000
    1800000040133-19400.000000
    1800000040133-20400.000000
    1800000040133-21400.000000
    1800000040133-22400.000000
    1800000040133-23400.000000
    1800000040133-24400.000000
    1800000040133-25400.000000
    1800000040133-26400.000000
    1800000040133-27400.000000
    1800000040133-28400.000000
    1800000040133-29400.000000
    1800000040133-30400.000000
    1800000040133-31400.000000
    1800000040133-32400.000000
    1800000040133-33400.000000
    1800000040133-34400.000000
    1800000040133-35400.000000
    1800000040133-36400.000000
    1800000040133-37400.000000
    1800000040133-38400.000000
    1800000040133-39400.000000
    1800000040133-40400.000000

     

    i  want only a résult by item code with only the min of the three first number of distnumber and a count of this condition so the result is :

     

    into my table graphic i use 

    first colum =  dimension 

    second :  Min( SubField(distnumber, '-', 1) )  (take only the min of the distnumber)

    last colum  :count(
    {<
    distnumber = {"*$(=Aggr(Min(Left(distnumber,3))), U_CapacItemcode)*"}
    >} distnumber
    )

     

    i have this result  (no correct, the correct is  12  for the O-71 (1800000038) , here is the total of the distnumber 127 and 128 of the 1800000038  (O-71)

    mahieuphilippe_0-1763539945143.png

     

    this is the correct result   how to have the good résult ?  thanks

     

    180000003812712
    18000000401326
    Show Less
  • forum

    App Development

    Aggr + Stdev by Material Group

    Hi,I got the following request from the business:for each Material Group, how many of the last 6 days had a complaint count greater than the Material ... Show More

    Hi,

    I got the following request from the business:

    for each Material Group, how many of the last 6 days had a complaint count greater than the Material Group’s rolling 12-month average + standard deviation.

    My current measure is:

    Count(
        {<
            [Complaint Open Date] =
            {">=$(vLast6Days)<=$(vMaxComplainDate)"}
        >}
        Aggr(
            If(
                Count(
                    Distinct
                    {<
                        [Classification 1] = {'Contact Complaint'}
                    >}
                    [Complaint Number]
                )
                = $(vAvgAndStdevCompGeneral),
                1
            ),
            [Complaint Open Date]
        )
    )

    The variable vAvgAndStdevCompGeneral is currently:

    (
        (
            Aggr(
                Count(
                    Distinct
                    {<
                        [Classification 1] = {'Contact Complaint'}
                    >}
                    [Complaint Number]
                ),
                [Material Group Code]
            )
        )
        /
        Count(
            {<
                [Material Group Code] =,
                [Material Group] =
            >}
            Distinct [Complaint Open Date]
        )
    )
    +
    Stdev(
        Aggr(
            Count(
                {<
                    [Classification 1] = {'Contact Complaint'},
                    COMP_isWorkingDay = {'1'}
                >}
                [Complaint Number]
            ),
            [Complaint Open Date]
        )
    )

    The measure works when I select one Material Group, but not when Material Group is used as a dimension in a table.

    I now also need the average to be based on a rolling 12-month period, while the final count should still evaluate only the last 6 days.

    How should I modify the expression so that the calculation works independently for every Material Group in the table?

     

    Thx

    Show Less
  • forum

    Stitch

    Cannot save or update Postgres integration on Stitch UI

    Our vender informs us the IP address for the SSH Host had been changed and we need to update to a new IP address. Nothing else has been changed. In th... Show More

    Our vender informs us the IP address for the SSH Host had been changed and we need to update to a new IP address. Nothing else has been changed.

    In the configure your PostgreSQL Integration UI.

    I updated the IP in SSH Host -> click update settings but nothing happened (no error messages in the front end).

    We find status code 400 Bad Request and the following error message in the Chrome's dev mode under "Network".

    However, we are not an expert in this area. What could be the issues? Vendor confirmed all the information we enter are correct.

    {
    "error": "LocalUriProperties",
    "data": {
    "message": "one or more properties could not be resolved to an address",
    "bad_properties": [
    "host"
    ],
    "report_card": {
    "type": "platform.hp-postgres",
    "current_step": 2,
    "current_step_type": "fully_configured",
    "steps": [
    {
    "type": "form",
    "properties": [
    {
    "name": "accumulator_size",
    "value": "[REDACTED]"
    },
    {
    "name": "anchor_time",
    "value": "[REDACTED]"
    },
    {
    "name": "cron_expression",
    "value": "[REDACTED]"
    },
    {
    "name": "dbname",
    "value": "[REDACTED]"
    },
    {
    "name": "default_replication_method",
    "value": "[REDACTED]"
    },
    {
    "name": "filter_dbs",
    "value": "[REDACTED]"
    },
    {
    "name": "frequency_in_minutes",
    "value": "[REDACTED]"
    },
    {
    "name": "host",
     "tap_mutable": false,
    "property_type": "user_provided",
    "system_provided": false,
    "clonable": true,
    "json_schema": {
    "type": "string",
    "anyOf": [
    {
    "format": "hostname"
    },
    {
    "format": "ipv4"
    },
    {
    "pattern": "^(?:[a-zA-Z0-9](?:[a-zA-Z0-9-]*[a-zA-Z0-9])?\\.)*[a-zA-Z0-9](?:[a-zA-Z0-9-]*[a-zA-Z0-9])?$"
    }
    ]
    },
    "is_credential": false,
    "provided": false
    },
    },
    {
    "name": "image_version",
    "value": "[REDACTED]"
    },
    {
    "name": "include_schemas_in_destination_stream_name",
    "value": "[REDACTED]"
    },
    {
    "name": "incremental_limit",
    "value": "[REDACTED]"
    },
    {
    "name": "itersize",
    "value": "[REDACTED]"
    },
    {
    "name": "logical_poll_total_seconds",
    "value": "[REDACTED]"
    },
    {
    "name": "password",
    "value": "[REDACTED]"
    },
    {
    "name": "port",
    "value": "[REDACTED]"
    },
    {
    "name": "replication_slot_name",
    "value": "[REDACTED]"
    },
    {
    "name": "socket_timeout",
    "value": "[REDACTED]"
    },
    {
    "name": "ssh",
    "value": "[REDACTED]"
    },
    {
    "name": "ssh_host",
    "value": "[REDACTED]"
    },
    {
    "name": "ssh_port",
    "value": "[REDACTED]"
    },
    {
    "name": "ssh_user",
    "value": "[REDACTED]"
    },
    {
    "name": "ssl",
    "value": "[REDACTED]"
    },
    {
    "name": "user",
    "value": "[REDACTED]"
    },
    {
    "name": "use_log_based_replication",
    "value": "[REDACTED]"
    }
    ]
    },
    {
    "type": "discover_schema",
    "properties": []
    },
    {
    "type": "field_selection",
    "properties": []
    },
    {
    "type": "fully_configured",
    "properties": []
    }
    ]
    }
    }
    }

     

     

     

    Show Less
  • forum

    Water Cooler

    What Customers and Partners Can Expect from new Qlik CEO Saugata Saha

    A clear vision, candid communication, strong execution, and a focus on creating value together.  In his first interview as Qlik CEO, Saugata Saha shar... Show More

    A clear vision, candid communication, strong execution, and a focus on creating value together. 

    In his first interview as Qlik CEO, Saugata Saha shares what customers and partners can expect from his leadership and why collaboration across the Qlik ecosystem will be central to the opportunity ahead. 

    In the full conversation, Saugata also discusses: 

    • What drew him to Qlik  
    • His perspective on data and AI  
    • The importance of Qlik’s customers and partner ecosystem  
    • His priorities for the first 90–100 days  

    Watch the full conversation:

     

    As Saugata shares, the future is bright! To help you look ahead in style, we're sending Qlik sunglasses to our Qlik Community members 😎 

    Please join us in welcoming Saugata to Qlik and the Qlik Community. Share your reactions and thoughts with Saugata below, and we will send you a pair of Qlik shades (while supplies last). 

     

     

    Show Less
  • forum

    Maceió

    Qlik Locals – Maceió #04: Obrigado por fazer parte dessa experiência! 💚🚀

     💚Obrigado por fazerem parte do Qlik Locals – Maceió! 🚀 Mais uma edição concluída — e que experiência incrível!Gostaríamos de agradecer a todos que ... Show More

     

    💚Obrigado por fazerem parte do Qlik Locals – Maceió! 🚀



    IMG_5294.jpg

     

    Mais uma edição concluída — e que experiência incrível!

    Gostaríamos de agradecer a todos que participaram do Qlik Locals – Maceió #04, reservaram um espaço na agenda para estar conosco, acompanharam as palestras, participaram das conversas e contribuíram para tornar este encontro tão especial.

    Foi muito bom ver nossa comunidade reunida novamente, compartilhando experiências e discutindo temas que já estão transformando a forma como trabalhamos com dados e inteligência artificial, como MCP, LLMs, governança, dados preparados para IA e novas experiências de Analytics.

    Um agradecimento especial aos nossos palestrantes, convidados da mesa-redonda, parceiros e a todos que contribuíram para a realização do evento. Cada apresentação, pergunta, conversa e troca de experiência ajudou a construir o que o Qlik Locals realmente representa: uma comunidade feita por pessoas que acreditam no poder dos dados e, principalmente, no poder de compartilhar conhecimento.

    Também foi um prazer receber tantos de vocês no estande da Qlik durante o RogaDX 2026, participando das nossas atividades e aproveitando mais um espaço para conversar, aprender e criar novas conexões.

    E, para quem participou pela primeira vez: seja muito bem-vindo à nossa comunidade! 💚 

    Muito obrigado a todos que fizeram parte desta edição. Nos vemos no próximo Qlik Locals – Maceió! 🚀💚

    Ps.: Em breve estaremos postando aqui todas fotos oficiais do nosso evento, fiquem de olho 👀

    #Qlik #QlikLocals #QlikCommunity #RogaDX2026 #Maceió #Analytics #ArtificialIntelligence #MCP #LLM #DataGovernance #AIReadyData

    Show Less
  • forum

    Women Who Qlik

    Building and growing a Strong Team

    This week, we will discuss how leaders can create opportunities for their teams to learn, experiment, and grow. We’ll explore the top skills to focus... Show More

    Community Forum Banner_Career_Growth_Series (2).png

    This week, we will discuss how leaders can create opportunities for their teams to learn, experiment, and grow. We’ll explore the top skills to focus on when building or developing a team and share strategies for fostering adaptability and resilience in the face of shifting priorities.

     

    Related Content:

    Article: Important Steps When Building a New Team

    Ted Talk: How diversity makes teams more innovative | Rocío Lorenzo

     

    Resources:

    Article: 23 Ways To Build a Successful Team in 2026

     

    Share your thoughts in the comments. What opportunities can leaders create to help teams learn, experiment, and grow?

    Show Less
  • forum

    App Development

    Create a dynamic table from 3 lists of values

    I have a database table with the table_name, columns(list of all columns),old_value(for each dynamic column),new_value(for each dynamic column) of an ... Show More

    I have a database table with the table_name, columns(list of all columns),old_value(for each dynamic column),new_value(for each dynamic column) of an entire database. I would like to create a dynamic table of based on the table_name the user picks and populate the table with dynamic fields based on the names of the fields in the columns list and have the old and new values for each field.  I can show the users the three lists but it is hard to review as there can be 3 to 21 fields based on the table's name they pick to view.  What would a loader script look like to do this as each table's fields and values are dymamic based on the lists found in the database columns

    Show Less
Leaderboard

Qlik community MVPs

Qlik Community MVPs — trusted experts driving collaboration, learning, and innovation.

mvp-banner-side-image

Customer Story

Data Drives the Reconstruction of an Entire State

Data Restores Confidence: How SEFAZ-RS Used Qlik to Support the Rebuilding of a State.

Customer Story

Qlik platform helps structure an analytics ecosystem to support diagnostic medicine and healthcare.

AFIP revolutionizes management, optimizes resource allocation and strengthens data-driven culture

Customer Story

Hapag-Lloyd Enables Smart Decisions With Qlik

Global container shipping giant delivers data transparency to enable confident decision-making and operational efficiency.

Customer Story

Students See Data Come to Life With Qlik Academic Program

Qlik turns raw data into valuable learning experiences, empowering both students and faculty at TTUHSC.

Customer Story

MillerKnoll Unifies Data with Qlik Talend

MillerKnoll partnered with Qlik Talend® data solutions to unify data across its diverse systems, accelerating critical processes and nearly eliminating data integration issues organization-wide.

Customer Story

Radiall Embraces the Cloud and Improves Operational Efficiency

Migration to Qlik Cloud Analytics optimizes analytics applications within months.

Customer Story

French Ministry of Armed Forces Develops a Data-Centric Culture

With Qlik Cloud Analytics, Rexel boosts performance by enabling self-service analysis, reducing prep time, and giving 3,000 users access to trusted insights.

Your Place, Your People

Choose a Group

Join one of our Location and Language groups. Find one that suits you today!

Collaborate

Qlik en México

Qlik en México

Únete a la conversación con usuarios de Qlik en todo México: comparte ideas, haz preguntas y conéctate en español.

All are welcome

Hello from Japan

Japan

Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。

Request to join

Parlons Données

Parlons Données

Connectez-vous avec des utilisateurs francophones de Qlik pour collaborer, poser des questions et partager des idées.

open to all

AI Reality Tour

Zurich

Join data and AI leaders in Zurich on June 10, 2026 to learn how to scale AI and drive real enterprise impact.