Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 158,274 members
  • 11,655 online
  • 1,709,202 posts
  • 128,334 Solutions
  • Announcements
    IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS

    Welcome to Qlik Community

    FOR NEW MEMBERS

    Everything you need to make your Qlik Community experience valuable.

    SEARCH KNOWLEDGE BASE

    Explore official Support and member created content.

    ASK PRODUCT QUESTIONS

    Submit questions to product experts and participate in conversations.

    Analytics

    Forums for Qlik Analytic 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 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

      New to Qlik Sense

      Calculating Age Based on Date of Birth

      Hi All,I need to calculate the age of the Employees as on today based on "Date of Birth" column which is available in the Data. Looking forward for So... Show More

      Hi All,
      I need to calculate the age of the Employees as on today based on "Date of Birth" column which is available in the Data.

      Looking forward for Solution suggestions .

       

      Thanks & Regards,

      Manmeet Dhawan

      Show Less
    • forum

      QlikView App Dev

      filter to load only data until current month

      Hi, I've a date filter in my app which has the dates from 2020 until 2022, I've created a year filter to see only the 2021 and 2022 years in list box ... Show More

      Hi,

      I've a date filter in my app which has the dates from 2020 until 2022, I've created a year filter to see only the 2021 and 2022 years in list box using the below expression and is working as expected.

      =aggr(only({<Year = {">=$(=year(today())-1)<=$(=year(today()))"}>}Year),Year)

      Now my requirement is to create another filter for month and I would like to see data until current month, it means if I select 2021 in year filter I want month's from Jan - Dec and if I select 2022 in year filter I want month's from Jan - July (Current Month).

      Regards,

      Vikas

      @sunny_talwar 

      Show Less
    • forum

      New to Qlik Sense

      Including values in chart which aren't in dataset

      Hello, I'm hoping someone can help. I've got a chart looking at grades achieved for a particular module. I've hit a bit of a snag however, I'd like ea... Show More

      Hello,

      I'm hoping someone can help. I've got a chart looking at grades achieved for a particular module. I've hit a bit of a snag however, I'd like each chart to display all the potential grades across the horizontal axis, including those not recorded in the dataset. e.g a module might have any number of the following grades - A+, B+, C, D+, D, F. 

      What I'd like to do is include the full list of grades which could have been achieved so the axis would read A+, A, B+, B, C+, C, D+, D, MF, F.

      I tried adding in an inline table (see below) and turned on 'show null values' but they don't appear.

      LOAD * inline [
      Grade
      A+
      A
      B+
      B
      C+
      C
      D+
      D
      MF
      F
      DF
      IN
      NC
      NR
      NS];

      Does anyone have any ideas whether this is possible?

      Appreciated.

       

      Matt

      Show Less
    • forum

      New to Qlik Sense

      Aggregated function

      Hi  can somebody help me to write the following mathematical equation in Qlik sense Thanks Ishani
    • forum

      New to Qlik Sense

      Date picker doesnt recognise date data from load editor using SQL

      Hello Qlik Expert!Sorry if my english is bad.So as you can see in the subject, right now I want to use the Date Picker extension from Qlik Dashboard B... Show More

      Hello Qlik Expert!
      Sorry if my english is bad.

      So as you can see in the subject, right now I want to use the Date Picker extension from Qlik Dashboard Bundle. But when I see in the date field selection, there is no field that I can choose. You can see image below for the proof.

      Zaidan_as_0-1656649424733.png

      Then I see some another question from Qlik User that have the same problem as me, but all of them load the data not using the SQL like me. 
      So for the SQL it self, this is the illustration of it 

      Zaidan_as_1-1656649528269.png

      Zaidan_as_4-1656649642498.png

       

      In the auto generated section, this field is already tagged as the Date

      Zaidan_as_2-1656649565753.png

      And I see some reference that I must change the format from my code as like the calendar picker format 

      Zaidan_as_3-1656649623241.png

      but the result is the same. there is no selection for the date field.

      So any suggestions guys ?

      Show Less
    • forum

      QlikView Administration

      Use database source for deciding what QVWs to execute

      I have complex scenario that I am trying to automate that involves running conditional based ETL flows which involve QMC tasks and triggers to decide ... Show More

      I have complex scenario that I am trying to automate that involves running conditional based ETL flows which involve QMC tasks and triggers to decide what QVWs, if any, run.  On the first of the month, I want to start a QlikView QMC task that runs a "pre-check" kind of qvw against a database table to see if 1 (or more) of 3 jobs is ready for Qlik to process, meaning, all the data exists in the database for the respective job. and it is safe for Qlik to process it without leaving out rows.  One of 3 results (single value) will occur from the "pre-check" and dump a qvd with those results that the next QVWs can make decisions on what to do next.   The 3 possible results are Recheck (no job data is ready), Run (1 or more job data is ready), and Done (all 3 jobs have gone through Qlik etl processing).  The Qlik ETL path can run up to 3 times but not more than 3 times, and is dependent upon which jobs are ready according the database that gets loaded into the “pre-check” QVW.desired flow.PNG

       

       

       

       

       

       

       

      The trouble I am having and don’t know how to code for in the script that will decide what to do once the result value is loaded from the result qvd is how to exit the script if the condition is not met (hence, false) but if the condition is met (hence, true) have the script continue to run which then will trigger the rest of the qvws for my ETL to execute.

      So with my data how can I do this:

      If result = Recheck then exit script and trigger original QMC to run the “pre-check” load again

          If result = Run then execute the Qlik ETL path, send notification, and trigger original QMC task again

              If result = Done then exit script and send notification and do nothing else

      Show Less
    • forum

      QlikView Administration

      Reload task

      Hi,  I have started Relaod task on the table but it stucked on 99% for a day. Any idea?
    • forum

      Deployment & Management

      Upload QSEoW app to the Cloud

      Hello,I am trying to transfer existing Qlik applications from our QSEoW environment to our Cloud environment. However, after exporting from QSEoW and ... Show More

      Hello,
      I am trying to transfer existing Qlik applications from our QSEoW environment to our Cloud environment.

      However, after exporting from QSEoW and importing into the Cloud, all sheets are marked as "Public" but I have no option to make them "Private". I can't delete these Public sheets either.

      I am the owner of both the application and the (shared) space. I also tried uploading the app to my Personal space.


      How can I solve this?

      Show Less
    • forum

      App Development

      Can't see data in a table though script log shows data loaded successfully

      Hi, I am facing some strange issues. I can see from the Script log that records have been loaded into tables correctly. But when I check the table at ... Show More

      Hi,

      I am facing some strange issues. I can see from the Script log that records have been loaded into tables correctly.

      But when I check the table at the App level, can't find any data.

      Script log

      gayatri7_0-1656610251973.png

       

      gayatri7_1-1656610336083.png

       

      Data Model view

      gayatri7_2-1656610465320.pnggayatri7_3-1656610577187.png

      what could be the reason. Please advise.

       

      Thank you in advance!

      Gayatri

      Show Less
    • forum

      App Development

      QlikView Resident Load in SQL where clause

      Thanks for taking the time to read this....Can I add a resident load in SQL FROM clause?  Like so ...   TMP:SQL SELECT * from table WHERE date_parse(d... Show More

      Thanks for taking the time to read this....
      Can I add a resident load in SQL FROM clause? 

      Like so ...

       

      TMP:
      SQL SELECT * from table WHERE date_parse(date,'%Y-%m-%d') < date_trunc('month', current_date)
      and
      date_parse(date,'%Y-%m-%d') >= date_trunc('month', current_date) - interval '1' month

      ;

      Main:

      SQL SELECT item, max(date) 
      FROM Resident TMP
      GROUP BY 1;

      Show Less

    Get Started On Community

    Start Here Get Started On Community

    Top Participants

    Blogs

    Community News

    Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!

    Blogs

    Qlik Academic Program Blog

    Read the latest blog around the Qlik Academic Program.

    Blogs

    Qlik Product Innovation Blog

    If you want to know what's new across all of the products in our growing Qlik product portfolio.

    Blogs

    Support Updates Blog

    Get the latest Support information about end-of-product support, new service releases, and general support topics.

    Blogs

    Qlik Design Blog

    Read all about Qlik solutions: scripting, data modeling, visual design, extensions, best practices and more.

    Location and Language Groups

    Choose a Group

    Join one of our Location and Language groups. Find one that suits you today!

    Collaborate

    Healthcare User Group

    Healthcare User Group

    A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..

    All are welcome

    Japan Group

    Japan

    Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。

    Request to join

    Brasil Group

    Brazil

    Welcome to the group for Brazil users. .All discussions will be in Portuguese.

    open to all

    Events and Webinars

    Qlik and Qlik Community Hosted Events

    Subscribe to our Events and Webinar page so you do not miss an event opportunity!

    choose and register

    Event

    Welcome to Qlik

    Join the "Welcome to Qlik" webinar and learn about the Qlik Ecosystem, such as Qlik Community, Learning, and Help.

    On-Demand

    Events

    Upcoming Events and Webinars

    There is more than one way to find upcoming events, look on the right side of any Qlik Community forum!

    Upcoming