Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 162,738 members
  • 9,391 online
  • 1,715,534 posts
  • 129,194 Solutions
  • Announcements
    Coming Aug. 9: New Simplified Authoring for Qlik Sense SaaS – For Details, CLICK HERE

    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

      QlikView App Dev

      Create today / current month of current year button

      Hello guys. I am new at qlikview . I have data from 2021 & still going on. I want to create a button that it will take data from the current month of ... Show More

      Hello guys.

      I am new at qlikview .

      I have data from 2021 & still going on.

      I want to create a button that it will take data from the current month of the current year.

      Any suggestion?

      thank you for your time.

      Show Less
    • forum

      New to Qlik Sense

      Lock KPI chart that displays a formula

      hi, i can see a number of posts showing how to lock a visulsaition using {1} . however im having trouble getting this to work on my formula: ='$(vMaxI... Show More

      hi,

      i can see a number of posts showing how to lock a visulsaition using {1} .

      however im having trouble getting this to work on my formula:

      ='$(vMaxID) / $(vTotal)'

       

      is it possible to lock the above formula so selections dont impact my vMaxID value?

      thanks 

       

      Show Less
    • forum

      App Development

      Graph is showing information that I dont want to be shown

      Hello! I have the following graph, and you can see the gray on top of each year. I want to get rid of that. The grey orders are as '-' classify. I tri... Show More

      Hello!

      I have the following graph, and you can see the gray on top of each year. I want to get rid of that. The grey orders are as '-' classify. I tried using the following but it did not work out : If(Order Type <> '-', sum(amount))

      I know I can deselect the option " Include Null Values", but if I do that, the rest of my dashboard will not make sense. 

      What can I do? Can I solve this with an if function?

      The pic is attached

      Show Less
    • forum

      Qlik Application Automation

      Support Binary Load of App in the Managed Space

      Hi Team,App Automation for "reduce and loop" concept is good to use.But drawback is "its publish only on the Managed Space" and also, we can't use "bi... Show More

      Hi Team,

      App Automation for "reduce and loop" concept is good to use.

      But drawback is "its publish only on the Managed Space" and also, we can't use "binary" load from the "managed" space. In that case, we can't reduce the data model based on Entity or country. 

      I think, Either in "App Automation", we need to have "publish to shared space" or we need to have "use" binary load from the "Managed" space which helps on this. 

      Hope its easy implementation from Qlik Side. 

      @Meghann_MacDonald 

       

      MayilVahanan_0-1634193134698.png

       

      Show Less
    • forum

      New to Qlik Sense

      QLIK SENSE

      HELLO !! please i need to create a matrix with the same dimensions (column=row=category) to compare each category  item 
    • forum

      QlikView App Dev

      Qlikview query frontend

      Hi please help me to solve the below issue attached excel   how to select the period from the list box is there any expression, and how to find the pr... Show More

      Hi please help me to solve the below issue attached excel

       

      how to select the period from the list box is there any expression, and how to find the previous year from the current selection year, to find the difference between two quaters

      Show Less
    • forum

      New to Qlik Sense

      Qlik export API for container object

      Hi All, Is there any Qlik API that support export from container object. Please suggest.
    • forum

      Integration, Extension & APIs

      Will Qlik have features to Write to Service now

      HI,  I am reading many data's from Servicenow Through API. but is there any option to write in Service now from QLIK. basically, I have a table in qli... Show More

      HI,

       I am reading many data's from Servicenow Through API. but is there any option to write in Service now from QLIK.

      basically, I have a table in qliksense. App will run for every 15 days. table is for comparing 2 different datasets. if value is not matching, table will show mismatch and server details

      If I have mismatch in table, it has to trigger SERVICENOW and create Incident to Respective teams. Is there any way to achieve this?

       

      Show Less
    • forum

      App Development

      License problem

      Hi support, what is to do to switch to a developer license?I see the info that I have a personal edition. Regards Volker
    • forum

      New to Qlik Sense

      Best datamodel for a generic table

      I have a generic table with below fieldsID,TYPE1,TYPE2,TYPE3,TYPE4,"COUNT"What will be the best way to put this table in data model where the number o... Show More

      I have a generic table with below fields
      ID,
      TYPE1,
      TYPE2,
      TYPE3,
      TYPE4,
      "COUNT"

      What will be the best way to put this table in data model where the number of records expected is 9999999

      1)Use a generic Load and store all tables created as individual QVD files with a for loop and map it to the actual fact table with ApplyMap. 
      Since each TYPE has 2 to 8 distinct values, the number of QVDS could be too many

      DATA:
      Generic
      LOAD
      ID,
      TYPE1 & '_' & TYPE2 & '_' & TYPE3 & '_' & TYPE4,
      "COUNT"
      resident GENRICTABLE ;


      2) Use if condition for each fields and have association to the other fact table. Number of If condition could be too many.

      DATA:
      LOAD
      ID,TYPE1,
      TYPE2,
      TYPE3,
      TYPE4,
      if (match(TYPE1,'J'),if (match(TYPE2,'P'),if (match(TYPE3,'D'),if (match(TYPE4,'C'),COUNT)))) as JPDC,
      .
      .
      .
      if (match(TYPE1,'K'),if (match(TYPE2,'P'),if (match(TYPE3,'D'),if (match(TYPE4,'C'),COUNT)))) as KPDC,
      resident GENRICTABLE ;

      3) Write multiple left joins to actual fact table

      Left join(FACT)
      Load ID,
      COUNT as JPDC from GENRICTABLE where TYPE1='J'
      and TYPE2='P' and TYPE3='D' and TYPE4='C';
      .
      .
      .
      Left join(FACT)
      Load ID,
      COUNT as JPDC from GENRICTABLE where TYPE1='K'
      and TYPE2='P' and TYPE3='D' and TYPE4='C';

      I understand that there are lot of factors like data density for each types ,my final data requirement etc. to be considered. It will be helpful if any one could provide a direction in which I will have to do the thinking.

       

      @sunny_talwar Can you please provide your thoughts 

      Show Less

    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

    QlikWorld Tour

    Discover your data swagger at a city near you.

    Find your city

    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