Qlik Community

Welcome to Qlik Community

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

Support

Chat with us, search Knowledge, open a Case, read the latest Updates Blog, find Release Notes, and learn about our Programs.

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.

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

    Qlik NPrinting Discussions

    send Email Report by Condition

    Hi, I need to send an NPrining report by Email only to certain users, using a condition. I made a condition and used it on tha task and also on the re... Show More

    Hi,

    I need to send an NPrining report by Email only to certain users, using a condition.

    I made a condition and used it on tha task and also on the report. 

    my problem is that users who are not suppose to get the report recieave an Email with an eror massage instead of not recieving it at all... 

    Hope that was clear inough,

    thankyou 

     

    Qlik NPrinting 

    Qlik NPrinting 

    Show Less
  • forum

    New to Qlik Sense

    Get the "or" to work in if statement or code

    Hi, I ID,GROUP,CODE 1,BMW,YES 1,BMW,YES 1,VW,YES 2,FORD,YES  2,BMW,YES 2,VW,YES 3,BMW,NO 3,VW, 4,FORD,YES  Why doesn't this work in expression or code... Show More

    Hi,

    I

    ID,GROUP,CODE

    1,BMW,YES

    1,BMW,YES

    1,VW,YES

    2,FORD,YES 

    2,BMW,YES

    2,VW,YES

    3,BMW,NO

    3,VW,

    4,FORD,YES 

    Why doesn't this work in expression or code 

    If( ID = 1 and Code = 'YES' and Group = BMW or group = VW ,1) 

     

    Thanks

     

     

     

     

    Show Less
  • forum

    New to Qlik Sense

    Rolling Sum with two years compared

    Hello All, I've searched a lot to solve my Problem. In Qlik I compare two years of Data, showing Offers as monthly values. I would like to show a roll... Show More

    Hello All,

    I've searched a lot to solve my Problem.

    In Qlik I compare two years of Data, showing Offers as monthly values.

    I would like to show a rolling sum of the last 12 month, base on the monthly row, so that (see attached image) the january value in the Column "Angebote rollierend" shows the sum of january and the last 11 month of the previous year ,....., November shows the last 11 Months of 2021 and Dezember auf 2020.

    Is there any way to achieve this beside building absolutely complex set analysis formulas? My data model does have the autocalendar-fields, e.g. "MonthsAgo".

    Thanks in Advance for your help!

    Daniel

    Show Less
  • forum

    New to Qlik Sense

    All available console commands of Qlik Sense Services exe files

    Hi! Some posts in the Qlik Sense documentations provide examples for running exe files with the prameters. But if i need get the all of parameters exe... Show More

    Hi!

    Some posts in the Qlik Sense documentations provide examples for running exe files with the prameters. But if i need get the all of parameters execute files what i must do? For example in some Windows programs i can run cmd.exe with parameter /? and i get the help.

    Where i can get list of all available params of exe files Qlik Sense server?

    Show Less
  • forum

    Deployment & Management

    Integrate Qlik Cli with Gitlab CI

    Hi Qlik Community,  #QlikCli I was wondering if anyone has integrated Qlik Cli with Gitlab CI.  I have integrated Qlik CLI with Gitlab CI and have met... Show More

    Hi Qlik Community,  #QlikCli

    I was wondering if anyone has integrated Qlik Cli with Gitlab CI. 

    I have integrated Qlik CLI with Gitlab CI and have met with several problems. One is that I am unable to import app using 

    qlik app import -f app.qvf

    The error seem to be that in gitlab ci, the content-length is not being updated. 

    They both runs on the same network with same file system rights. As you can see below, the difference between the request in Gitlab and local is the content-length.

    Result from GitLab Ci

    qlik app import -f ./testapp.qvf --verbose
    Server-type not set, guessing "cloud"
    POST https://hostname.qlikcloud.com/api/v1/temp-contents?filename=app_upload_%20%20%20%20%20%20999316

    Authorization: Bearer omitted
    Content-Type: application/octet-stream
    Referer: https://hostname.qlikcloud.com
    User-Agent: qlik/2.6.0 (linux)
    < Cache-Control: no-store
    < Connection: keep-alive
    < Content-Length: 0
    < Date: Fri, 26 Nov 2021 13:40:09 GMT
    < Location: /v1/temp-contents/61a0e3b924cb4200018dd773
    < Pragma: no-cache
    < Strict-Transport-Security: max-age=15724800; includeSubDomains
    Response time: 10s
    Status: 201 Created
    Empty response body
    POST https://hostname.qlikcloud.com/api/v1/apps/import?fileId=61a0e3b924cb4200018dd773
    Authorization: Bearer omitted
    Content-Type: application/octet-stream
    Referer: https://hostname.qlikcloud.com
    User-Agent: qlik/2.6.0 (linux)
    < Cache-Control: no-store
    < Connection: keep-alive
    < Content-Length: 0
    < Date: Fri, 26 Nov 2021 13:40:09 GMT
    < Pragma: no-cache
    < Strict-Transport-Security: max-age=15724800; includeSubDomains
    Response time: 345ms
    Status: 404 Not Found
    Error: 404 - Not Found (empty response)

    Result from Local Executable

    qlik app import -f ./testapp.qvf --verbose
    Server-type not set, guessing "cloud"
    POST https://hostname.qlikcloud.com/api/v1/temp-contents?filename=app_upload_%20%20%20%20%20%20685844

    Authorization: Bearer omitted
    > Content-Length: 720896
    Content-Type: application/octet-stream
    Referer: https://hostname.qlikcloud.com
    User-Agent: qlik/2.6.0 (linux)
    < Cache-Control: no-store
    < Connection: keep-alive
    < Content-Length: 0
    < Date: Fri, 26 Nov 2021 13:38:08 GMT
    < Location: /v1/temp-contents/61a0e3403a254b00018081df
    < Pragma: no-cache
    < Strict-Transport-Security: max-age=15724800; includeSubDomains
    Response time: 10s
    Status: 201 Created
    Empty response body
    POST https://hostname.qlikcloud.com/api/v1/apps/import?fileId=61a0e3403a254b00018081df
    Authorization: Bearer omitted
    Content-Type: application/octet-stream
    Referer: https://hostname.qlikcloud.com
    User-Agent: qlik/2.6.0 (linux)
    < Cache-Control: no-store
    < Connection: keep-alive
    < Content-Length: 1061
    < Content-Type: application/json; charset=UTF-8
    < Date: Fri, 26 Nov 2021 13:38:09 GMT
    < Pragma: no-cache
    < Strict-Transport-Security: max-age=15724800; includeSubDomains
    Response time: 1070ms
    Status: 200 OK
    {
    "attributes": {
    "_resourcetype": "app",
    ...}

    Show Less
  • forum

    App Development

    Cumulation Month and Year in the Script

    Dear Qlik users,  I would like to create a table of cumulative values in the script. Contrary to all the post of this subject in the community, I don'... Show More

    Dear Qlik users, 

    I would like to create a table of cumulative values in the script.

    Contrary to all the post of this subject in the community, I don't have a specific fields of dates but rather 2 fields : the month and the year in the script.

    I have tried a few different ways to design such a tables without any success. 

    load pb script.PNG

    As you can see, the value field is EAC.

    I am consolidating the values per month and per year in one sheet.

    Below, the EAC21 field is defined like such

    sum({$<[Cost Baseline Version]={"RF*"},[Monthly Cost Destination]={'CAPEX'}>} EAC)/1000000

    and I want to edit the script so that the very same definition would do "Cumulated EAC21"  :

    table cumul.PNG

    I am quite lost and I really have no idea as of what to try next.

    Thank you very much for your help !

    Show Less
  • forum

    Connectivity & Data Prep

    use 3D IFC data (REVIT) whit Qlikview

    Is possible to make  tracer IFC,  connecting IFC data with Qlikview with 3D model visualization? for example same https://www.youtube.com/watch?v=GOFI... Show More

    Is possible to make  tracer IFC,  connecting IFC data with Qlikview with 3D model visualization?

    for example same https://www.youtube.com/watch?v=GOFITMImJ8s

    Show Less
  • forum

    App Development

    Count if Date

    Hello, I'm trying to create a KPI that counts the total number of orders that have expired. To do this I have the fields "due date", date and Order Nu... Show More

    Hello,

    I'm trying to create a KPI that counts the total number of orders that have expired.

    To do this I have the fields "due date", date and Order Number.

    The date format is 'DD/MM/YYYY' for both fields.

    So far I have created this formula:

    if([Fecha Vencimiento] < max(Fecha)), Count([No. Pedido]))

    But I don't get any number.

    Can you help me, please!

    Show Less
  • forum

    Deployment & Management

    Users Authentication on Qlik platform

    Hope you all are well   I am looking for a solution where I want to Authenticate users in qlik sense other than AD Authentication. Please let me know ... Show More
    Hope you all are well
     
    I am looking for a solution where I want to Authenticate users in qlik sense other than AD Authentication.
    Please let me know , Is there any other way to authenticate users when they login on qlik platform like Google Auth via Gmail.
     

    Show Less
  • forum

    Connectivity & Data Prep

    QVX_UNEXPECTED_END_OF_DATA:

    Hello kind people, I need your help I get this error every time i'm trying to load data from sql I tried to reduce data set, changed connectors, moved... Show More

    Hello kind people, I need your helpQVX Error.png

    I get this error every time i'm trying to load data from sql

    I tried to reduce data set, changed connectors, moved storing procedure, googled the issue but nothing helps -

    , any suggestion? when I load same query in sql it works but through qlik it doesn't, also this error appears at the end, so during the process you see loaded rows but the error pops up at the end 

    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