Qlik Community

Ask a Question
Welcome to Qlik Community
cancel
Showing results for 
Search instead for 
Did you mean: 
2,424 online
Announcements

Data Analytics Forums

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

Data Integration Forums

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.

Product Insight & Ideas

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 Qlik Community

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

    Qlik Sense App Development

    Qliksense

    Qliksense mashup vs Qliksense Extension? When we need to use extension and when we need to use mashup?
  • forum

    Qlik NPrinting Discussions

    Trying to export all rows in a long table visualization to PDF - without scroll...

    Hi I am trying to print a table that is much longer than the screen - but when I export to PDF, I can only see a screen shot.  Plus I also see the Box... Show More

    Hi I am trying to print a table that is much longer than the screen - but when I export to PDF, I can only see a screen shot.  Plus I also see the Boxes at the top that I do not want on the report.  

    Is there a way to:

    1.) download to a PDF,  all of the data in a table visualization
    2.) download every sheet in a dashboard with a single export to PDF
    3.) create a dynamic query that is based on parameters/variables easily obtained from user

     

    bmacinnis_0-1614273071425.png

     

    Show Less
  • forum

    QlikView App Dev

    COUNT WITH DIFFERENT DIMENSIONS

    Hi everyone,my goal is to count in the same pivot table   events per two different months,  however i need just to show one, i'have attached my data m... Show More

    Hi everyone,

    my goal is to count in the same pivot table   events per two different months,  however i need just to show one, i'have attached my data model and the output which i want to get, the first table EVENEMENTS  contains the categories, scores (SCR1,SCR2..) and creation month,  the second table EV_Scannes contains months of scan, i need to show the colored column Part en % which is equal to  (number per month creation /number per month of scan).

    can any one help please?

    Show Less
  • forum

    Qlik Replicate Discussions

    How do I see the columns involved in replication?

    We are having a lot of situations where teams are checking for new columns that have been added by the vendor.I have to go to the source and insure th... Show More

    We are having a lot of situations where teams are checking for new columns that have been added by the vendor.

    I have to go to the source and insure the columns are there.  Then I go to the replicate and reload a table.  I would like to check if the column is part of the replication first.

    I know how to add tables to the replication.  Is there a way to see the columns involved in the replication?

    Thanks.

     

     

     

    Show Less
  • forum

    New to Qlik Sense

    Alternate State on GetSelectedCount

    Hi Community,I have one scenario for states.I have two set of filters STATE1 and STATE2.1. Category is Global filter - if I select State1 category, sh... Show More

    Hi Community,

    I have one scenario for states.

    I have two set of filters STATE1 and STATE2.

    1. Category is Global filter - if I select State1 category, should be populate same value on State2. (Global filter should be same for State1 and State2)

    2. below screen I have two textboxes with different calculation Sales and QTY.

    It should be single textbox, If I select product Sales should be populate and If I select SubProd should be switch QTY on same text box.

    Getselectedcount is not working for states...

    I did try with =IF(GetSelectedCount(Product, False(), 'State1'), Sum(Sales), Sum(Sales)/Sum(Qty))

    for reference have attached sample QVW file.

    qv_testing_0-1614256803567.png

    Hope it help!

    Thanks in Advance!

    Show Less
  • forum

    QlikView App Dev

    Parameterised Variable but in an Expression table

    Hi AllI'm trying to use the amazing functionality of a parametrised varaible e.g. var=sum($1+$2) so var(a,b)=sum(a+b) but I'm trying to go one stage f... Show More

    Hi All

    I'm trying to use the amazing functionality of a parametrised varaible e.g. var=sum($1+$2) so var(a,b)=sum(a+b) but I'm trying to go one stage further and use this functionaity in expressions from a table, so I can store multiple expressions based on dimension choice but on a parameterised basis as what you can do in variables.

    If it helps, I've included a simple app with a step by step attempt.

    So I've got a data table with two rows of data with the value fields (a, b and c)

    I currently have two calculation functions (but I want many in reality, hence why want to store in table rather than individual variables). So I've created two parameterised variables:

    vAddFunc=sum($1+$2)

    vMultiFunc= sum($1*$2)

    In example 1, I can call each function in the table expression and use any of the data columns (so I'm using a and b in my example).

    Switching %Field from Add to Multiply chooses each function. However each is it's own variable and requires either conditional expressions in table to pick correct variable or I would need an if statement. So this is not scalable in what I'm looking to do e.g. add many other functions using same parameters e.g. Divide, Double, Subtract etc

    So, I look to another neat solution which is to store the expressions in a table that the expression can be recalled by reading that table. So example 2 in the middle shows this 'without' the parametrised variables i.e. fixed expressions for a and b. Here, as you select %Field it determines which expression to use.

    So to my final example, I am now trying to merge the two i.e. recall and expression from a table but utilise the parameter functionality of a variable. So I've tried mashing both together (using a variable to recall the table expression which has $ parameters) but I can get it to work 😞 .

    Is this just not possible or have a missed out something in my expression definition?

    My thanks in advance for any genius suggestions

    Derek

     

     

     

     

     

     

    Show Less
  • forum

    Qlik Sense SaaS & Multi-Cloud

    cannot access tenant <test post>

    this is a test community postcannot access tenant
  • forum

    Qlik NPrinting Discussions

    NPrinting Apr 2020 - Default app.conf files

    Hello Folks,I've got an NPrinting Apr 2020 system and I've made some changes to the  %ProgramData%\NPrinting\newsstandproxy\app.conf and I would like ... Show More

    Hello Folks,

    I've got an NPrinting Apr 2020 system and I've made some changes to the  %ProgramData%\NPrinting\newsstandproxy\app.conf and I would like to compare those changes to a stock app.conf file. However, I can't seem to find one on my system.

     

    Does a stock app.conf file live anywhere online or on my server with a different name?

    Any help is greatly appreciated.

    Show Less
  • forum

    Qlik Sense App Development

    Conditional show and colour in qliksense pivot table

    Hello Experts,I have one requirement where i want to color the Date field based on Component_Status field for each component when Date is equal to tod... Show More

    Hello Experts,

    I have one requirement where i want to color the Date field based on Component_Status field for each component when Date is equal to today's date. Since todays date is 25 Feb so it should color the rows of  2/25/2021  for each component based on Component_Status field.

    Also it should show when each Component is reaching Component_ECD(by marking the cell with 1).

    Sample data

    ProductComponentDateComponent_StatusComponent_ECD
    AX2/23/2021Green2/26/2021
    AX2/24/2021Green2/26/2021
    AX2/25/2021Green2/26/2021
    AX2/26/2021Green2/26/2021
    AY2/23/2021Red2/23/2021
    AY2/24/2021Red2/23/2021
    AY2/25/2021Red2/23/2021
    AY2/26/2021Red2/23/2021
    AZ2/23/2021Yellow2/26/2021
    AZ2/24/2021Yellow2/26/2021
    AZ2/25/2021Yellow2/26/2021
    AZ2/26/2021Yellow2/26/2021


    Expected Output:

    Output.JPG

    Thanks in Advance.

    Show Less
  • forum

    New to Qlik Sense

    cannot access tenant <test post>

    this is a test community postcannot access tenant

Get Started On Community

Start Here Get Started On Community

Top Participants

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.

Blogs

Blogs

Hear directly from Qlik employees and stay current on the latest and greatest information about Qlik products.

Groups

Covid 19

We are bringing together people and resources in response to the pandemic of Coronavirus, aka COVID-19, aka SARS-CoV-2.

open to all

Groups

QlikView to Qlik Sense

Join the QlikView to Qlik Sense group and help you modernize your BI experience through adoption of Qlik Sense.

open to all

Groups

Qlik Healthcare

This group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights.

750+ Members

Events

Events & Meetups

Virtual Meetups are now a possibility! With the impact of COVID-19, the Qlik Meetup network has expanded its support to include the ability to host your next Meetup online. Email QlikMeetups@qlik.com to get your virtual Meetup started!’

Events

Direct Relief Uses Qlik to Manage Its COVID-19 Supply Chain

Qlik can help you manage your supply chain risks during COVID‑19.The nonprofit organization, Direct Relief, uses Qlik’s Supply Chain solution to scale its delivery of medical supplies worldwide.

Available on Demand