Qlik Community

Ask a Question

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
4,758 online

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

Qlik Academic Program

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

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.

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.

Support

Access Support programs, Knowledge Base, Updates blog, and Release Notes.

Community Sitemap

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

Recent Discussions

  • No Boards Found
  • forum

    App Development

    Replace load issue

    I want to concat the tables. so I use this script but it doesn't workI am sharing the errow below. how can I work on this?thanksFOR i = 0 to NoOfTable... Show More

    I want to concat the tables. so I use this script but it doesn't work

    I am sharing the errow below. how can I work on this?

    thanks

    FOR i = 0 to NoOfTables()
    TableList:
    LOAD TableName($(i)) as Tablename AUTOGENERATE 1
    WHERE WildMatch(TableName($(i)), 'ZCS_BOM_EXPL_MAT_V2*');
    NEXT i

     

    FOR i = 1 to FieldValueCount('Tablename')

    LET vTable = FieldValue('Tablename', $(i));
    Concatenate (ZCS_BOM_EXPL_MAT_V2)
    LOAD * RESIDENT [$(vTable)];
    DROP TABLE [$(vTable)];
    NEXT i;

    DROP TABLE TableList;

     

    arzuatasever_0-1628062610591.png

     

    Show Less
  • forum

    Qlik Application Automation

    How to use Zendesk with Qlik Application Automation

    This article gives an overview of the available blocks in the Zendesk connector in Qlik Application Automation. It will also go over some basic exampl... Show More

    This article gives an overview of the available blocks in the Zendesk connector in Qlik Application Automation. It will also go over some basic examples of retrieving tickets and creating a ticket within a Zendesk account.

    This connector supports CRUD operations(read, create, update, delete) for the following modules in Zendesk:

    • tickets
    • contacts
    • organizations

    There are also a few blocks for managing file uploads and linking those to a ticket comment.

    Authentication for this connector is based on the oAuth2 Protocol. For more details check this article.

    Let's now go over a few basic examples of how to use the Zendesk connector:

    1. How to list tickets from a Zendesk account:

    1. Create an automation;
    2. From the left menu, select the Zendesk connector;
      Ionut_Dumitrascu_1-1628075368019.png
    3. Use the 'Search for blocks' input to search for the "list tickets' block;
      Ionut_Dumitrascu_2-1628075413276.png
    4. Drag and drop the block into the automation and link it to the start block;
      Ionut_Dumitrascu_3-1628075464491.png
    5. From the left menu, search for the 'Output' block;
      Ionut_Dumitrascu_5-1628075740480.png
    6. Drag and drop the 'output' block into the automation and link it to the 'List tickets' block;
      Ionut_Dumitrascu_4-1628075507551.png
    7. Run the automation (if not saved previously, a 'Save automation' popup will appear). This will output a paginated list of tickets available.

    2. How to create a ticket in your Zendesk account:

    1. The first two steps are similar as before;
    2. Use the 'Search for blocks' input to search for the "Create ticket' block;
    3. Drag and drop the block into the automation and link it to the start block;
      Ionut_Dumitrascu_7-1628076091601.png
    4. On the right side of the screen, use the input fields to fill in the ticket information;
      Ionut_Dumitrascu_8-1628076177440.png
    5. Run the automation (if not saved previously, a 'Save automation' popup will appear). This will create a new ticket in your Zendesk account and output this information.

    3. For other more complex use-cases (example: Understanding how the incremental blocks work, how to upload a file and link it to a ticket) check out these articles:

    Show Less
  • forum

    App Development

    Sum of total number of family per account and see all the families

    Hello everyone, Since 2 days I try to figure out my problem but i can not :(! I have this data :Date- Account -  family - amount01/01/2021 - 001 - 1 -... Show More

    Hello everyone,

     

    Since 2 days I try to figure out my problem but i can not :(!

     

    I have this data :

    Date- Account -  family - amount

    01/01/2021 - 001 - 1 - 100

    01/01/2021 - 001 - 2 - 200

    01/01/2021 - 001 - 3 - 200

    01/02/2021 - 002 - 4 - 500

    01/02/2021 - 002 - 5- 500

     

    I want this result : 

     Account - Family - Number of family - Total amount of the family

     001 - 1-  3 -  500

     001 - 2-  3 -  500

     001 - 3-  3 -  500

     002 - 4-  2 -  1000

     002 - 5-  2 -  1000

    I try with sum(aggr(   COUNT(  distinct family ),account)) but with no success.

    If someone can help me , thank you so much.

    I put account and family with dimension.

    Show Less
  • forum

    New to Qlik Sense

    set expression to filter on dimension only table

    I have data set  as below.WorkstreamReporting DateNameDescriptionCompletion DateW130/07/2021AL20/05/2021W130/07/2021BM24/05/2021W130/07/2021CP20/05/20... Show More

    I have data set  as below.

    WorkstreamReporting DateNameDescriptionCompletion Date
    W130/07/2021AL20/05/2021
    W130/07/2021BM24/05/2021
    W130/07/2021CP20/05/2021
    W123/07/2021AL20/05/2021
    W123/07/2021BM19/05/2021
    W116/07/2021AL20/05/2021
    W116/07/2021BM19/05/2021
    W230/07/2021DQ11/05/2021
    W230/07/2021ER24/05/2021
    W230/07/2021FS11/05/2021
    W223/07/2021DQ11/05/2021
    W223/07/2021ER19/05/2021
    W216/07/2021DQ20/05/2021
    W216/07/2021ER19/05/2021

    I want to display this data in a straight table with fields  Name, Description and Completion Date only with below conditions.

    When no filter is selected on the filter pane, I want the table to display only records where workstream = W1 and Reporting Date = latest Date. When a filter is selected on the table all records of that Workstream and Reporting Date must be displayed. Could you please let me know how I can achieve this using set expressions. I am confused on how to apply set expression on a dimension only table.

    The output should look like below when no filters are selected on filter pane. Thanks

    NameDescriptionCompletion Date
    AL20/05/2021
    BM24/05/2021
    CP20/05/2021
    Show Less
  • forum

    App Development

    Fields in use QlikSense App

    hi allin my app I have ~100 fields , I am not sure all of them are in use.is there a way to indicate which fields are in use within an app objects ? a... Show More

    hi all

    in my app I have ~100 fields , I am not sure all of them are in use.

    is there a way to indicate which fields are in use within an app objects ?

     

    advanced thanks

    Show Less
  • forum

    Deployment & Management

    identity provider in SaaS Enterprise Version

    Hi,I'd like to add a google SSO using Auth0 to my SaaS  tenant portal: Qlik Sense SaaS Enterprise Version (NFR).If I select the "Identity Provider" me... Show More

    Hi,
    I'd like to add a google SSO using Auth0 to my SaaS  tenant portal: Qlik Sense SaaS Enterprise Version (NFR).

    If I select the "Identity Provider" menu option I can only see the alert:

    You are currently using Qlik for authentication

    Your tenant is currently configured to use Qlik for authentication for all members.
    To enable single sign-on (SSO), please submit a case at support.qlik.com.

    No "Add new" button, no voices in options.

    Some help?

    Thank you.

    Show Less
  • forum

    Qlik NPrinting Discussions

    NPrinting with ODAG

    We are using ODAG to mask data for few fields in our Qlik Sense dashboard. Data for those fields are encrypted based on users' entitlements.I need to ... Show More

    We are using ODAG to mask data for few fields in our Qlik Sense dashboard. Data for those fields are encrypted based on users' entitlements.

    I need to do a report in NPrinting using one of the tables with masked data.   Do I need to create a separate application for each user in this case? 

    Please suggest any possible solutions .  Appreciate all your help.

    Thanks.

     

    Show Less
  • forum

    New to Qlik Sense

    Group By in Chart

    Hello Qlik Enthusiasts,I am trying to count values based on the dimension in Chart level using a variable. Trying to group 'Value' by COL .Count({$<Va... Show More

    Hello Qlik Enthusiasts,

    I am trying to count values based on the dimension in Chart level using a variable. 

    Trying to group 'Value' by COL .

    Count({$<Value> COL})

    i am getting count 1 for every value in COL . 

    i want to get all the values assigned to that particular Value of COL .

    Please help me solve this,

    I hope you have a great day,

    Thank you.

     

     

     

     

    Show Less
  • forum

    New to Qlik Sense

    Qlik Sense charts over one another

    hi,i have a combo chart, whereby the measure height of bar is dependent on a field selection, as there is no longer a feature on Qlik Sense to use a c... Show More

    hi,

    i have a combo chart, whereby the measure height of bar is dependent on a field selection, as there is no longer a feature on Qlik Sense to use a conditional show on a expression, i was going to create 5 separate charts overlapping one another and put a conditional show on the chart itself. however, it doesn't look like you can put one chart over another on the qlik sense grid.

    e.g the expression is  ""sum({<Order= {'T/'}>}FINISH_QTY)"" whereby the "order" is the field selection one one chart, the other charts would just have a different order = to.  

    does anyone know of a way to do this? i can obviously have the 5 charts on their own sheet but ideally i want it all in one grid whereby one chart will update based on the field selected.

     

    thanks

    Show Less
  • forum

    App Development

    Function on table

    Hi, I have this table in Qlik Sense:I would like to have in the table only the Debtors who have all the associated Operations, with Code = 6so in this... Show More

    Hi, I have this table in Qlik Sense:

    Aika_0-1628069495738.jpeg

    I would like to have in the table only the Debtors who have all the associated Operations, with Code = 6
    so in this case SERVIDIO TERESA, because it has its Operations all with Code = 6, while DI BELLA FRANCESCO no because it has some with Code = 0.
    How can it be done?
    Using perhaps the function:
    Only ([{SetExpression}] [TOTAL [<fld {, fld}>]] expr)
    but how exactly?

    Thank you...

    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