Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 158,147 members
  • 11,324 online
  • 1,709,030 posts
  • 128,319 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

      IF with And Operator

      I am creating an If statement which is connected to a variable and having trouble getting it to run.  I could get it to run when i had just the Day se... Show More

      I am creating an If statement which is connected to a variable and having trouble getting it to run. 

      I could get it to run when i had just the Day set to Monday but when i tried to add the shift time i am keep getting 0 as a result. Is there a different way i should be approaching this from.  I want to see the number of MVT which occur's on a Monday and at those shift hours.


      if(vdaydropdown = 'Monday' and MATCH(SHIFT_HOUR,'07','08','09','10','11','12','13','14'),
      Count({< entry_day = {'Monday'} , SHIFT_HOUR = {'07','08','09','10','11','12','13','14'}>} MVT))

      Show Less
    • forum

      Security & Governance

      Security rules for streams

      Good day, Dear Community! I was going to know if there any possibilities to create such a rule where - only certain users with certain environment.IPs... Show More

      Good day, Dear Community!

      I was going to know if there any possibilities to create such a rule where - only certain users with certain environment.IPs could access to particular streams in Qlik Sense

      I have tried the method below, so far no success:

      Ex:

      (user.name="user_01" and user.environment.ip="123.123.123.123")

      or

      (user.name="user_01" and user.environment.ip="123.123.123.456")

       

      And if there is someone who is trying to access "user01" by using IP: 123.123.123.789  then he should not get access to the stream 

      P.S. This is the case where one Qlik analyzer account is shared among multiple users in an organization. 

      Show Less
    • forum

      New to Qlik Sense

      Join when missing data

      Hi, I have data like below. Tabel 1 is a large tabel when all the data except the number of beds. I want to add  the number of beds that each departme... Show More

      Hi,

      I have data like below.

      Tabel 1 is a large tabel when all the data except the number of beds.

      I want to add  the number of beds that each department on specific dates to tabel 1.

      I have tried using applymap with a key made from department&'-'&date. But the problem is that on some days, there are departments that have no patients.  (like department "a" on the 02/01/2022 in the example below)

      How can I add a row to table 1 with the number of beds for the days, when there are no patients?

       

      Tabel 1:      
      Department Date Number of patients  
      a 01-01-2022 2  
      b 01-01-2022 3  
      c 01-01-2022 4  
      b 02-01-2022 4  
      c 02-01-2022 5  
             
             
      Tabel 2:      
      Department Date Number of beds  
      a 01-01-2022 2  
      b 01-01-2022 2  
      c 01-01-2022 2  
      a 02-01-2022 2  
      b 02-01-2022 2  
      c 02-01-2022 2  
             
             
             
             
      Desired output:      
      Department Date Number of patients Number of beds
      a 01-01-2022 2 2
      b 01-01-2022 3 2
      c 01-01-2022 4 2
      a 02-01-2022 0 2
      b 02-01-2022 4 2
      c 02-01-2022 5 2
      Show Less
    • forum

      New to Qlik Sense

      Number formatting

      HI All, KPI is showing sum(sales ) as 1.58M, is it possible to convert it in number formatting to 1.6M. In KPI I have used number formatting as Auto.
    • 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

      How to change the colour of data in a cell using Pivot table

      Hi  All,I am a Qliksense Developer and a learner.I have one query on how can I assign colour to each cell in a Pivot table.Example: I have two columns... Show More

      Hi  All,

      I am a Qliksense Developer and a learner.
      I have one query on how can I assign colour to each cell in a Pivot table.
      Example: I have two columns 

        Status    
        Low Medium  High
      Risk      
      Low 1 2 3
      Medium 4 5 6
      High 7 8 9

       

      I want to assign text value 1 Black color as it is Low-Low
      Low-Medium i.e. for value 2 I want to assign green color 
      and Low -High i.e. value is 3 ,green color and so on for rest of the combinations.

      Can someone please help me with this.
      I have tried if condition but the header color got changed.
      Thanks in Advance.

      Show Less
    • forum

      QlikView Administration

      License obtain

      I want to issue my license for the machine DESKTOP-KLS4PFQ
    • forum

      New to Qlik Sense

      Cumulation on load script

      Hi, How to to cumulation load script. This expression is not working : RangeSum(peek('Cumulative') ,ReceivedQty) AS Cumulative   LOAD if(isnull(UPPER(... Show More

      Hi,

      How to to cumulation load script.

      This expression is not working :

      RangeSum(peek('Cumulative') ,ReceivedQty) AS Cumulative

       

      LOAD
      if(isnull(UPPER(po_version)),'-',UPPER(po_version)) as "Base",
      UPPER(ems) as "EMS*",
      UPPER(mpn) as "MPN*",
      UPPER(maker) as "MAKER*",
      UPPER(supplier) as "SUPPLIER*",
      upper(NPI_flag) as "NPI Flag_V",
      months as "MONTH*",
      ReceivedQty as "Delivered Quantity",
      RangeSum(peek('Cumulative') ,ReceivedQty) AS Cumulative,
      BalanceQty as "Balance Quantity",
      Total_RequestedQty ,
      text("commodity_type") as "Commodity Type",

      processed_at

      resident Temp Where Left(ems, 3) <> 'PNE'and months <> 'None' ;

       

      Could you please help me with this.

       

      Thanks...

      Show Less
    • forum

      QlikView Integrations

      Qlikview reports Not opening from External URL site

      Hi,We are having both Qlikview external and internal site URLS from analyst and participant tools. Qlikview reports are opening from internal site but... Show More

      Hi,
      We are having both Qlikview external and internal site URLS from analyst and participant tools. Qlikview reports are opening from internal site but not from external site.
      For example: Internal site : qv.companydomain.com
      external site: qv.company.com
      Authentication is happening by ticketing process. Ticket will be generated when we open the reports. Currently from internal site ticket is generating not from external site

      Show Less
    • forum

      New to Qlik Sense

      Row total percentages in a user defined custom table

      Hope someone might be able to assist with this. We're looking to include some sort of custom report table within our new QlikSense apps (where users c... Show More

      Hope someone might be able to assist with this. We're looking to include some sort of custom report table within our new QlikSense apps (where users can select the visible dimensions and can specify the measure to be used.). The issue we're stuck with is that we want to offer the ability to calculate percentages based on the final field/row total e.g. if a table was displaying data for Divisions and Gender, we'd like to be able to provide percentages totalling 100% for each division. If a user was to then decide they'd like to change columns to Programme and Age Bracket, we'd still like the table to be able to calculate the proportions properly.

      In our old Qlikview dashboards, we had a workaround where the user was presented with a pop up list box containing a field list so they could select their desired denominator. This was then fed into a variable which was then called in the following expression:

      =count(FTE)/count(total<[$(vPercentageby)]>[FTE])

      If possible, we'd like our QlikSense app to automatically pick up the appropriate field as a denominator. Does anyone have any ideas on how to accomplish this?

      Any help is most appreciated.

      Matt

      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