Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
logo
  • 152,028 members
  • 7,471 online
  • 1,702,060 posts
  • 127,266 Solutions
  • Announcements
    QlikWorld online is next week! 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

      Reporting Service

      TCD afficher colonne selon condition

      Bonjour à tous, J'ai réalisé un TCD de ce genre dan Qlik Sense Business      2022 2021     Quantité VS N-1 Quantité VS N-1 A JANVIER         ... Show More

      Bonjour à tous,

      J'ai réalisé un TCD de ce genre dan Qlik Sense Business 

          2022 2021
          Quantité VS N-1 Quantité VS N-1
      A JANVIER        
        FEVRIER        
        MARS        

      J'aimerais afficher la colonne "VS N-1"  uniquement pour l'année en cours soit uniquement pour l'année 2022 en ce moment et donc obtenir cela :

          2022 2021
          Quantité VS N-1 Quantité
      A JANVIER      
        FEVRIER      
        MARS      

       

      J'ai testé de mettre une condition d'affichage de la colonne grâce à une expression (year(Today())=Année mais cela s'applique aux 2 colonnes "VS N-1".

      Je vous remercie de votre aide,

      No

      Show Less
    • forum

      Security & Governance

      Security Rule for Developing in Streams

      Hello Qlik Experts, i have created some security rules, where users are allowed to develop in a specific developer stream. The idea behind this is tha... Show More

      Hello Qlik Experts,

      i have created some security rules, where users are allowed to develop in a specific developer stream.

      The idea behind this is that there are not an unnecessarily infinite number of apps. And there is only one app, on which several users with certain rights work on the frontend/backend in parallel. I managed to make it so that certain users can open/read/edit the script editor. But in the frontend i am still missing two panels (fields, variable).

      Is there any security rule that says, that users with the development property are allowed to see these panels?

      SonPhan_0-1651910171310.png

      Best regards Son

      Show Less
    • forum

      Connectivity & Data Prep

      Mark as read Outlook 365 Connector

      Hi all! I don't know how to ask for new improvements, so I decided to write it down here. Is it possible to add a new "table" on Outlook 365 Connector... Show More

      Hi all!

      I don't know how to ask for new improvements, so I decided to write it down here.

      Is it possible to add a new "table" on Outlook 365 Connector to mark as read a mail on O365 mailbox?

      It would makes it easier for us to manage the receipt of data by mail.

       

      Regards,

      Alonso Torres

      Show Less
    • forum

      App Development

      Loading multiple headers in QlikView

      Hi All, I have three different headers based on language and wanted to know how I can load this data in QV along with respective data for these three ... Show More

      Hi All,

      I have three different headers based on language and wanted to know how I can load this data in QV along with respective data for these three headers.

      If you look at the sample below:

      Row 1, 3, 5 are headers. Row 2,4,6 are respective data for these three headers. Now on the UI I want to create three report based on different header/language. Only identifier we have for three headers - LangaugeFlag. 

      Date Language Language Flag Issue
      16-05-2021 English English A
      Date Language CHHeader Issue
      16-05-2021 Chinese Chinese B
      Date Language JPHeader Issue
      16-05-2021 Japanese Japanese C

      Sample Output:

      Output 1: English

      Date Language LanguageFlag Issue
      16-05-2021 English English A

      Output 2: Chinese

      Date Language CHHeader Issue
      16-05-2021 Chinese Chinese B

      Output 3: Japanese

      Date Language JPHeader Issue
      16-05-2021 Japanese Japanese C

       

      Please let me know how this can be achieved in the backend script. 

      Note: have huge volume of data and loading the table from database. Only way to differentiate three headers based on Language Flag column

      Show Less
    • forum

      QlikView Integrations

      QlikView job?

      Hey everyone, So I've been working in QlikView for 1.5 years in my 9 to 5 job, and I would love too make models as a freelancer during evenings and ... Show More

      Hey everyone,

      So I've been working in QlikView for 1.5 years in my 9 to 5 job, and I would love too make models as a freelancer during evenings and weekends.

      Does anybody know anyplatforms aside from workana and upwork?

      Any help would be appreciated.

      Show Less
    • forum

      QlikView Integrations

      Chart representation

      I have this graph in which the red bar represents the new products that have arrived, the blue bar represents the pending units (this are the units t... Show More

      antupe_0-1652700404819.png

      I have this graph in which the red bar represents the new products that have arrived, the blue bar represents the pending units (this are the units that have arrived and must be repaired) and the green bar represents the number of units that have been repaired.

      I have used he following expressions:

      New products: count({$<DateType={'Arrived'}>} ProductID )

      Repaired: count({$<DateType={'Repaired'}>} ProductID )

      Pending Units: rangesum(above(total count({$<DateType={'Arrived'}>} ProductID ),0,RowNo(total)))-rangesum(above(total count({$<DateType={'Repaired'}>} ProductID ),0,RowNo(total)))

      This is showing my data correctly but when I select a particular date, the formulas apparently apply from that date and not for the total of the data.

      For example when the date 31/03/2022 is selected the representation changes from the one seen above to the following:

      antupe_1-1652701004368.png

      How can I avoid this?

      Show Less
    • forum

      Connectivity & Data Prep

      Loading multiple files from a Sharepoint intranet site

      Hi all I need to load multiple files into Qlik Sense from a Sharepoint library on our intranet.  I've previously been able to load data from individua... Show More

      Hi all

      I need to load multiple files into Qlik Sense from a Sharepoint library on our intranet. 

      I've previously been able to load data from individual files by creating a direct connection to a file with no issues. However this time I need to load data from 100 different files in the same library so this method isn't viable. 

      I do have access to the Office 365 Sharepoint Web Connector but haven't been able to get it to authenticate. Any tutorials on Web Connectors use a .com address as the base URL, but as I'm trying to connect to an intranet site it's a .aspx address which comes back as an invalid resource.

      Does anyone have any advice? Thanks in advance

      Adam

       

      Show Less
    • forum

      New to Qlik Sense

      Week Cummilation Issue

      Hi, Please help me with the below requirement.   Attaching the sample data and in the data we need to consider week '2244' .   Thanks, Kishore Show More

      Hi,

      Please help me with the below requirement.

      krish2459_1-1652700849991.png

       

      Attaching the sample data and in the data we need to consider week '2244' .

       

      Thanks,

      Kishore

      Show Less
    • forum

      App Development

      QLIK Sense Unknown Error on reload

      HiI have a couple of Qlik Sense Applications running on the windows server version that are failing to save when reloading (not all).When I click the ... Show More

      Hi

      I have a couple of Qlik Sense Applications running on the windows server version that are failing to save when reloading (not all).

      When I click the "Load Data" button in the Data load editor it seems to work fine until it gets to the end of the Data Load progress. the "Saving app..." appears for a brief second before it get overridden by the text "Unknown error".

      Below is the contents on the Data load progress dialog on "Load data"

      ----------------------------------------------------------------------------------------------------------------

      Started loading data
       
      Connected stay << QueryResult
      Lines fetched: 364,108 Creating search index Search index creation completed successfully
      Unknown error
       
      Data has not been loaded. Please correct the error and try loading again.
      ----------------------------------------------------------------------------------------------------------------
       
      it does not seem to have anything to do with the data connectors as i even tried commenting out every line in the script editor which gave me the same result.
      Im not sure if something is locking the files in order to update or not. I even tried restarting server services with no success. 
       
      Would someone be able to shine some light on this issue as i cannot find anything on the web or forum about this.
      Show Less
    • forum

      New to Qlik Sense

      Set Expression

      Hi, I want to see the count of dates that lie in current week.I am using the expression  =count({< [Date] = {">=$(=WeekStart(Today()))<=$(=WeekEnd(Tod... Show More

      Hi, I want to see the count of dates that lie in current week.
      I am using the expression 

      =count({< [Date] = {">=$(=WeekStart(Today()))<=$(=WeekEnd(Today()))"}>}[Date])

      but there is no output. 
      Any suggestions on what am I doing wrong ?

      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