Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
logo
  • 152,610 members
  • 6,101 online
  • 1,702,764 posts
  • 127,360 Solutions
  • Announcements
    QlikWorld happening right now! You can still join: REGISTER NOW

    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

    QlikWorld 2022

    Inspiring keynotes. Informative breakouts. Innovative technology. Virtual Event May 17-19.

    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

      Security & Governance

      Possible to publish QS via Azure Application Proxy with pre-authentication enabl...

      Hi mighty forum, For Qlik Sense on premise published via Azure Application Proxy we have problems when Azure Pre-authentication is enabled, we get stu... Show More

      Hi mighty forum,

      For Qlik Sense on premise published via Azure Application Proxy we have problems when Azure Pre-authentication is enabled, we get stuck in an endless loop.
      The goal is to be able to reach QS on premise from internet for any user authenticated in the Azure AD.
      We have enabled SAML authentication and now would like to get rid of the requirement of VPN as well.

      We have read the instructions from 2018 about disable the Pre-Authentication, but IT do not prefer that option at all since they see it as a potential security risk to allow unauthenticated traffic into the corporate network.
      https://community.qlik.com/t5/Technology-Partners-Ecosystem-Documents/Azure-AD-Single-Sign-on-SAML-Over-an-Application-Proxy-External/ta-p/1491630?attachment-id=55067
      Anyone knows a way to configure this with Azure Pre-authentication enabled?

      Any help is highly appreciated

      Show Less
    • forum

      New to Qlik Sense

      Dateselect Current period

      Hi, I have 6 post with diffrent values. There is a date like this: FromDate Value 2025-08-03 224 2024-08-03 403,2 2023-08-03 582,4 2022-08-... Show More

      Hi,

      I have 6 post with diffrent values. There is a date like this:

      FromDate Value
      2025-08-03 224
      2024-08-03 403,2
      2023-08-03 582,4
      2022-08-03 761,6
      2021-08-03 940,8
      2020-08-03 1120

       

      I just want to show 2021-08-03 because it's current value (940,8) to show according to the date today.. When the date is =>2022-08-03 then i want the new value to show (761,6) What the best solution for this?

      Br

      Show Less
    • forum

      New to Qlik Sense

      Audit Details

      Hi, I have a user who has requested a report on User access and activity for Audit purposes, is there anyway on producing a report with this informati... Show More

      Hi, I have a user who has requested a report on User access and activity for Audit purposes, is there anyway on producing a report with this information apart from the data available in Session Details in Operations Monitor?

       

      Thanks

      Bryan

      Show Less
    • forum

      QlikView App Dev

      Different values depending on different date periods

      Hi best community! I have a table that contains a value from a date to a date. I just want to show that value for the current period. FromDate Valu... Show More

      Hi best community!

      I have a table that contains a value from a date to a date. I just want to show that value for the current period.

      FromDate Value
      2025-08-03 224
      2024-08-03 403,2
      2023-08-03 582,4
      2022-08-03 761,6
      2021-08-03 940,8
      2020-08-03 1120

       

      So in this case i just wanna show 940,8 (FromDate 2021-08-03), and when the current date are >= 2022-08-03 i just want to show the value 761,6 and so on 🙂

      Any ideas?
      Would it be best if I could get it in the script right away?

      Br

      Show Less
    • forum

      Qlik Replicate

      Reading from Replica

      Hello, Is Qlik Replicate  able to read changes from the replica/secondary in MongoDB? Any tips and suggestions to minimize the impact to MongoDB produ... Show More

      Hello,

      Is Qlik Replicate  able to read changes from the replica/secondary in MongoDB? Any tips and suggestions to minimize the impact to MongoDB production?

      Many Thanks.

       

      Show Less
    • forum

      New to Qlik Sense

      Filter Pane > Excluded Values Appearing Top of the list

      Hi Experts, In Filter pane, Excluded Values are appearing top of the list. How to bring the excluded value to bring down to list?  Anyone, Please hel... Show More

      Hi Experts,

      In Filter pane, Excluded Values are appearing top of the list.

      How to bring the excluded value to bring down to list? 

      Purushothaman_0-1652944705036.png

      Anyone, Please help!!

      Thank you!!

      Regards,

       

      Show Less
    • forum

      Qlik NPrinting Discussions

      Can we set a task timeout value in Qlik Nprinting?

      We are having an issue where some task get hanged for days and after many such tasks accumulate over few days new tasks that start execution go into q... Show More

      We are having an issue where some task get hanged for days and after many such tasks accumulate over few days new tasks that start execution go into queued state. Even after we abort the hanged task they do not get aborted until NPrinting services are restarted. 

      So we want to avoid this issue by terminating any task that is running for more that 12 hours. We have similar option in Qlik Sense but I don't see anything like that in Qlik NPrinting. 

      Is there any global setting we can do to set this timeout?

      Qlik NPrinting 

      Show Less
    • forum

      New to Qlik Sense

      Apply alternate state without aggregation in Set Expression

      Hi, I have a two sheet app. On sheet 1 (default state) I have a filter with dates. On sheet 2 (Alt state 1) I have a chart with with a filter with 100... Show More

      Hi,

      I have a two sheet app.

      On sheet 1 (default state) I have a filter with dates. On sheet 2 (Alt state 1) I have a chart with with a filter with 100 companies to choose from. I want to be able to choose a company from my sheet 2 filter but at the same time pick up the date selected on sheet 1 from the default state. 

       

      My expression before applying alternate state is as follows:

      Sum([Amount Outstanding Funded] * FX * [Val Date Discount]) / [Total EUR Outstanding]

       

      I am able to apply the alternate state to the first part of my expression:

      Sum({[Alt State 1]<ValuationDate = $::ValuationDate>}([Amount Outstanding Funded] * FX * [Val Date Discount])) / [Total EUR Outstanding]

      However, this does not give me the correct answer since the part of the expression after the "/" sign does not pick up the alternate state rule.

      How I do I achieve this?

      Thanks!

      Show Less
    • forum

      QlikView Administration

      Doc CAL issue

      Hi All, I have assigned Doc  CAL to user but user is able to see all the Application on Access point where as he is unable to open the application it ... Show More

      Hi All,

      I have assigned Doc  CAL to user but user is able to see all the Application on Access point where as he is unable to open the application it gives the error access denied. but as i have assigned Doc CAL other applications should not be visible to him on access point. please help me on the issue.

      Show Less
    • forum

      App Development

      How To get exclude Min and Max date Transaction for each Script Id by expression...

      Below is the Original data we need an expression to be created which will exclude min and max date transaction and give us all the transaction for a p... Show More

      Below is the Original data we need an expression to be created which will exclude min and max date transaction and give us all the transaction for a particular script id.

      Original Data     Out put required after applying the expression
      Script Id Date Amount     Script Id Date Amount
      Item A 01-01-2022 100     Item A 01-02-2022 75
      Item A 01-01-2022 50     Item A 01-03-2022 150
      Item A 01-02-2022 75     Item A 01-04-2022 100
      Item A 01-03-2022 150     Item A 01-05-2022 50
      Item A 01-04-2022 100     Item A 01-06-2022 25
      Item A 01-05-2022 50     Item B 01-03-2022 10
      Item A 01-06-2022 25     Item B 01-03-2022 30
      Item A 01-07-2022 50     Item B 01-03-2022 60
      Item A 01-07-2022 75     Item B 01-04-2022 30
      Item B 01-02-2022 40     Item B 01-05-2022 20
      Item B 01-03-2022 10     Item B 01-06-2022 10
      Item B 01-03-2022 30          
      Item B 01-03-2022 60          
      Item B 01-04-2022 30          
      Item B 01-05-2022 20          
      Item B 01-06-2022 10          
      Item B 01-08-2022 20          
      Item B 01-08-2022 30          

       

      Show Less

    Get Started On Community

    Start Here Get Started On Community

    Top Participants

    Blogs

    Qlik Product Innovation Blog

    Learn about what's new across all of the products in our growing Qlik product portfolio.

    Blogs

    Support Updates Blog

    Important and useful support information about end-of-product support, new service releases, and general support topics.

    Blogs

    Community News

    Updates about Qlik Community Platform as well as news and announcements.

    Blogs

    Qlik Design Blog

    All about product and Qlik solutions: scripting, data modeling, visual design, extensions, best practices, etc.

    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

    Deutsche User Group

    Deutsche User Group

    Der deutsch(-sprachig)e Qlik-Markt bietet so manche Spezialität, die sich hier leichter diskutieren läßt.

    All are welcome

    Events

    Unleash the Power of Your Finance Data

    Transform financial outcomes with next-gen business intelligence strategies

    Available On-Demand

    Events

    When You Liberate Your SAP Data, Everything Qliks

    How Qlik helped Greene Tweed reduced time to insights by 65%

    Now On-Demand

    Events

    Live Instructor Webinars

    Attend a live webinar session with our expert instructors and special guests to review learning topics in the Qlik Continuous Classroom and beyond.

    Live Instructors