Qlik Community

Ask a Question
Welcome to Qlik Community
cancel
Showing results for 
Search instead for 
Did you mean: 
2,969 online
Announcements
May 18th 9AM, Changes to your login: use email vs. username. Logins 9-10AM ET could be impacted. READ DETAILS/WATCH VIDEO

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

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.

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.

Qlik Resources

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

Events

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

Blogs

Hear directly from Qlik employees in our ten unique blogs.

About

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

Community Sitemap

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

Recent Discussions

  • No Boards Found
  • forum

    QlikView App Dev

    DAily Application - freeze data per week and per month

    Hello, I have actually a daily application, every day data change,  i want to freeze data per week and per month. My solution is to create one applica... Show More

    Hello, 

    I have actually a daily application, every day data change,  i want to freeze data per week and per month. 

    My solution is to create one application for week (execution once a week) and one for month (execution once a month) ,  but for maintenance it's not great. 

    Is there a solution by keeping a single application ? 

    Best regards

    Thank you 

    Show Less
  • forum

    New to Qlik Sense

    Count if based on set analysis

    Dear CommunityI have a question with regards to a count if:I need to count unique customer ID based on a set analysis: Rangesum(Above(sum({<Time_Group... Show More

    Dear Community

    I have a question with regards to a count if:

    I need to count unique customer ID based on a set analysis: 

    Rangesum(Above(sum({<Time_Groups_Total={'Month Folder'},Sub_Category={'Drinks'}>}if(Year2Date(Trans_Month,0,if(MONTH(vMaxMonth)>11,1,MONTH(vMaxMonth)+1),vMaxMonth),$(vMeasure))/
    sum(total{<Time_Groups_Total={'Month Folder'},Sub_Category={'Drinks'}>}if(Year2Date(Trans_Month,0,if(MONTH(vMaxMonth)>11,1,MONTH(vMaxMonth)+1),vMaxMonth),$(vMeasure)))), 0, rowno()))

    The above should be counting customers ID where the set analysis is smaller than 80%

    I have placed this set analysis in a Variable .

    Please advise

    Show Less
  • forum

    New to Qlik Sense

    Best solution intervalmatch. peek or other

    Hi, I have doubts about how is the most effective way to solve this problem; the "USUARIOS" table contains "incomplete" dates, USUARIOS and TIPO, with... Show More

    Hi, I have doubts about how is the most effective way to solve this problem; 

    the "USUARIOS" table contains "incomplete" dates, USUARIOS and TIPO, with respect to the "VTAS" table; I want to obtain the table "RESULTADOS", which would be the most efficient option, the calendar would be from today 13 months ago

    tabla_usuario.jpgtabla_vtas.jpg

    tabla_resultado.jpg

    Thanks for the help

    Show Less
  • forum

    App Development

    Categorizing data in script

    Dear all,my aim is to load a table with problem issues and add a column to categorize each row/data with the help of certain criterias if it's relevan... Show More

    Dear all,

    my aim is to load a table with problem issues and add a column to categorize each row/data with the help of certain criterias if it's relevant or not.

    To make it easier to understand, here is an example of given data:

    table_Data:

    problem_nr;

    problem_description;

    problem_short;

    table_Criterias:

    problem_description;

    problem_short;

    relevance;

    table_Final:

    problem_nr;

    ...

    relevance;

    The problem is, that the colums problem_short / problem_description are not 100 % identical. The table criteras includes only key words, where the table_data includes more complex descriptions. So, there is no applyMap possible. Any idea, how to solve it the easiest way?

    Thanks and kind regards!

     

    Show Less
  • forum

    Qlik Catalog

    About Qlik Catalog?

    Hello everyone,Qlik Catalog is a modern enterprise data management solution that simplifies and accelerates the curation, preparation, and delivery of... Show More

    Hello everyone,

    Qlik Catalog is a modern enterprise data management solution that simplifies and accelerates the curation, preparation, and delivery of trusted, actionable data to business users across the enterprise.

    Show Less
  • forum

    Integration, Extension & APIs

    compliment a new one QlikDeploymentFramework.exe

    hello guys, what's up, I need help with how I can compile a new “QlikDeploymentFramework.exe” because I made a change to the standard qvs “12.Index.qv... Show More
    hello guys, what's up,
    I need help with how I can compile a new “QlikDeploymentFramework.exe” because I made a change to the standard qvs “12.Index.qvs” and every time I create a container, “QlikDeploymentFramework.exe” undoes my changes in all existing containers.
    This also occurs in my “.gitignore” file because I do not enable the “Instals Qvc Lib” option and with that the “.gitignore” is also mortified for what is compiled inside my “QlikDeploymentFramework.exe” version 1.7.4, this mess my whole environment.
    So I would like to make changes to these two files and complicate a new “QlikDeploymentFramework.exe”, how is that possible?
    Thank you in advance.
    Show Less
  • forum

    App Development

    Count dimension if aggregate count passes condition

    Problem:I want to create a single KPI with the count of the dimension SDTL_REFERENZ_NR if the aggr() count of two dimensions (SSL_TEIL_ID_NO_ZZZZ, EBE... Show More

    Problem:

    I want to create a single KPI with the count of the dimension SDTL_REFERENZ_NR if the aggr() count of two dimensions (SSL_TEIL_ID_NO_ZZZZ, EBEF_SSL_ID) is greater than 3.

    What I have:

     

    count(
    	if(
          	aggr(count({<
                        FALL_REFERENZNUMMER = {""},
    		     >} distinct SDTL_REFERENZ_NR), SSL_TEIL_ID_NO_ZZZZ, EBEF_SSL_ID) >= 3,
            SDTL_REFERENZ_NR))

     

     

    The problem is, this funtion gives me the count of aggr() groups which meet the if condition. But I want to count the number of the dimension SDTL_REFERENZ_NR which are in the aggregated group.

    Example:

    If I put the dimensions SSL_TEIL_ID_NO_ZZZZ and EBEF_SSL_ID in a table and add a count on SDTL_REFERENZ_NR it gives me the values I want to count in the table. This should give me "8" as the result of my KPI. My current KPI gives me "2" because there are 2 aggregated rows.

    daviddiener_0-1621341481729.png

     

     

    Show Less
  • forum

    App Development

    Variable Input - Drop Down Values

    Hello,i am trying to use the input variable in qlik sense, and want to set the different values in a drop down menu.but it is only working for 2 value... Show More

    Hello,

    i am trying to use the input variable in qlik sense, and want to set the different values in a drop down menu.

    but it is only working for 2 values, when i add the 3rd value it only works for the first 2.

    any suggestions?

    Show Less
  • forum

    Deployment Framework

    connections between containers

    Hello we all know that we can use the function LCGV to connect to a container and generate variables for the path of the desired folder...now we've be... Show More

    Hello we all know that we can use the function LCGV to connect to a container and generate variables for the path of the desired folder...
    now we've been using QDF at my company for almost 2 years and the thing is that we cannot know which container connects to which container
    is there a way to visualize or to generate kind of dependency list between containers?

    things are becoming cumbersome and like spider web if I can say
    kindly advise
    @Michael_Tarallo 
    @Magnus_Berg 
    @Damian_Waldron 

    Show Less
  • forum

    QlikView App Dev

    Adding unique measues to every column at the beginning

    Hi all,Can I add a single measure for different columns at the beginning of the column.It should be unique for all the columns. for eg:In case of Sale... Show More

    Hi all,

    Can I add a single measure for different columns at the beginning of the column.It should be unique for all the columns.

     

    for eg:

    In case of Sales column,I want to add Revenue Sales GP%(which is a single value) at the top along with label of Revenue Sales GP%.It should be placed between Jan 2021 value and the column name(where the arrow is)

    For Jobs column,I want to add Revenue Jobs GP% at the top which is again a single value and so on.

    Ameya_0-1621340129355.png

     

    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 QlikView.

May 18, 2021 10AM EST

Events

Qlik Insider - Webinar Series

This webinar will cover key new capabilities that drive Active Intelligence in your organization, helping your users go beyond the dashboard, to collaborate and take action at the point of decision.

May 26, 2021