Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
7,030 online
Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING

Welcome to Qlik Community

Data Analytics

Forums for Qlik Data Analytics 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

QlikWorld 2022

This year’s go-to data event is full of inspiring speakers, informative sessions, ideas for up-leveling your data integration and analytics.

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

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

  • No Boards Found
  • forum

    QlikView App Dev

    Extract 6-digit number string from text fied

    Dear all,I have a text field covering various information, such as cost center number, creditor, number, date number and text information.I want to ex... Show More

    Dear all,

    I have a text field covering various information, such as cost center number, creditor, number, date number and text information.

    I want to extract the creditor information. The issue I have is, that the Position of the creditor number within the text field is not consistent and that I have multiple information with numbers. Thus keepchar formula or left/right funktion I tried didn't work properly.

    The critieria that would be unique are, that the creditor number has always 6 Digits and can only be between 700000 and 899999.

    Can you think of combination of QV-functions that would cover above requirements?

    Thanks and best regards,

    Tobias

    Show Less
  • forum

    Integration, Extension & APIs

    Create Extension Bundle

    Hello, I have several extensions and want to build a bundle for better overview. For example a bundle with KPI Objects, a bundle with other chart obje... Show More

    Hello, 

    I have several extensions and want to build a bundle for better overview. For example a bundle with KPI Objects, a bundle with other chart objects, and so on. Is this possible? 

    When I create simple Widgets in the Dev Hub, I can organize them in libraries. So, I can see this libraries in Qlik Sense when I create a new App. I want the same with extensions. 

     

    denisb_0-1601295937603.png

     

     

    Thanks

    Show Less
  • forum

    Qlik NPrinting Discussions

    Qlik NPrinting On-demand with on-demand/flex table Qlik Sense

    Hi!Is there somebody out here with experience developing a on-demand/flex table with the option to export the output with the on-demand NPrinting opti... Show More

    Hi!

    Is there somebody out here with experience developing a on-demand/flex table with the option to export the output with the on-demand NPrinting option in Qlik Sense?

    As we know there are some differences between exporting tables to MS Excel between Qlikview and Qlik Sense. I know Qlik's answer is that we are talking to different products here... but this is hard to explain to a finance department and I must say... I agree with them.

    So I'm trying to make things possible with the use of on-demand NPrinting.  I've build a flex/on-demand straight table. (https://community.qlik.com/t5/Qlik-Design-Blog/Customizable-Straight-Table/ba-p/1464825 ) This is working just fine in the front-end. Exporting the table with the on-demand option is working.... as long as you don't need or want the totals of your table in your exported excel file. But guess what... in this case I need the totals.

    It's not possible to rebuild the table in the nprinting template since all columns are conditional.

    I'm running out of options here. I know there are some 3th party extensions that cover this subject. But maybe i'm overlooking something here. 

    Thank you in advance!

    Kind regards, Tamarah

     

    Show Less
  • forum

    New to Qlik Sense

    Set analysis to ignore current selection

    Hi, i have an expression below: =count({<org_name -= {GetFieldSelections(org_name)}>}patient_region) In this I am trying to insert a set analysis to i... Show More

    Hi, i have an expression below:

    =count({<org_name -= {GetFieldSelections(org_name)}>}patient_region)

    In this I am trying to insert a set analysis to ignore the current selection made on the [org_name] field. I keep getting an error. What is the proper expression for it?

    Thanks in advance!

    Show Less
  • forum

    Qlik Replicate

    Stopping Replicate tasks while Source DB still active

    Client needs to do maintenance on the target DB and has asked for the Replicate tasks to be paused.  If I pause the tasks, can the Source database rem... Show More

    Client needs to do maintenance on the target DB and has asked for the Replicate tasks to be paused.  If I pause the tasks, can the Source database remain active and any activity will catch up when the tasks are restarted?  If so, do I need to start the tasks from a point in time or just resume?

    This is last minute request for maintenance tonight and I want to be sure I manage the tasks correctly.  Any assistance is appreciated.

     

    Thank you,

    Mary

    Show Less
  • forum

    New to Qlik Sense

    Load data from web page

    do you have anyway i can load the data from this url to either qlikview or qlik sense?   Non-ferrous metals | London Metal Exchange (lme.com)
  • forum

    Connectivity & Data Prep

    Use 2 fields from different tables in one filter

    hi, i have 2 different tables: Example: Table1: ID Name 1 Name1 2 Name1 3 Name2 4 Name2 5 Name3   Table2: ID Name 1 Name3 1 Nam... Show More

    hi,

    i have 2 different tables:

    Example:

    Table1:

    ID Name
    1 Name1
    2 Name1
    3 Name2
    4 Name2
    5 Name3

     

    Table2:

    ID Name
    1 Name3
    1 Name2
    3 Name3


    I want to have one filter where i search the name from table1 or table 2.

    I've seen solutions but only with the data load editor, which we dont want to use if possible, because we are using the data manager 😕
    Is there any way to do it in the frontend?

    In sql it would be a simple ... where Table1.Name = X or Table2.Name = X

    Show Less
  • forum

    New to Qlik Sense

    Executing non-SELECT queries is disabled

    Hi, executing CTE in Qlik Sense Desktop i have  Executing non-SELECT queries is disabled How to enable non-SELECT queries with Microsoft SQL Server Co... Show More

    Hi,

    executing CTE in Qlik Sense Desktop i have

     Executing non-SELECT queries is disabled

    How to enable non-SELECT queries with Microsoft SQL Server Connector (no ODBC Connector).

    Regards,

    Antonio

     

    Show Less
  • forum

    New to Qlik Sense

    Set analysis and IF statement / Beginner

    Hi, I am relatively new to Qlik and fully new to set analysis, thus I would appreciate your advice. I was trying to get set analysis to get constant g... Show More

    Hi,

    I am relatively new to Qlik and fully new to set analysis, thus I would appreciate your advice.

    I was trying to get set analysis to get constant graph results, regardless of filters, that is why i used the 1 identifier:

    if ({1<[Tab1] like {'ABC*'}>}, {1<[Tab1]>})

    I have tried to rewrite it in different configurations as suggested in a few forum conversations, so far unsuccesfully.

    Show Less
  • forum

    App Development

    Mapping load and apply map

    Hi I am facing an issue in mapping load script. MappingTableAddr: Mapping load  CustomerID, Address from abc.qvd; MappingTableCity: Mapping load  Cust... Show More

    Hi

    I am facing an issue in mapping load script.

    MappingTableAddr:

    Mapping load 

    CustomerID,

    Address

    from abc.qvd;

    MappingTableCity:

    Mapping load 

    CustomerID,

    City

    from abc.qvd;

    Table11:

    BillDate,

    CustomerID,

    Applymap('MappingTableAddr',CustomerID,'NA') as Address,

    Applymap('MappingTable'City,CustomerID,'NA') as City

    from abc.qvd;

     

    My raw data is 

    qlikuser22_0-1642512868775.png

    I have null values for the bill date 1.4.21. I would like to copy the same address since the customer ID is same. I tried the above code but I still get NULL values. Any help.

     

    Thanks in advance!

    Show Less

Get Started On Community

Start Here Get Started On Community

Top Participants

Blogs

Product Innovation Blog

Learn about what's new across all of the products in our growing Qlik product portfolio.

Blogs

Qlik Community Manager Blog

Hear from the Qlik Community team about the latest platform enhancements and other topics.

Blogs

Support Updates Blog

Important and useful support information about end-of-product support, new service releases, and general support topics.

German Group

Deutsche User Group

German speaking - This group makes it easier to collaborate in your local language.

Request to join

Brazil Group

Brazil

This group for Brazil users. All discussions are in Portuguese.

open to all

Industry Group

Public Sector Group

This is a open Group for the Public Sector

All are welcome

Events

Espresso Webinars - From Data Integration to Analytics in Action

These webinars get straight to the point, they are strong, short, and with immediate effect – like an espresso.

Upcoming and On-Demand

Events

Talk to Experts Tuesday

You’ve got questions? We’ve got answers! Talk to Experts is a live Q&A Webinar series! Join and ask your questions about Qlik Sense Enterprise, Client Managed.

June 29, 2021 10AM EST

Events

Cloud Data and Analytics Tour

Ready to steer your business towards data-informed growth? Our Cloud Data & Analytics Tour is the perfect place to start your journey.

Choose your Region