Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
2,987 online

Find the forums for your Qlik data analytics products to ask a question, start a discussion, or review documentation.

Find the forums for your Qlik Data Integration products to ask a question, start a discussion, or review documentation.

May Qlik Alert You – Welcome to the Qlik Alerting Product Forum! Join in on the discussion around Qlik’s intelligent alerting solution for Qlik Sense! This is an open group to share and collaborate!

Here you will find Qlik Sense resources, partake in interesting discussions, solve problems and foster relationships with Qlik experts from around the globe.

Thank you for joining us in the QlikView Forum, your home for QlikView answers. Discover insights within your data that can transform your business.

Participate in Qlik Technical Previews, submit ideas, and review documentation.

Learn about upcoming Qlik related events, webinars and local meetups.

Join one of our Qlik Community Groups. Anyone can view content in Open Groups, but you must join to participate. Closed Groups require joining in order to view content and participate.

Hear directly from Qlik employees in our ten unique blogs. Check out the new Product Insight & Ideas Blog!

Qlik partners with leading technology companies to develop integrations, extensions, and connectors to the Qlik platform.

Discussion Boards and Documents for Qlik Services.

Learn about the Qlik Community. Explore 'How-To' documentation, ask questions, and engage in discussion around the community platform. This will also be the place where, from time to time, we will do some fun things.

Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.

Recent Discussions

  • No Boards Found
  • forum

    New to Qlik Sense

    Calculated dimension

    Hello,I have an tabel object with multiple dimensions and measures. I have a measure calculated like maxstring(field).But when I filter on some field ... Show More

    Hello,


    I have an tabel object with multiple dimensions and measures. I have a measure calculated like maxstring(field).
    But when I filter on some field it becomes '-' for some rows.
    I would like to suppress those rows, but I know that null values can only be suppressed in dimensions, not measures.
    So I tried to make an calculated dimension like
    If(isnull(maxstring(field)), null, 1) so I can filter with it the null values, but I gen the invalid dimension error.

    Any ideas?
    Thank you

    Show Less
  • forum

    Qlik Sense App Development

    Master Items (Dimensions)

    Hello got a dashboard in which there is not plenty of Dimensions created as master items with descriptions and tagsis there a way to list these detail... Show More

    Hello 
    got a dashboard in which there is not plenty of Dimensions created as master items with descriptions and tags
    is there a way to list these details (dimension name, description, tags) in a table

    Kindly advise @sunny_talwar 

    Show Less
  • forum

    New to QlikView

    Identifying Repeat and Unique Customers

    Repeat Caller Logic within 48 hours. (Repeat caller duration is based on callstartdate and prevcallsegstartdate as per the example provided)Formula: N... Show More

    Repeat Caller Logic within 48 hours. (Repeat caller duration is based on callstartdate and prevcallsegstartdate as per the example provided)

    Formula: Numerator - Unique Contact , Denominator - Unique + Repeat Contact

    CustomerPhoneCallIDCallstartdateCallenddateprevcallstartdaterepeatcalldurationSecs
    123Call12020-06-08 11:13:05.0002020-06-08 11:28:48.000NULLNULL
    123Call22020-06-08 11:39:35.0002020-06-08 11:50:23.0002020-06-08 11:13:05.0001590
    123Call32020-06-11 15:24:07.0002020-06-11 15:33:56.0002020-06-08 11:39:35.000272672
    126Call122020-03-22 14:40:49.0002020-03-22 15:09:42.000NULLNULL

    From the above example -
    In the case of 123 phone number (1-2 row number) - its a repeat contact.
    This customer contacted twice within 48 hours based on the first two rows

    Now in the numerator - it should be 0
    in the denominator - it should be 2

    3rd row - again the same customer contacted after 48 hours, it should treat as a new customer
    Now numerator - 1 and denominator - 1

    In the case of 126 customer phone number - its unique contact
    Now numerator - 1
    denominator - 1

    Total KPI value - Numerator - 0+1+1
    Denominator - 2+1+1

    Can someone help me how to achieve this in QV scripting?

    Thanks

    Show Less
  • forum

    New to Qlik Sense

    Value list dimension for multi kpi, change formatting

    Hi. I have a multi kpi and I'm using a value list for the dimension. In the measures, I have specific calculations for each valuelist item, but I was ... Show More

    Hi. 

    I have a multi kpi and I'm using a value list for the dimension. In the measures, I have specific calculations for each valuelist item, but I was wondering if it is possible to set a different format pattern for one of them because I have a ratio field that is 0.56 but it rounds to 1.

    Show Less
  • forum

    Qlik Public Sector Group

    The DoD and U.S. Census Bureau Turn to Data Lakes for Modernization and Greater ...

    Government agencies are continually looking to unearth greater insights from their mass amounts of data, and this is why those in the public sector ar... Show More

    Government agencies are continually looking to unearth greater insights from their mass amounts of data, and this is why those in the public sector are integrating data lakes as part of their IT initiatives. Holding both structured and raw information, data lakes allow agencies, like the Department of Defense (DoD), to better use data as a strategic asset.

    Read more.

    Show Less
  • forum

    Qlik Catalog Discussions

    QVD Import Error during connection setup

    Hi Community,When i try configure QVD Import , for Default QVD Mount Point * to QVD mount point then i am getting below error×Error! "pgui.error.code.... Show More

    Hi Community,

    When i try configure QVD Import , for Default QVD Mount Point * to QVD mount point then i am getting below error

    ×Error! "pgui.error.code.LOCALFILE_INVALID_DIRECTORY - Invalid path. Directory path should start with '/usr/local/qdc/sources'"

     

    Also i see "User does not have /qvd-share/NGAPT/4_QVD directory access" so which user access need to check?

    Can you please help me if anyone has face same issue during setup.

     

    Thanks,
    Akshaye

    Show Less
  • forum

    Qlik Sense Deployment & Management

    Timeouts periods in the QSE license service when access to Internet is lost for ...

    Greetings!We recently ran into a situation at a customer site that we can't understand.  The customer is running a single node, on-prem QSE June 2020 ... Show More

    Greetings!

    We recently ran into a situation at a customer site that we can't understand.  The customer is running a single node, on-prem QSE June 2020 SR3 site and its SLK has been applied for quite some time (several months).  Suddenly this week, the Qlik users began getting a pop-up message indicating that "You can not use Qlik Sense because you have no access pass".    We get a support call, review all the usual suspects in the QMC and everything seems fine.  While we are working on the case, one of the customer's developers tries to navigate from the QSE server to an external web site and realizes that there is an Internet navigation problem, he calls his network support people and they fix the problem.  Just after this is done, the Qlik Sense error pop-up ceases to appear and everything goes back to normal.

    The customer is working from an internal network and clearly has connectivity to the QSE server.  After investigating we found out that there was an unplanned major event in their data center last week, so we assume that the Internet connectivity was lost at this point in time, but we are not 100% sure.  In any case, if the event last week was really the cause for the lack of connectivity, the time since then is much less than the 60 days in which the license service can supposedly work offline.  So, we have a few questions:

    1. Do anyone have any idea of why QSE could have gone through this process with only a few days with lack of Internet connectivity?;
    2. Is there another timer for "intermittent" offline scenarios after the SLK is fully in use that we (partners) are not aware of?; and,
    3. Is there anything that we could look for in the logs to find out exactly when the license service stopped being able to reach license.qlikcloud.com? 

    We just want to understand why the pop-up appeared and then disappeared with less than a week between the two events described.

    @Sonja_Bauernfeind, any ideas?

    Cheers,

    ++José

    Show Less
  • forum

    QlikView App Development

    Interpreting Below Function

    HI,Can someone explain how and where below is used with the second parameter like below(sum(sales),3,2)I understand below(sum(sales),3), but what does... Show More

    HI,

    Can someone explain how and where below is used with the second parameter like below(sum(sales),3,2)

    I understand below(sum(sales),3), but what does the next parameter 2 do ?

    Show Less
  • forum

    New to Qlik Sense

    Stuck: App level management and stream access

    Hi, I am trying to only show some apps from certain users within a stream.  I have followed the videos and read the other community posts on this topi... Show More

    Hi, I am trying to only show some apps from certain users within a stream.  I have followed the videos and read the other community posts on this topic.  Currently, I have two security rules to make this work.  One gives access to the stream if the user is apart of a custom property, SGroup and the stream is also apart of that property, SGroup. The second rule says if a user and app are apart of the custom property, SRole, then show the app.  

    I would like to find away to combine this with one security rule for less maintenance.  I have tried a few different solutions but can't seem to get it to work. I have disabled the Stream rule created by Qlik.  The way it behaves now is that if I disable the stream access rule I created, the user can no longer see the stream at all. 

    Stream access rule condition: ((user.@SRole=resource.@SGroup))

    App Level Mgt rule condition: 

    (
    resource.resourceType= "App"
    or resource.resourceType= "Steam"
    and resource.stream.HasPrivilege("read")
    and resource.@SRole = user.@SRole

    )
    or (
    resource.resourcetype = "App.object"
    and resource.published ="true"
    and resource.objectType != "app_appscript"
    and resource.objectType != "loadmodel"
    and resource.app.stream.HasPrivilege("read")

    )

     

    So I would like to be able to create this same result using only one custom property and one security rule. 

    Show Less
  • forum

    QlikView App Development

    Nested Sum(Aggr(Sum())) and match with Criteria

    Hi All,I have a scenario of calculating a Visit as Compliant based on the Categories (if matching criteria). But i am unable to do a nested sum or ove... Show More

    Hi All,

    I have a scenario of calculating a Visit as Compliant based on the Categories (if matching criteria). But i am unable to do a nested sum or overall count on below expression. Can you please guide and help me out.

    I will be very thankful to you.

     

    CRITERIA:

    Category-6 : 14

    Category-13: 10

     

     

    TRIED EXPRESSION:

    if(
    sum(aggr(sum({<Parameter={'OSA-1','OSA-2','OSA-3'},Store_Type={'Cosmetics'},Category={'Category-6'}>} Achieved), Storecode,Visit,Category))
    >=14,1,0)
    +
    if(
    sum(aggr(sum({<Parameter={'OSA-1','OSA-2','OSA-3'},Store_Type={'Cosmetics'},Category={'Category-13'}>} Achieved), Storecode,Visit,Category))
    >=10,1,0)

     

    DATA and RESULT I AM GETTING vs EXPECTED:

    OSA Data.jpg

    Show Less

Top Participants

Blogs

Qlik Community Manager Blog

Hear from the Qlik Community team about the latest platform enhancements for April and May 2020.

Blogs

Customer Success Blog

Read all about Qlik's Voice of the Customer program and Customer Success initiatives.

Blogs

Blogs

Hear directly from Qlik employees and stay current on the latest and greatest information about Qlik products.

Groups

Covid 19

We are bringing together people and resources in response to the pandemic of Coronavirus, aka COVID-19, aka SARS-CoV-2.

open to all

Groups

QlikView to Qlik Sense

Join the QlikView to Qlik Sense group and help you modernize your BI experience through adoption of Qlik Sense.

open to all

Groups

Qlik Healthcare

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

750+ Members

Events

Qlik Customers Share COVID-19 Supply Chain Strategies

Amazon Produce Network and Odyssey Logistics discuss how they’re using Qlik to help manage their operations during Covid 19

On Demand Webinar

Events

Events & Meetups

Virtual Meetups are now a possibility! With the impact of COVID-19, the Qlik Meetup network has expanded its support to include the ability to host your next Meetup online. Email QlikMeetups@qlik.com to get your virtual Meetup started!’


Events

Direct Relief Uses Qlik to Manage Its COVID-19 Supply Chain

Qlik can help you manage your supply chain risks during COVID‑19.The nonprofit organization, Direct Relief, uses Qlik’s Supply Chain solution to scale its delivery of medical supplies worldwide.

Available on Demand