Qlik Community

Ask a Question
Welcome to Qlik Community
cancel
Showing results for 
Search instead for 
Did you mean: 
4,436 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

    App Development

    Merge two dimension into one

    Hello,I have two dimensions which I am going to call "Dim A" and "Dim B", like this :Is there a way to merge them so they appear like that :Thanks  Show More

    Hello,

    I have two dimensions which I am going to call "Dim A" and "Dim B", like this :

    BearNBeer_0-1627551560567.png

    Is there a way to merge them so they appear like that :

    BearNBeer_1-1627551644510.png


    Thanks

     

    Show Less
  • forum

    App Development

    How to add song sound blur effect

    When adding a song to match a video, you can often end up with an abrupt start that can be unappealing and very upsetting. To get around this, you can... Show More

    When adding a song to match a video, you can often end up with an abrupt start that can be unappealing and very upsetting. To get around this, you can use a fade-in effect to gradually increase the volume, which will harmonize an audio track. If you want to add a fade-out effect to the audio track in a few clicks, you can try a song audio track at soundcloudtomp3downloader which is a good choice. Any audio in this program can be easily blurred out without too much effort. Want to try? 

    Show Less
  • forum

    App Development

    Need to Connect Kafka with Qliksense

    Hi Experts,I have a requirement that once Kafka streaming is done, it should automatically trigger the data load in Qliksense. Also, Qliksense should ... Show More

    Hi Experts,

    I have a requirement that once Kafka streaming is done, it should automatically trigger the data load in Qliksense. Also, Qliksense should be then able to show the latest data.

    Please help me with this issue. Any suggestions would be greatly appreciated.

     

    Show Less
  • forum

    Integration, Extension & APIs

    [REST/Javascript API] Get sheet and sheet's content with SaaS solution

    Hello, i've been struggling for past few days trying to get all the data i could on my apps.I tried Rest API , EnigmaJS and  JSONRPC approaches, and n... Show More

    Hello, i've been struggling for past few days trying to get all the data i could on my apps.

    I tried Rest API , EnigmaJS and  JSONRPC approaches, and no ones seems to allow to get :

    • All sheets reachable from the app's perspective
      • All the data used in a sheet
      • Where does this data come from (which dataset imported)
    • Where does the data imported in app come from (which connector, jdbc url, etc.)

    Is this possible with SaaS solution API (REST or JSONRPC or Javascript) ?

    Show Less
  • forum

    QlikView App Dev

    Cumulative sum by month in load

    Hello,I'm trying to add a variable to my data that would sum the values of all the previous month of this year + the actual month.Here is an example :... Show More

    Hello,

    I'm trying to add a variable to my data that would sum the values of all the previous month of this year + the actual month.

    Here is an example :

    YearMonthidAmountNew variable
    202101a1010
    202102b1020
    202103c1050
    202103d1050
    202103e1050
    202104f1060
    202105g1080
    202105h1080
    202106i1090

     

    I manage to do it in a table but i'm struggling to do it in the script pls help.

    Thanks.

     

    Show Less
  • forum

    QlikView App Dev

    In stocked bar chart getting miscellaneous bar

    Hi All,In 100% stocked bar chart im getting miscellaneous bar after 100%, i have unchecked the Include null values as well for the dimensions. how to ... Show More

    Hi All,

    In 100% stocked bar chart im getting miscellaneous bar after 100%, i have unchecked the Include null values as well for the dimensions. how to get rid of this unwanted bars. developing this chart in Qliksense

    stocked bar.JPG

    Thanks in Advance.

     

    Show Less
  • forum

    QlikView App Dev

    Color a field in a table box

    Hi Folks, in the attached figure I'm showing a table box I created in one of my projects.  This table contains matched data from two different systems... Show More

    Hi Folks, in the attached figure I'm showing a table box I created in one of my projects.  This table contains matched data from two different systems.  I would like to color the field called EXP_AMT so that it stands out and focuses my users eye.  I cannot figure out how to color this field, and I'm open to just coloring the field header or the underlying data.

    Thanks in advance for your help!

    George

    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

    App Development

    Calculating time as a percentage per dimension

    Hi, I've spent a couple of days on this problem now, and can't find a solution.So I have two tables.My parent order table:and my child order tableBasi... Show More

    Hi, I've spent a couple of days on this problem now, and can't find a solution.

    So I have two tables.

    My parent order table:

    johnnyjohn_2-1627546985655.png

    and my child order table

    johnnyjohn_3-1627546995933.png

    Basically, what I am trying to do here is calculate the child time as a percent, aggregated by Parent ID. To do this, I calculate the lifetime of the order in seconds (Max ChildTime - Min ChildTime) for each Parent ID, then calculate the time into the life of the order of the child in seconds (ChildTime - MinTime) for each Parent ID, then divide the time of the child by the life time of the order, that gives me the figure I want (mathematically at least).

    In QlikSense I have the below: 

    johnnyjohn_4-1627547456719.png

    where my Child Time in Second =

     

    =Num(ChildTime) *24*60*60

     

    First Fill in Second

     

    =Num(Aggr(Min(ChildTime),[Ord ID])) *24*60*60

     

    And Last Fill in Second

     

    =Num(Aggr(Max(ChildTime),[Ord ID])) *24*60*60

     

    But for SOME REASON, when  I try to find my Child Time - First Fill  with this, only a single value shows for the dimension, as shown on the table above

     

    =(Num(ChildTime) *24*60*60) - (Num(Aggr(Min(ChildTime),[Ord ID])) *24*60*60)

     

    Does anyone have any idea why this is happening? Or how I can achieve what I described.

    Thanks!!!

     

    Show Less
  • forum

    New to Qlik Sense

    Compare 2 dates using IF

    Hi ExpertI have the data as below and is trying to compare the 2 dates using IF function. If Schedule End date is later than Next Due Date then it wil... Show More

    Hi Expert

    I have the data as below and is trying to compare the 2 dates using IF function. 

    If Schedule End date is later than Next Due Date then it will be Miss

    If Schedule End date is same or earlier than Next Due Date then it will be Done

    My function is as below but have problem with same month. Please help

    =If ([Schedule End Date] > [Next Due Date], 'Done', 'Miss')

     

    Schedule End DateNext Due DateMiss/Done
    25 Jan 202101 Feb 2021Done
    09 Feb 202117 Feb 2021Miss
    11 Aug 202019 Aug 2020Miss
    01 Sep 202008 Sep 2020Miss
    19 Feb 202122 Feb 2021Miss
    01 Sep 202008 Sep 2020Miss
    19 Feb 202122 Feb 2021Miss
    01 Oct 202012 Oct 2020Miss
    29 Mar 202101 Apr 2021Done
    01 Oct 202012 Oct 2020Miss
    29 Mar 202101 Apr 2021Done
    10 Feb 202118 Feb 2021Miss
    11 Aug 202019 Aug 2020Miss
    10 Feb 202118 Feb 2021Miss
    11 Aug 202019 Aug 2020Miss
    10 Feb 202118 Feb 2021Miss
    11 Aug 202019 Aug 2020Miss
    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