Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
7,936 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

    App Development

    Loan Amortization Schedule

    Hi all! I have recently started working on Qlikview so have less knowledge about it. The task I am trying to achieve is calculate the Loan Amortizatio... Show More

    Hi all!

    I have recently started working on Qlikview so have less knowledge about it. The task I am trying to achieve is calculate the Loan Amortization Schedule using the while loop but could able to do that.

    I have following input table(qvd) 

    GhazanfarAli_0-1642781485807.png

     

    I want Loan Amortization Schedule to be calculate in qvs using the Qvd I have up pasted meaning I want separate table for the Payment plan based on this inputs.

     

    the desired result show be like that, this picture is random loan calculation 

    GhazanfarAli_4-1642782137528.png

     

    will greatfull if somebody can help. 

     

     

     

     

     

     

     

     

     

    Show Less
  • forum

    App Development

    Cumulative Count with null values

    Hello everyone,  I want a line chart with a cumulative count in my Qlik Sense App. So, what I have done is this expression :  Aggr(RangeSum(Above(COUN... Show More

    Hello everyone, 

    I want a line chart with a cumulative count in my Qlik Sense App. So, what I have done is this expression : 

    Aggr(
    RangeSum(
    Above(COUNT ( VEHICULE_NUMBER ), 0, RowNo())
    )
    ,[Date]
    )

    In the dimension, I have a date. 

    Although, for some date, I don't have VEHICULE_NUMBER so, the line chart is not continous, it has blanks.

    What I want here, is that instead of the null value, to pick up the last value of my count which was not null. For exemple in my line chart I have : 

    date what I have what I want
    2014 14 14
    2015 18 18

    2016

    - 18

    2017

    - 18

    2018

    20 20

    2019

    21 21

     

    I tried to simplify my count here for you to understand the problem, but the set analysis is huge and contains many conditions. 

    Do you have any suggestions ? 

    I tried to take the value "above" but in my example, it fulled only the line 2016 and not the 2017. I need it to take the last not null count. 

    Thanks !

    Show Less
  • forum

    Qlik Replicate

    MSSQL Source: Remote Distribution Database

    Configuring a MSSQL source connection for Qlik Replicate. The instruction specify, In the Distributor step, select <Microsoft SQL Server Name> will ac... Show More

    Configuring a MSSQL source connection for Qlik Replicate. The instruction specify,

    In the Distributor step, select <Microsoft SQL Server Name> will act as its own distributor; Microsoft SQL Server will create a distribution database and log.

    First assumption is that if the databases is already using MSSQL Replication and a distribution DB this can be skipped.

    Will Replicate properly if this distribution database is a remote server and NOT local to the datasource?

    Show Less
  • forum

    QlikView Connectivity

    While connecting to PostgreSQL source endpoint receiving error

    I am facing issue when connecting to postgreSQL endpoint   Task cannot be started because source endpoint 'ep_postgre_src_mss' of type 'PostgreSQL' ha... Show More

    I am facing issue when connecting to postgreSQL endpoint

     

    Task cannot be started because source endpoint 'ep_postgre_src_mss' of type 'PostgreSQL' has no license.

    Show Less
  • forum

    New to Qlik Sense

    How to give Header for the measure in Pivot Table or in Normal Table

    Hello Team, I want to create a table like below which is having some dimension and some measure but that measure are having two different  headers, I ... Show More

    Hello Team,

    I want to create a table like below which is having some dimension and some measure but that measure are having two different  headers, I am not getting how can i achieve this, can someone please guide me here.

    Table.png

    I tried something like below, created one inline table and added the two columns in pivot table column

    Header:
    Load * Inline
    [

    Header 1 , Header 2

    Header 1 , Sub Header 1

    Header 1 , Sub Header 2

    Header 1 , Sub Header 3

    Header 12, Sub Header 1

    .

    .

    Header 2 , Sub Header 5

    ];

    aslamshaikh_0-1642780496328.png 

    But this is not working as shown in the image above, please help me to resolve this issue.

     

    Thanks and Regards

    Aslam Shaikh

    Show Less
  • forum

    New to Qlik Sense

    Count Unique Match and Exclude in the same set analysis

    Hi all, I am needing to count distinct account_num but from three different tables but I also need to exclude the count if they appear in another tabl... Show More

    Hi all,

    I am needing to count distinct account_num but from three different tables but I also need to exclude the count if they appear in another table. I have been using P() for those that match up, but I am having issues on count distinct excluding those in common.

    For example: table1 = new customer, table2 = existing customer, table3 = lost customers. 

    count({<Table3_account_num=P(table1_account_num), table3_account_num=-P(table2_account_num)>}distinct table3_account_num)

    I put a '-' before the P because E() was returning zero and thought at a strech this might work, which it doesn't. 

    I should mention all my tables are separate, they are linked by any key. 

    essential I want to say, count distinct all account_nums that are in table 3 that are also in table1, but if an account_num is in table 2 then ignore it from the count. 

     

    Any help would be great,

    Show Less
  • forum

    App Development

    Counting customers who bought bundles

    Hi! I come to you with a request to suggest an idea for solving the problem. I have a sales table as in the attachment. It has more data, of course, b... Show More

    Hi!

    I come to you with a request to suggest an idea for solving the problem.

    I have a sales table as in the attachment. It has more data, of course, but this is what it looks like.

     

    How (at the load editor level) to mark customers who have bought on ONE INVOICE:

    - a selected set of products (e.g. 'HZJFNNZH' and 'QHUXWGTW'),

    - minimum x pieces (where x is also fixed), eg. 'HZJFNNZH'> = 5 and 'QHUXWGTW'> = 10.

     

    Of course, there may also be other products on the invoice.

     

    Thanks for any suggestions!

     

    Show Less
  • forum

    New to Qlik Sense

    Avg and sum in "Show Totals"

    Hello! I'm having trouble with this table: I used the following formula so in the first column, the numbers underlined in red calculate the average o... Show More

    Hello!

    I'm having trouble with this table:

    rociomendez_3-1642704672486.png

    I used the following formula so in the first column, the numbers underlined in red calculate the average of the numbers to their right instead of showing the sum, and the totals of every column show the sum of their numbers below:

    if(Dimensionality()=0,
    sum((calificacionM/100)*porcentaje),
    avg(aggr(sum((calificacionM/100)*porcentaje), [MESAÑO_CON], nombreClasificaciones, num_porcentaje)))

    What I'm having trouble with is that I need the number highlighted in yellow to sum the numbers below, not the numbers to its right, so I can have 96.75 instead of 967.48.

     

    Any ideas? Is it possible? Thanks so much for your help!!

    Show Less
  • forum

    New to Qlik Sense

    Totaling issues

    I'm having an issue with this. I'm trying to get the MPG for both units, but it only shows the first unit's gallons for the total.   =Sum(LOADED_MILES... Show More

    I'm having an issue with this. I'm trying to get the MPG for both units, but it only shows the first unit's gallons for the total.

     

    =Sum(LOADED_MILES+DEADHEAD_MILES+TOLL_MILES)/If(Sum(TRACTOR_GALLONS)>0,Sum(TRACTOR_GALLONS),Sum([T.Fuel Gallons]))

    QlikSenseUser2_1-1642778369669.png

     

     

    Show Less
  • forum

    App Development

    Average of the previous 3 values in load script

    Hey guys, I have a table with Dates and Values that contains future dates with empty values. I need to fill these null values with an average of the l... Show More

    Hey guys,

    I have a table with Dates and Values that contains future dates with empty values. I need to fill these null values with an average of the last 3 values, ordered by date. Does anyone know how to do it?

    E.g.:
    Date, Value
    19/01/2022, 3
    20/01/2022, 6
    21/01/2022, 9
    22/01/2022, -
    23/01/2022, -
    24/01/2022, -

    ...

    Should be:
    Date, Value
    19/01/2022, 3
    20/01/2022, 6
    21/01/2022, 9
    22/01/2022, 6 (3+6+9)
    23/01/2022, 7 (6+9+6)
    24/01/2022, 7.333 (7+6+9)

    ...

     

    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