Skip to main content

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 188,775 members
  • 5,891 online
  • 1,742,976 posts
  • 133,651 Solutions
Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW

Welcome to Qlik Community

FOR NEW MEMBERS

Everything you need to make your Qlik Community experience valuable.

SEARCH KNOWLEDGE BASE

Explore official Support and member created content.

QLIKWORLD 2023!

Welcome Emmy award-winning Katie Linendoll as our emcee and world record-holding cave diver John Volanthen as our keynote speakers.

Analytics

Forums for Qlik Analytic solutions. Ask questions, join discussions, find solutions, and access documentation and resources.

Data Integration

Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources

Qlik Gallery

Share your best Qlik apps and discuss impacts with peers! Show your work and get recognized for innovative uses of Qlik technologies.

Ideation

Participate in Qlik Technical Previews, submit ideas, and review documentation.

Support

Chat with us, search Knowledge, open a Case, read the latest Updates Blog, find Release Notes, and learn about our Programs.

Events

Learn about upcoming Qlik related events, webinars and local meetups.

Groups

Join a Group that is right for you and get more out of your collaborations. Some groups are closed. Closed Groups require approval to view and participate.

About Qlik Community

Get started on Qlik Community, find How-To documents, and join general non-product related discussions.

Blogs

Hear directly from Qlik employees in our ten unique blogs.

Qlik Resources

Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.

Qlik Academic Program

Qlik gives qualified university students, educators, and researchers free Qlik software and resources to prepare students for the data-driven workplace.

Community Sitemap

Here you will find a list of all the Qlik Community forums.

Recent Discussions

  • forum

    New to Qlik Sense

    Ip detail

    Hi  while running below command why I am getting different ip, what are all those Ips  
  • forum

    New to Qlik Sense

    Column transformation removal of extra numbers

    Hi   I have sample data as show below Parent ABC-1013.V2-24187 ABC-1013.V2 ABC-1046.V2-24428 ABC-1046.V2 ABC-1178.V2-25465 ABC-1178.V2 ... Show More

    Hi

     

    I have sample data as show below

    Parent
    ABC-1013.V2-24187
    ABC-1013.V2
    ABC-1046.V2-24428
    ABC-1046.V2
    ABC-1178.V2-25465
    ABC-1178.V2
    ABC-1229.V2-25925
    ABC-1229.V2
    ABC-1250.V2-26366
    ABC-1250.V2
    ABC-1323.V2-27096
    ABC-1323.V2
    ABC-1365.V2-24243
    ABC-1365.V2
    ABC-1597.V2-19167
    ABC-1597.V2
    ABC-1631.V2-25265
    ABC-1631.V2
    ABC-1701.V2-21053

    Output should for above table:

    parent
    ABC-1013.V2
    ABC-1013.V2
    ABC-1046.V2
    ABC-1046.V2
    ABC-1178.V2
    ABC-1178.V2
    ABC-1229.V2
    ABC-1229.V2
    ABC-1250.V2
    ABC-1250.V2
    ABC-1323.V2
    ABC-1323.V2
    ABC-1365.V2
    ABC-1365.V2
    ABC-1597.V2
    ABC-1597.V2
    ABC-1631.V2
    ABC-1631.V2

     

    and I have 2nd Requirement:

     

    Table 2:

    Column A, "Requirement is the data set", I want to get the Column B "Expected Output"

    These two requirements, Can anyone please help me on this

    Requirement Expected Output
    ABC-1046.V2 (3) ABC-1046.V2
    ABC-1178.V2 (3) ABC-1178.V2
    ABC-1229.V2 (3) ABC-1229.V2
    ABC-1597.V2 (3) ABC-1597.V2
    ABC-1701.V2 (32) ABC-1701.V2
    ABC-5018.V1 (3) ABC-5018.V1
    ABC-5025.V1 (3) ABC-5025.V1
    ABC-5056.V1 (3) ABC-5056.V1
    ABC-5058.V1 (4) ABC-5058.V1
    ABC-5059.V1 (3) ABC-5059.V1
    ABC-5064.V1 (3) ABC-5064.V1
    ABC-5065.V1 (3) ABC-5065.V1
    ABC-5082.V1 (1) ABC-5082.V1
    ABC-5119.V1 (1) ABC-5119.V1
    ABC-1631.V2 (3) ABC-1631.V2
    ABC-5067.V1 (4) ABC-5067.V1
    ABC-5091.V1 (4) ABC-5091.V1
    ABC-5106.V1 (4) ABC-5106.V1
    ABC-5107.V1 (1) ABC-5107.V1
    ABC-994.V3 (3) ABC-994.V3
    ABC-5060.V1 (3) ABC-5060.V1
    ABC-5086.V1 (6) ABC-5086.V1
    ABC-5087.V1 (6) ABC-5087.V1
    ABC-5093.V1 (2) ABC-5093.V1
    ABC-5094.V1 (1) ABC-5094.V1
    ABC-5095.V1 (3) ABC-5095.V1
    ABC-5098.V1 (1) ABC-5098.V1
    ABC-5100.V1 (1) ABC-5100.V1
    ABC-5113.V1 (1) ABC-5113.V1
    ABC-5114.V1 (1) ABC-5114.V1
    ABC-5115.V1 (1) ABC-5115.V1
    ABC-5116.V1 (1) ABC-5116.V1
    ABC-5117.V1 (1) ABC-5117.V1
    ABC-5118.V1 (1) ABC-5118.V1
    ABC-975.V2 (3) ABC-975.V2
    ABC-976.V2 (3) ABC-976.V2
    ABC-1013.V2 (3) ABC-1013.V2
    ABC-1250.V2 (3) ABC-1250.V2
    ABC-1323.V2 (3) ABC-1323.V2
    ABC-1365.V2 (3) ABC-1365.V2
    ABC-28.V2 (3) ABC-28.V2
    ABC-417.V2 (3) ABC-417.V2
    ABC-419.V2 (6) ABC-419.V2
    ABC-5004.V1 (1) ABC-5004.V1
    ABC-5061.V1 (3) ABC-5061.V1

     

    Show Less
  • forum

    Qlik Replicate

    Failed to connect. SYS,GENERAL_EXCEPTION,Failed to connect,RetCode: SQL_ERROR Sq...

    Hi all, I'm using MS SQL SERVER is a source database and target database as well.(For Qlik replicate). My Question is Here: Log  stream is stopped and... Show More

    Hi all,

    I'm using MS SQL SERVER is a source database and target database as well.(For Qlik replicate).

    My Question is Here: Log  stream is stopped and due to below this error  and I'm unable to resume the log stream and end point connections also not succeeded.    

    Creating Metadata Manager's utility components failed
    Cannot create the source utility component
    Failed while preparing stream component (Source database)
    Failed to connect
    RetCode: SQL_ERROR SqlState: 08001 NativeError: 10061 Message: [Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: No connection could be made because the target machine actively refused it.

    Show Less
  • forum

    New to Qlik Sense

    Calendar setting (default setting for xxx months)

    Is it possible to set the initial value of the calendar to the same period (for example, 2 months) on all sheets? I'm currently using items from a dat... Show More

    Is it possible to set the initial value of the calendar to the same period (for example, 2 months) on all sheets?

    I'm currently using items from a data table for my calendar.
    The date values in each data (data table A.data, data table B.data, data table C.data) are different, but I would like to specify two months as an initial setting.
    How can I set it so that when I open the app and open a sheet, I can specify the dates for the last two months no matter which sheet I open?

    ex)
    Sheet A:
    Calendar → Data table A.data

    Sheet B:
    Calendar → Data table B.data

    Sheet C:
    Calendar → data table C.data

    Show Less
  • forum

    New to Qlik Sense

    filter and output result table

    Hi. I want to ask about filter and output result table.When I select data in the output result table, I want nothing to happen (the filter condition d... Show More

    Hi. I want to ask about filter and output result table.
    When I select data in the output result table, I want nothing to happen (the filter condition does not change).

    I'm trying to narrow down the conditions with a filter and display the selected conditions in a table.
    As you select some values in this output table, the filter criteria will change accordingly.
    Is it possible to lock the result table so that nothing changes when clicked?

    Thank you.

    Show Less
  • forum

    QlikView App Dev

    Qlikview: Add an existing PDF-file to a report (and print the combination to PDF...

    Hi All In a dashboard I create a nice report but I want to combine this with an existing report. The external two-pages pdf should become some kind of... Show More

    Hi All

    In a dashboard I create a nice report but I want to combine this with an existing report.

    The external two-pages pdf should become some kind of object that will be embedded into my style. Is this possible?

    Even better would it be that I could define the exact two positions on a page so that the source can be cropped to those two points.

    Anyone who had to deal with such a challenge?

    Thanks,

    Alex

    Show Less
  • forum

    QlikView App Dev

    Sort value on top, then descending on another dimension

    Hi all!I'm new here, I really need your help.🖐I have a source table with 3 dimensions   Date1 Product Value 31.01.2023 D 15 30.01.2023 C 0 3... Show More

    Hi all!
    I'm new here, I really need your help.🖐
    I have a source table with 3 dimensions

     
    Date1 Product Value
    31.01.2023 D 15
    30.01.2023 C 0
    31.01.2023 C 10
    31.01.2023 B 0
    28.01.2023 B 0
    31.01.2023 A 0
    29.01.2023 B 5
    27.01.2023 B 10
    30.01.2023 A 12
     

    My goal is to sort it like this

    Date1 Product Value
    31.01.2023 A 0
    31.01.2023 B 0
    30.01.2023 B 0
    30.01.2023 C 0
    29.01.2023 A 0
    28.01.2023 A 0
    31.01.2023 B 15
    31.01.2023 C 10
    30.01.2023 D 20

     

    So that zeros are at the top, sorted by date in descending order and product alphabetically, all other values are also sorted by date in descending order and product alphabetically.

    I know it can be done with a hidden column, but my goal is not to use an extra column.

    When I sort by value expression I don't get what I want

    P1.png

    Not all dates are descending

    I want to get this result

    P2.png

    I attach an example qvw

    It seems like it should be very simple, but I can't find a solution.
    I would appreciate any help ‌‌‌‌‌‌🙏

    Show Less
  • forum

    Qlik Replicate

    Error: Failed to connect to SQL Server EndPoint. Failed to load 'SQL Server Nati...

    Hola,Here in our European project we are receiving the following error when trying to create Endpoint connection using Microsoft SQL Server.SYS-E-HTTP... Show More

    Hola,

    Here in our European project we are receiving the following error when trying to create Endpoint connection using Microsoft SQL Server.

    SYS-E-HTTPFAIL, Stream component initialization function has failed for component 'SQL Server', type 'SQL Server'..

    • SYS,GENERAL_EXCEPTION,Stream component initialization function has failed for component 'SQL Server', type 'SQL Server'.,Error Initializing endpoint. Failed to load 'SQL Server Native Client 11.0' Cannot load <sqlncli11.dll, >: The operation completed successfully. Cannot load <sqlncli11.dll>: The specified module could not be found.

     

    We have ensured the SQL Server Native Client 11.0 is installed from here https://www.microsoft.com/en-sg/download/details.aspx?id=36434

    We can see the sqlncli11.dll file in the C:\Windows\WinSxS\amd64... folder.

    Anybody know how to solve this error please?

    Show Less
  • forum

    New to Qlik Sense

    A measure evaluting/counting another measure

    I have a key (e.g. AN) that consists out of several attributes (e.g. AN-WERT2, AN-XW2JA), which each have a value (e.g. 0, Yes).   What I would like ... Show More

    I have a key (e.g. AN) that consists out of several attributes (e.g. AN-WERT2, AN-XW2JA), which each have a value (e.g. 0, Yes).

    Thomas_Qlik_0-1678999186900.png

     

    What I would like to do is to compare for each attribute the AS IS values against certain predefined TO BE values. I have written a measure m_P2P09_Attribute_Compliant, which compares the two tables holding the AS IS and TO BE values with each other.

    As a second step –and here I get stuck- I want to assess for each key whether it is compliant. Meaning: All the attributes of this key are compliant (Measure m_P2P09_Attribute_Compliant=”Yes”). If a key has one or more attributes with “No” it would not be compliant.

    I thought I could do this assessment with another Measure: m_P2P09_Key_Compliant, which would deliver back “Yes” or “No”.

    Can anybody please help me out how the logic of the Measure m_P2P09_Key_Compliant measure would look like?

     

    Much appreciated,

    Thomas

    Show Less
  • forum

    App Development

    QDF And structure of subs

    I’m curious, how do you store your subs? I’m torn between storing them all in one script, storing them collected into “library scripts”,  or one scrip... Show More

    I’m curious, how do you store your subs?

    I’m torn between storing them all in one script, storing them collected into “library scripts”,  or one script per sub.

    The QDF subs are stored with each sub in a separate script.

    What do you prefer, and why?

    Qlik Sense Enterprise on Windows

    Show Less

Blogs

Community News

Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!

Blogs

Qlik Academic Program Blog

Read the latest blog around the Qlik Academic Program.

Blogs

Qlik Product Innovation Blog

If you want to know what's new across all of the products in our growing Qlik product portfolio.

Blogs

Support Updates Blog

Get the latest Support information about end-of-product support, new service releases, and general support topics.

Blogs

Qlik Design Blog

Read all about Qlik solutions: scripting, data modeling, visual design, extensions, best practices and more.

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

Events and Webinars

QlikWorld 2023, Technical Workshops!

10+ hours of roll up your sleeves, immersive working sessions. A $1000 value included in your conference pass!

Choose your workshops

Events and Webinars

Qlik and Qlik Community Hosted Events

Subscribe to our Events and Webinar page so you do not miss an event opportunity!

choose and register

Event

Welcome to Qlik

Join the "Welcome to Qlik" webinar and learn about the Qlik Ecosystem, such as Qlik Community, Learning, and Help.

On-Demand

Events

Upcoming Events and Webinars

There is more than one way to find upcoming events, look on the right side of any Qlik Community forum!

Upcoming

Events and Webinars

Qlik and Qlik Community Hosted Events

Subscribe to our Events and Webinar page so you do not miss an event opportunity!

choose and register

Event

Welcome to Qlik

Join the "Welcome to Qlik" webinar and learn about the Qlik Ecosystem, such as Qlik Community, Learning, and Help.

On-Demand

Events

Upcoming Events and Webinars

There is more than one way to find upcoming events, look on the right side of any Qlik Community forum!

Upcoming