Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
1,496 online

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.

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

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 eight unique blogs. Check out the new Architecture Deep Dive Blog!

Find a forum to ask a question or start a discussion.

Discussion Boards and Documents for Qlik Services.

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

Discussion board and documents related to Qlik Associative Big Data Index.

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.


WEBINAR SERIES: THE DX FILES

When disruption is nonstop, how do you compete – and thrive? Digital Transformation is a must, and data is at the heart of it. To pull ahead of the pack, stay in front of the trends, and keep pushing innovation further, you have to consistently reinvent your business – fast – with a modern approach to data. When it comes to Digital Transformation, the truth isn’t out there – it’s in here. Join us July 30 – August 28, 2019, for 5 tracks of insight-packed webinars.

Recent Discussions

  • New to Qlik Sense

    Connect Qlik to Oracle Opera on Cloud Database

    Dears, Has anyone experienced connecting Qlik to Oracle Opera on cloud database?What i know is that we cant access the database directly.Has anyone wo... Show More

    Dears,

    Has anyone experienced connecting Qlik to Oracle Opera on cloud database?

    What i know is that we cant access the database directly.

    Has anyone worked with such case before or can provide me with further assistance?

    Any help would be appreciated.

    Thank you

    rodrigue.saade

    Show Less
  • QlikView Scripting

    Convert ISO 8601 duration string to seconds

    I'm loading data that is formatted as ISO 8601 duration string.  Below are some samples from the data set. Each string always starts wi... Show More

    I'm loading data that is formatted as ISO 8601 duration string.  Below are some samples from the data set. 

    Each string always starts with "P," which designates Period, and "T" which designates Time.  The rest of the string  may contain H (Hours), M (Minutes) or S (Seconds) along with numbers for each time element.  

    For example, the string "PT1H3M11.312S" represents 1 hour, 3 minutes, 11.312 seconds, which translates to 3791 seconds.  

    Question: is there a script function that will convert an ISO 8601 duration string to seconds?  

    I'm hoping there is a function so that I won't have to parse out the time elements individually.

    Samples from my data:

    inboundTalkTime
    PT0S
    PT1H3M11.312S
    PT1H10M21.892S
    PT1H15M56.944S
    PT1H20M7.027S
    PT1H39M18.652S
    PT1H49M33.105S
    PT18M15.285S
    PT42M38.344S
    PT54M0.343S
    Show Less
  • QlikView Deployment

    Performance tuning: high unique number & remove a link table?

    Hi,I'm trying to tune a slow app (171m rows), complicated data model and complex script. Question 1: There are 2 fields with long ID numbers, the... Show More

    Hi,

    I'm trying to tune a slow app (171m rows), complicated data model and complex script. 

    Question 1: There are 2 fields with long ID numbers, they have high unique values. They are used in charts for count. Is autonumber() a good and safe way to go?

    Question 2: A link table linking fact table and dimension table, using an id field which has high unique values. This link table is 2nd largest table because of the id field. Not sure how to remove the link table. Do you have any suggestion how to tune it?

    BEst regards,

    Susan

    Show Less
  • Qlik Sense App Development

    Corrupt data

    I am developing an application in Qlik.I close my sesion of my computer with my application open and the next day I wanted to continue working on it w... Show More

    I am developing an application in Qlik.I close my sesion of my computer with my application open and the next day I wanted to continue working on it when suddenly I stop operating, I closed the app and I wanted to reopen and the message was "an error has occurred" Damaged data.

    How could I recover my application?

    Show Less
  • New to QlikView

    Counting columns with exception

    Hi, I am counting 2 columns A and B, Count( DISTINCT A&'|'&B)I want to exclude any cells with the word "ROM". Please help.
  • QlikView Deployment

    how to extract current fiscal year data

    I have 6 dimensions and 2 measures in the policy table. And have to create an adhoc report on that. Also need to show only current fiscal year da... Show More

    I have 6 dimensions and 2 measures in the policy table. And have to create an adhoc report on that. Also need to show only current fiscal year data in report. Please suggest senario for that.

    Show Less
  • New to QlikView

    Help with Count

    Hi Everyone, I need some help with using the count function and understanding it . PFA which explains the requirement. Thanks
  • QlikView App Development

    straight table should not change when selecting a value from list box...

    HiI have this strange functionality where i do not need to apply the filter for 1 of the list box when selected which i was able to get...but still wh... Show More

    Hi

    I have this strange functionality where i do not need to apply the filter for 1 of the list box when selected which i was able to get...but still when i select a value from It the stragiht table which has the list box field as dimension is changing its order

    and the selected value is showing up first in the stragiht table....is this something i can avoid

    to ignore the selected value i have this expression

    Sum({$<[Analyst Name]=,REDUCTION={"EQUITY"},Action={"Opened Report"}>} ReadCounter)

    This is an example of how it looks like in the file - how do i restrict the straight table from this behavior??

    Capture11.PNG

    Show Less
  • New to Qlik Sense

    How to retain user security rules when transitioning from Windows authentication...

     We've been using Windows/LDAP authentication for several years but are wanting to transition to Azure AD authentication using the approach outli... Show More

     

    We've been using Windows/LDAP authentication for several years but are wanting to transition to Azure AD authentication using the approach outlined in this tutorial.

    We've proved out this approach in a dev environment, but we're disappointed that in the process, new users are created, which means we'll lose all the security rules and license allocations for our existing users.

    See the attached screenshot showing my original user entry (Name: Ken Daniels; directory: CONTOSO) and the new user entry that was created after the first time I logged in using Azure AD (Name: ken.daniels@contoso.com; directory: AZURE). I had to manually assign my new user a role and a license allocation.

    Is there a straightforward way to retain our existing users, allocations, and security rules, or do we have to start all over from scratch?

    That's our primary concern. A secondary concern is that when setting up the Azure AD SSO/SAML authentication, we were required to define a prefix (we chose "sso"), which necessitated a change in url: whereas our previous url was https://qlik.contoso.com, it's now https://qlik.contoso.com/sso. This means all our direct links and bookmarks pointing to various sheets will be broken--not a pleasant experience. Is there any way to retain the original url after transitioning to Azure AD SSO?

    x.PNG

     

    Show Less
  • Qlik NPrinting Discussions

    How to repeat first level in every page of teh pixel perfect report?

    Hello,I am using Nprinting pixel perfect report to print profiles of employees. I have created Detail Report- emp id as my first level. In this level ... Show More

    Hello,

    I am using Nprinting pixel perfect report to print profiles of employees. I have created Detail Report- emp id as my first level. In this level I am populating emp name and few other objects. There are 4-5 more levels to populate tables after that.

    I want to repeat the contents (name etc) in Detail1 of level 1 to every page for an employee. Wanted to check if we can repeat teh contents of first level in page top for every page for an emp id.

    Show Less

Blogs

Qlik Community Blogs

Check out our community blogs to stay current on the latest and greatest information about Qlik products.

7 Blogs

Groups

Join a Group

Join one of our Qlik Community groups related to an Industry, Location, Language, or Topic.

28 Groups

Events

Events & Meetups

Participate in an upcoming Qlik related event, webinar, or local meetup.