Qlik Community

Ask a Question
Welcome to Qlik Community
cancel
Showing results for 
Search instead for 
Did you mean: 
3,921 online

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

Qlik Academic Program

Qlik gives qualified university students, educators, and researchers free Qlik software and resources to prepare students for the data-driven workplace.

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.

Support

Access Support programs, Knowledge Base, Updates blog, and Release Notes.

Community Sitemap

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

Recent Discussions

  • No Boards Found
  • forum

    Qlik NPrinting Discussions

    NPrinting. Show different columns depending on cycle dimension.

    Hello,I need to show the result of diferent Data Qualities in diferent Excel files (one per DQ).So I have a table with all the Data Quality types and ... Show More

    Hello,

    I need to show the result of diferent Data Qualities in diferent Excel files (one per DQ).

    So I have a table with all the Data Quality types and their headers (fields):

    Morgoz_0-1627626537652.png

    And a table containing all the data with all the possible fields in any DQ:

    Morgoz_1-1627626692765.png

    So, I was able to make a cycle in NPrinting to print a file per DQ, using the DQ Name as dimension for the cycle:

    Morgoz_2-1627626906180.png

    The problem now is that I don't know how to make NPrinting include just the fields of each DQ in its file. I mean, in the Excel template I have a table with all the posible fields in all DQs (based on DQ_CUSTOMER table), and what I need is that NPrinting uses only the corresponding fields of each DQ, based on the "DQ_VIEW_FIELDS" field that contains all the fields of each DQ.

    In draft, something like this:

    Table with headers (fields) per DQ:

    Morgoz_11-1627628339676.png

    Table with all fields of all DQs:

    Morgoz_9-1627628158670.png

    File for DQ 1

    Morgoz_10-1627628195117.png

    File For DQ 2

    Morgoz_7-1627628004567.png

    File For DQ 3

    Morgoz_8-1627628047899.png

     

    Any idea will be really appreciated.

    Thank you.

    Show Less
  • forum

    App Development

    Combine Load & SQL Query

    Hi EveryoneI am trying to connect Load and SQL Statement after I drop the table (so not using concatenate as I am not using star scheme in this case).... Show More

    Hi Everyone

    I am trying to connect Load and SQL Statement after I drop the table (so not using concatenate as I am not using star scheme in this case). I want to connect additional dimension to existing model through ID. Can you advise please?

    Many thanks

    question.jpg

     

    Show Less
  • forum

    QlikView App Dev

    How to extract QVD data using .NET

    Is there any way to extract data from QVD file using .NET?I need to get at least XML header to describe the fields in the table, the layout of the sub... Show More

    Is there any way to extract data from QVD file using .NET?

    I need to get at least XML header to describe the fields in the table, the layout of the subsequent information and other meta-data

     

    Thanks in advance.

    Show Less
  • forum

    Integration, Extension & APIs

    [SDK] GetTablesAndKeys not working

    Hi,With the SDK I'm trying to retrieve an overview of all tables and fields in the datamodel of an App. I'm using the GetTablesAndKeys function, but c... Show More

    Hi,

    With the SDK I'm trying to retrieve an overview of all tables and fields in the datamodel of an App. I'm using the GetTablesAndKeys function, but can't get it to work. I keep getting a "Invalid method parameters" exception.

    I've looked in the forums and the documentation but can't find what I'm doing wrong. Anyone got any thoughts on this? Thanks in advance!

     

     

    var appId = location.AppWithId("c8a75f27-bebf-49b3-b2f0-af963497d864");
    var app = location.App(appId);
    app.GetTablesAndKeys(
        new Size() { cx = 1000, cy = 1000 }
        , new Size() { cx = 0, cy = 0 }
        , 30
        , true
        , false );

     

    Mathijs_0-1627387139431.png

     

    Show Less
  • forum

    New to Qlik Sense

    Analyzer add

    According to Qlik help an user with analyzer license can add private sheets. The text says "You can explore and make data discoveries in apps. In some... Show More

    According to Qlik help an user with analyzer license can add private sheets. The text says "You can explore and make data discoveries in apps. In some apps, you can add your own private sheets and stories, but you cannot share these with other users."

    I am trying to figure out how to give the Analyzer user this possibility, but I can not find out how to do it. Does anybody know?

     

    Show Less
  • forum

    App Development

    Need incremental flag based on Rank value.

    Hi All, Hope all is well,Please help me on one scenario where I need a code which provide me incremental Flag numbers based on id , Date and Rank.For ... Show More

    Hi All,

     

    Hope all is well,

    Please help me on one scenario where I need a code which provide me incremental Flag numbers based on id , Date and Rank.

    For example

    if a id have four zero ranking then it should be show the result like for first Zero the flag will be  Issue1 for second zero rank Flag will be  Issue2..  and so on.

    I am attaching a sample data with expected result column.

     

    manojin123_0-1627503171907.png

     

    Show Less
  • forum

    New to Qlik Sense

    Section access

    HI AllRight now i am working with Qlik Section access but i am able to apply section access.but i want to see total number of supervisor For Example i... Show More

    HI All

    Right now i am working with Qlik Section access but i am able to apply section access.

    but i want to see total number of supervisor 

    For Example i am A person.i am open my A access based app, I can be see only A Data that is 10 but i want to see C is 30 and D is 100 as well in my app  

    How can i see both C and D total dataCapture.PNG

    Show Less
  • forum

    New to Qlik Sense

    Price history in visualexpression

    Hi,I would like to show a simple price history in a table and diagram.For this I have a date and a part number as the dimension and the price. The dat... Show More

    Hi,

    I would like to show a simple price history in a table and diagram.

    For this I have a date and a part number as the dimension and the price. The date is linked to the master calendar.

    In the raw data there are part numbers with several dates with the same price and different prices (see table).

    Example:

    PartNoDatePrice
    1100001.01.202115,50
    1100003.01.202115,50
    1100004.01.202116,00
    1100006.02.202116,10
    1100007.02.202116,10
    1100009.04.202116,10
    1100010.04.202113,00

     

    In the price history, only one price change should be used.
    If the price remains the same at another point in time, it should not be displayed.

    The result should then look like this:

    PartNoDatePrice
    1100001.01.202115,50
    1100004.01.202116,00
    1100006.02.202116,10
    1100010.04.202113,00

     

    Does anyone have any idea how I can do this?

    Show Less
  • forum

    App Development

    What if the measure used in calculated on measure in dimension limitation has du...

    Hi All,I want to limit my dimension by top 10. When i use limitation in dimension property, it uses the first measure in the table as calculated on me... Show More

    Hi All,

    I want to limit my dimension by top 10. When i use limitation in dimension property, it uses the first measure in the table as calculated on measure which is what i also want to do. But the measure used has duplicates. In such case, i want this look after another measure. But i am not sure on what basis it limits the dimension when the measure has duplicates.

    Ex: I want to limit the team based on their total score. When all the teams are in same total, i want this to look at no.of fours and if that too same, it should look at no of sixes and so on. 

    How to achieve this in Qliksense?

    Show Less
  • forum

    App Development

    Discard values in QVD

    Hey I have this dataWe have patients and status for a program in MonthYearsI am trying to discard values in Script, for example, for patient 876978, i... Show More

    Hey 

    I have this data

    julianortiz_0-1627581298694.png

    We have patients and status for a program in MonthYears

    I am trying to discard values in Script, for example, for patient 876978, if i have more than one record in a MonthYear, i should keep only Active status, but if i only have one record per MonthYear i should keep the same status.

    This is the result that i should have:

    julianortiz_1-1627581632544.png

     

    Any ideas?

    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