Qlik Community

Ask a Question
Welcome to Qlik Community
cancel
Showing results for 
Search instead for 
Did you mean: 
2,485 online
Announcements
Join us March 10th, 7 Ways Modern Analytics Can Help You Take Smarter Action. REGISTER NOW

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

    Qlik Sense App Development

    Dynamic change expression measure

    Table 1:Table 2:Here my existing formula to calculate the total value based on table 1,//company A,B,D >12MTHSSum({Table 2.Company-={'C'}[> 24 MTHS]+[... Show More

    Table 1:

    kwl1234_0-1614927718998.png

    Table 2:

    kwl1234_1-1614927888083.png

    Here my existing formula to calculate the total value based on table 1,

    //company A,B,D >12MTHS

    Sum({Table 2.Company-={'C'}
    [> 24 MTHS]+[13-24 MTHS])

    //company C >24MTHS
    +Sum({<Table 2.Company={'C'},Table 2.Company -={'A', 'B', 'D'}>}
    [> 24 MTHS])

     

    Since table 1 may change, I want to change the measure dynamically, e.g if table 1 A aged ='>24MTHS', Change the formula measure to sum( [> 24 MTHS]).

    Should I join table 1 and table 2 and then using if case to determine total MTHS value?

    Is it a better way to calculate the total MTHS value based on table 1 column B?

    Please help😥

     

    Show Less
  • forum

    QlikView App Dev

    Last 3/6/12 months from NOW

    Hi!I searched for a solution but was not able to solve my problem.I have a qlikview Report with revenues and i want to se the revenue for example: pro... Show More

    Hi!

    I searched for a solution but was not able to solve my problem.

    I have a qlikview Report with revenues and i want to se the revenue for example: products , last 6 months revenue

    Now i have this in a Formula for the summary of revenues:

    sum({<[ArtikelTyp_name]={'Engine'},Date={'>$(=AddMonths(Max(Date),-12))'}>}[Rechnungsmenge])

    also tryied

    sum({<[ArtikelTyp_name]={'Light-Engine'},Date={'>$(=AddMonths(Today(),-5))'}>}[Rechnungsmenge])

    If i change the Year from example 2021 and 2020 the result also changes but i want see the last 12 months from today regardless of selected year.

    I tryied different things date(today) etc. but it wont work. I think "Date" is the problem?

    Has anybody ideas whats wrong or whats the correct formular?

    Thank you very much.

    Show Less
  • forum

    Community Corner

    Qlikview creation/modification of any Object fails

    Hello,I use Qlikview for long Time now, but now I experience a strang Issue:when I create a new Object (e.g. Pivottable), I can choose the dimensions ... Show More

    Hello,

    I use Qlikview for long Time now, but now I experience a strang Issue:

    when I create a new Object (e.g. Pivottable), I can choose the dimensions and add them, but after that step in the formula window I can't make any entries. No Input is possible. all buttons etc. are not usable, also the "next" or "back" buttom are not clickable. I can not proceed entering a formular to make analysis. It is only possible to exit this dialog using the esc button on the keybord.

    also already existing diagrams or tables can no more be edited. same Problem.

    did anyone experience the same issue? or has any advice fr me to solve it?

    thanks.

    Formula Window.JPG

    Show Less
  • forum

    Qlik Connectors Discussions

    Filtering SugarCRM Records

    How does one specify selection criteria when using the Beta Web Connector for SugarCRM in Qlik Sense Cloud?  Is there an additional parameter that mus... Show More

    How does one specify selection criteria when using the Beta Web Connector for SugarCRM in Qlik Sense Cloud?  Is there an additional parameter that must be added to the SELECT statement PROPERTIES?

    SELECT

         id,

         name,

         date_entered,

         date_modified


    FROM CustomModule

    WITH PROPERTIES (

         moduleName='MyCustomModule'

         ,max_num='10000'

         ,order_by='date_modified:DESC'

    );

    Show Less
  • forum

    Qlik Sense Integration, Extensions, & APIs

    Embedded Qlik sheets via iframe gives error intermittently

    Hi all,When viewing embedded Qlik sheets on an internal web site, users are reporting that they receive intermittently "400 - Bad Request" errors or r... Show More

    Hi all,

    When viewing embedded Qlik sheets on an internal web site, users are reporting that they receive intermittently "400 - Bad Request" errors or receive an error that the Qlik Sense engine wasn't found".

    We found the below article and changed the proxy config accordingly ( https://support.qlik.com/articles/000098524).
    Since we are running Qlik Sense for Windows June 2020 version, we thought this bug should not appear.
    Anyway, changing the proxy config, did not help getting this resolved.

    Do you have some hints, where to look at to resolve this problem?

    Thanks,
    Udo

    js console errorjs console error

    Error message in browserError message in browser

    Show Less
  • forum

    Qlik NPrinting Discussions

    External NPrinting Repository

    Hello,Just wondering if anyone had successfully placed their NPrinting repository on a dedicated RDS server.It seems like it would be easy enough to t... Show More

    Hello,

    Just wondering if anyone had successfully placed their NPrinting repository on a dedicated RDS server.

    It seems like it would be easy enough to take what we have in the local NP repository and place it into another dedicated PostgreSQL database via PGAdmin Tool. However I am curious in terms of how to get the NPrintingRepo Service to know to connect to the external repository server.

    There are other threads on altering pg_hba.conf or PostgreSQL.conf files (https://community.qlik.com/t5/Qlik-NPrinting-Discussions/How-to-connect-to-postgresql-database-from-another-server/td-p/1690365) but I believe these are based on local installations.

    Please let me know if anyone has any experience on how to accomplish this.

    Show Less
  • forum

    Qlik NPrinting Discussions

    Ignoring Task filter for a report

    Hi Experts,I have 5 reports.4-Excel and 1- Email embedded.I need to send first set- Straightforward without any task level filters -AchievedSecond Set... Show More

    Hi Experts,

    I have 5 reports.

    4-Excel and 1- Email embedded.

    I need to send 

    first set- Straightforward without any task level filters -Achieved

    Second Set - 

    4 Excel reports with a filter.(Column product having 6 values)

    1 Email imbedded without any filter.(For all Products)

    So i need to generate 4-excel+1 email embed(without any filter) for 6 product values.

    Possible Solution is :

    Create number of reports for each product value-in this case 4*6=24 reports which is not efficient i guess.

    Can you please suggest me is there any other way to achieve without having to create so many reports

    or is there anyway to exclude task filter for a report?

     

     

     

    Show Less
  • forum

    Qlik Sense App Development

    Mulitple conditions for if clause

    Hello,I have a Bar chart where I want to show the dimensions only if it has two conditions (field MakeBuy should be 'make' and the calculated value sh... Show More

    Hello,

    I have a Bar chart where I want to show the dimensions only if it has two conditions (field MakeBuy should be 'make' and the calculated value should be ave 0.2

    =if((MakeBuy='make'and Sum({<Source={'AccountStructureSOW'}>} Value)/
    Sum({<Unit={'Costs'}>}Value)>'0.2'),SubCompetency)

    the formular is shown as OK but the dimension is not guilty. what did i wrong?

    Best regards

     

    Pia

    Show Less
  • forum

    Ideation Discussions

    Manipulation de données (les dates)

    Bonjour, Je fais des manipulations sur des dates, j'ai besoin de faire la différence entre deux dates en fonction d'un autre champ. J'aimerai bien sav... Show More

    Bonjour, 

    Je fais des manipulations sur des dates, j'ai besoin de faire la différence entre deux dates en fonction d'un autre champ.
     

    Absence.PNG


    J'aimerai bien savoir, s'il y a une possibilité de faire la différence entre ( La date de fin [11/07/2020]  ) et ( la date de début [04/09/2020] ). Parce qu'en vrai, j'ai besoin de savoir est ce que la personne en question a repris le travail entre temps ou pas. Surtout, pour voir si elle a prolongé son arrêt ou elle a repris et ensuite elle a déposé un autre arrêt maladie.

    En grosso-modo, je veux dire: Si[la date de fin (N-1)- [la date de début (N)] ) > 1 donc le résultat sera de 1 sinon c'est 0 cela en fonction du nom de la personne .

    Je vous remercie d'avance. 

    QlikView 

    Show Less
  • forum

    Qlik Sense Integration, Extensions, & APIs

    Web Connectors Qlik azure storage connection

    When I try to create a connection to Azure Blob I have an error.I select CanAutentificate.After it, I got an authentification token and click Save Inp... Show More

    When I try to create a connection to Azure Blob I have an error.

    I select CanAutentificate.

    After it, I got an authentification token and click Save Inputs & Run Table

    in results I have an error

    HttpStatusCode: Forbidden, 
    StatusCode: 403, 
    StatusDescription: Server failed to authenticate the request. Make sure the value of the Authorization header is formed correctly including the signature., 
    Message: The remote server returned an error: (403) Forbidden.
     
    Do you 
    Show Less

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