Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
672 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.

Introducing Attunity


Introducing Attunity: Data Integration for Faster Time-to-Insight

The faster you can analyze your data, the sooner you uncover the insights that put you ahead. With the acquisition of Attunity, Qlik® is now providing an end-to-end platform not only for analyzing your data but also for acquiring it, managing it, integrating it, and streaming it to your analytics solution.

Recent Discussions

  • QlikView App Development

    Bundle Load Not Working Properly

    Hi,My bundle load script is not working properly. My script isBundleLOAD PlayerId,           ImageFROMD:\... Show More

    Hi,

    My bundle load script is not working properly. My script is

    Bundle

    LOAD PlayerId,

              Image

    FROM

    D:\Qlikview\DataSource\Data.xlsx

    (ooxml, embedded labels, table is Sheet3);

    Image Column is Path of Image Store location.

    When i reload this script Only PlayerId column will reloaded but image column is not.

    - Regards,

    Vishal Waghole

    Show Less
  • New to QlikView

    Data Islands and Set Analysis

    Hi,In my data model I have a date filed. I am using date Island to  and compare against the date in my data model. Using 'IF' I am getting d... Show More

    Hi,

    In my data model I have a date filed. I am using date Island to  and compare against the date in my data model. Using 'IF' I am getting desired results.  I need to compare two more conditions  in my expressions to calculate sums. Use if is slowing down all the calculations. I am trying to see if I can use set expression with date Island.

    The expression I am currently using is

    sum(if([Date]=IslandDate,Type ='Dispute',ChkFlag='Yes',1)) . Can I obtain the same with set expressions.

     

    Any help would be highly appreciated.

    Show Less
  • New to QlikView

    Data Islands and Set Analysis

    Hi,In my data model I have a date filed. I am using date Island to  and compare against the date in my data model. Using 'IF' I am getting d... Show More

    Hi,

    In my data model I have a date filed. I am using date Island to  and compare against the date in my data model. Using 'IF' I am getting desired results.  I need to compare two more conditions  in my expressions to calculate sums. Use if is slowing down all the calculations. I am trying to see if I can use set expression with date Island.

    The expression I am currently using is

    sum(if([Date]=IslandDate,Type ='Dispute',ChkFlag='Yes',1)) . Can I obtain the same with set expressions.

     

    Any help would be highly appreciated.

    Show Less
  • New to Qlik Sense

    Get the Top Value as a Dimension

    Hey guys,I have a table like this: OfficeRegionOrder-IDA110000A110001B110002B110003B110004A210005C210006C210007C210008A310009A310010B310011B41001... Show More

    Hey guys,

    I have a table like this: 

    OfficeRegionOrder-ID
    A110000
    A110001
    B110002
    B110003
    B110004
    A210005
    C210006
    C210007
    C210008
    A310009
    A310010
    B310011
    B410012
    B410013
    C410014
    C410015
    C410016
    C410017

     

    I want in to result as such:

    RegionTop-Office
    1B
    2C
    3A
    4B

     

    Based on the top number of orders per region. So Office B has the most orders in Region 1 and so on.

    I really want this as a dimension though since I want to use it for coloring a map later on and I have better possibilities when I use a dimenson

    Show Less
  • Qlik Sense App Development

    How to use set analysis to compare filtered and unfiltered data

    I am trying to list two numbers.  A. The amount of sales for SaleDate 2015 and B. The amount of credits with CreditDate in 2015.  I tho... Show More

    I am trying to list two numbers.  A. The amount of sales for SaleDate 2015 and B. The amount of credits with CreditDate in 2015.  I thought this would do it:  Sum( {1<CreditDate_RetailPeriod={SaleDate_RetailPeriod}>} CreditDet_NetSalesAmt), but that returns zero.  The idea is that I have a KPI which shows total sales and which the user may filter by SaleDate_RetailPeriod, but at the same time, I want to show total credits for the same retail period chosen by the user, but apply it to CreditDate instead of SaleDate and NOT show credits ONLY in the SaleDate period.  If I used two filters for the dates, that implies an AND, and I'm really looking for an OR on the two selections.

    Show Less
  • New to QlikView

    Debug mode is not opening in Qlikview Dashboard

    Hi  AllI am trying to open the dashboard in Debug mode but it is not opening and going back to UI only. Please suggest me what could be the reaso... Show More

    Hi  All

    I am trying to open the dashboard in Debug mode but it is not opening and going back to UI only. Please suggest me what could be the reason.

    Show Less
  • QlikView App Development

    Error while extracting data from MySQL database

    Dear All,I'm trying to extract data from MySQL database and I'm getting the below error.Error: SQL##f - SqlState: 08S01, ErrorCode: 2013, ErrorMsg: [M... Show More

    Dear All,

    I'm trying to extract data from MySQL database and I'm getting the below error.

    Error: SQL##f - SqlState: 08S01, ErrorCode: 2013, ErrorMsg: [MySQL][ODBC 5.3(w) Driver][mysqld-5.6.17]Lost connection to MySQL server during query

    The task was running fine and from last few days i am facing this issue.

    Does anyone come across this kind of situation.

    Thank you.

    Regards,

    Viresh

    Show Less
  • QlikView Scripting

    Transpose fields from one column of data

    Hi,I have a data set extracted from Active Directory with Logoff information of the users:The format of this file is:"This event is generated when a l... Show More

    Hi,

    I have a data set extracted from Active Directory with Logoff information of the users:

    The format of this file is:

    "This event is generated when a logon session is destroyed. It may be positively correlated with a logon event using the Logon ID value. Logon IDs are only unique between reboots on the same computer."""
    "Information,13/06/2019 00.00.20,Microsoft-Windows-Security-Auditing,4634,Logoff,""An account was logged off."

    Subject:
    " Security ID: SYSTEM"
    " Account Name: SYSTEM"
    " Account Domain: NT AUTHORITY"
    " Logon ID: 0x2BBE225A6"

    "Logon Type: 9"

    "This event is generated when a logon session is destroyed. It may be positively correlated with a logon event using the Logon ID value. Logon IDs are only unique between reboots on the same computer."""
    "Information,13/06/2019 00.00.20,Microsoft-Windows-Security-Auditing,4634,Logoff,""An account was logged off."

    Subject:
    " Security ID: SYSTEM"
    " Account Name: SYSTEM"
    " Account Domain: NT AUTHORITY"
    " Logon ID: 0x2BBE229D2"

    "Logon Type: 9

    repeated for each gorup of records (more than 500.000 rows, for only one day...), as per the attached sample (the original is .csv, but is not possible to upload it...):

    I need to obtain these fields in a flat file :

    TimeStamp, SecurityID, AccountName, AccountDomain, LogonID, LogonType

    13/06/2019 00.00.20,SYSTEM,SYSTEM,NT AUTHORITY,0x2BBE225A6,9

    13/06/2019 00.00.20,SYSTEM,SYSTEM,NT AUTHORITY,0x2BBE229D2,9

    in order to monitor all the accesses by the users.

    I tried with Transpose but this move ALL the rows to one line. What is needed is a Transpose limited to 8 rows each time a sort of a "reversed Crosstab", in order to create the a/m columns of fields, with the data, for each group of Records.

    Many thanks for your help.

    Best regards,

    Giulio

     

    Show Less
  • New to QlikView

    Average of Average at total level

    Hi,I am working on a graph where i have a bar and a line , one counts the transaction work done by a processor and the other one is sum(AvgProcessor) ... Show More

    Hi,

    I am working on a graph where i have a bar and a line , one counts the transaction work done by a processor and the other one is sum(AvgProcessor) which depicts the if a tower has 4 processor then on average 1/4 processor work on a transaction.

    Now when i see the total of avg processor based on Year it comes as average value not the total processor.

    How could this  be resolved in QLikview.

    Attached in the file for reference. Need quick guidance.

    Thanks in advance.

    Show Less
  • New to Qlik Sense

    categorising/grouping measure in scatter group

    Hi, I would like to categorize the revenue measure of the scatter graph to, 'below 500', 'between 500 to 999', 'between 1000 to 1499', 'above 150... Show More

    Hi, I would like to categorize the revenue measure of the scatter graph to, 'below 500', 'between 500 to 999', 'between 1000 to 1499', 'above 1500'. however, the following expression doesn't work.

    Aggr(Sum(if([Revenue]<=500, 'below 500',

    If([Revenue]>=500 and [Revenue}<=999, 'between 500 to 999',

    If([Revenue]>=1000 and [Revenue}<=1499, 'between 1000 to 1499',

    If([Revenue]>=1500, 'above 1500', 'Others'))))))

    Could any one find out what are the mistakes? Thanks!

     

    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.