Qlik Community

Welcome to Qlik Community

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

  • Qlik Sense App Development

    Best practices for performance?

    I am wondering which scenario has the better performance in each of the pairs below.  The metric I am most interested in is visualization renderi... Show More

    I am wondering which scenario has the better performance in each of the pairs below.  The metric I am most interested in is visualization rendering time, both initially and in response to user selections.  I'm less concerned with memory consumption or load-script duration.

     

    Measure = Sum(FieldA) * 1000  // 1. Aggregate first
    Measure = Sum(FieldA * 1000)  // 2. Aggregate last
    
    Measure = Sum(FieldA + FieldB)       // 1. Aggregate last
    Measure = Sum(FieldA) + Sum(FieldB)  // 2. Aggregate first
    
    NewField = FieldA * 1000  // 1. Make another field while loading data
    Variable = FieldA * 1000  // 2. Make a variable instead using "Set var = ...;"
    
    NewField = FieldA + FieldB  // 1. Make another field while loading data
    Variable = FieldA + FieldB  // 2. Make a variable instead using "Set var = ...;"

     

    In each case, I put the option that I think should result in more responsive visualizations first, but I don't have the empirical data or knowledge of what's under the hood to back it up.  I don't know 1) how the data is physically arranged in memory, 2) whether Qlik executes formulas as is or rearranges them for efficiency like SQL query optimizers, or 3) whether things like caching or preloading come into play.

    Show Less
  • QlikView App Development

    Big table - qlik desktop crashes PC - CPU usage 100 %

    Hi,I'm a new user of Qlik and it seems that it suits perfectly my needs !But I experience a bug really anoying that prevents me from using Qlik deskto... Show More

    Hi,

    I'm a new user of Qlik and it seems that it suits perfectly my needs !

    But I experience a bug really anoying that prevents me from using Qlik desktop : I loaded a big fact table (7 millions rows) with 3 small dimensions and 2 quite big (time and geography), from postgresql.

    When I tested with a filtered database (loaded it with filter to have only few rows, like 20k or so), it worked nice and I created the app i wanted.

    When I tried to do the same with the complete database (new app created), it loads, but quickly after that, when I edit sheets or else in app, Qlik starts using 100 % of my CPU and RAM and freezes PC so much I can't even move my mouse and kill the software : I have to reboot my PC.

    It seems that it happens to some other users (see that post), but it's an old post. Is there any solution now about this ? Frankly, with that bug, Qlik is useless for me, as I plan to work on several databases of that type…

    Thanks in advance !

    Show Less
  • New to Qlik Sense

    Calculate median, IQR, and min/max from count by group

    Hello:I would like to calculate median, the IQR (25%, 75%), and min and max  of a count of values, by group. See example table below:Input TableG... Show More

    Hello:

    I would like to calculate median, the IQR (25%, 75%), and min and max  of a count of values, by group. See example table below:

    Input Table
    GroupID_Unique
    A1
    A2
    A+B3
    B4
    C+A5

     

    The desired output will be in pivot table, structure as follows:

    Desired Output     
    GroupCount(ID_Unique)Median(Count(ID_Unique))Fractile(Count(ID_Unique), 0.25)Fractile(Count(ID_Unique), 0.75)Mix(Count(ID_Unique))Max(Count(ID_Unique))
    A2     
    B1     
    A+B1     
    C+A1     

     

    I have spent a lot of time trying to figure how to calculate median/fractile (IQR) values from a count - I can't seem to figure this out.

    Any help would be greatly appreciated.

    Thank you,

    Sin

    Show Less
  • Qlik Sense App Development

    Background Layer not rendering

    Hi all,I need some help with background layer TMS maps in Qlik Sense.A colleage has created an awesome floorplan of our company, and has collected sen... Show More

    Hi all,

    I need some help with background layer TMS maps in Qlik Sense.

    A colleage has created an awesome floorplan of our company, and has collected sensor data related to meeting room activity.

    I am now trying to figure out why the background layer TMS map is super inconstant, sometimes the background layer appears and it looks fantastic, and other times the tiles just are blank surrounded by red lines, seems like the map does not render (see attachment).

    I have checked that the files are located on the Qlik Sense server correctly and that the TMS URL String is correctly formated with the ${z}_${y}_${x}.png. It all looks fine.

    Where am I going wrong? I have been looking through Qlik Support and googled like a crazy person, however no luck so far. All help is appreciated 🙂

    Show Less
  • New to Qlik Sense

    NETWORK DAYS WITH NEGATIVE CONDITIONAL

    Good morning,I have a problem with a conditional format applied to the function network days. The formula is :Count(distinct{$<[SUBJECT]={"=Ne... Show More

    Good morning,

    I have a problem with a conditional format applied to the function network days.

     

    The formula is :

    Count(distinct{$<[SUBJECT]={"=Networkdays([DATE_A],[DATE_B])>7"}>}[SUBJECT])
    //=NetWorkDays(YearStart(Today()), yearEnd(Today()))

     

    The expectation of this formula is to count:

    the times in which the number of days between these two fields is major of seven (without considering saturdays and sundays)

    The problem I have occurs when I want to apply to this formula =0 or <0, instead of >7

    For example:

    Count(distinct{$<[SUBJECT]={"=Networkdays([DATE_A],[DATE_B])<0"}>}[SUBJECT])
    //=NetWorkDays(YearStart(Today()), yearEnd(Today()))

     

     

    For =0 i have a result but not sure is correct

    for <0 the result is zero.

     

     

    Is anyone can help me with this formula?

     

    Thanks a lot for your support.

    Show Less
  • New to Qlik Sense

    Join columns from different tables based on criterias.

    Hi! I have a task where the end goal is to get a table where i see, for each sale order;  either if it is an online order or who is the salespers... Show More

    Hi! I have a task where the end goal is to get a table where i see, for each sale order;  either if it is an online order or who is the salesperson. The store sells online and directly (salesperson). I want the final table to look like this:

    (example)
    OrderID ---ResponsibleForSale

    41424        John Johnson

    12443        Online sales


    I have one document, salesorders, where I have the Order IDs. In this document I also have a flag which is 1 if it is a online sale. This document is connected to territoryhistory-document through territoryID. The territory-document is then connected to the employee-doc through employeeID. In this doc we have the Salespersons name. If the employee is a salesperson the employee allways have employee ID above 273.


    I tried with this script below, but it doesn´t work yet. (So the goal is; if onlineflag=1 - then write "online  sales" on that order-number row. If onlineflag=0 and employee ID > 273 (so it is a salesperson). Then write the sale persons name. Think about that they are not directly connected but connected through 1 doc in between. 

     

    RepresentationList:

    LOAD
    SalesOrderID,
    OrderDate,
    OnlineOrderFlag,
    TerritoryID,
    IF(OnlineOrderFlag=1,'Online Sales', 0) as OrderFrom

    FROM [lib://QVD/SalesOrderHeader.qvd]
    (qvd);

    Inner Join


    Table2:
    LOAD
    BusinessEntityID,
    TerritoryID
    FROM [lib://QVD/SalesTerritoryHistory.qvd]
    (qvd)

    where Exists(TerritoryID,TerritoryID);

    Inner Join

    Table3:

    LOAD
    EmployeeBusinessEntityID,
    IF(EmployeeBusinessEntityID>273 AND OnlineOrderFlag=0,EmergencyContactName,OrderFrom) as ListForSalesResp
    FROM [lib://QVD/Employee.qvd]
    (qvd)
    Where Exists(BusinessEntityID,EmployeeBusinessEntityID);

     

     

     

     

    Show Less
  • QlikView App Development

    Chart hide show based on latest selected field (Not selected field value)

    Hi, PFA qvw file with 3 fields and 3 text boxes. I need to hide show these text boxes when field values are selected, but if the last selection is on ... Show More

    Hi, PFA qvw file with 3 fields and 3 text boxes. I need to hide show these text boxes when field values are selected, but if the last selection is on 2nd field only 2nd text box should be shown the other two should be hidden.  Like i have FieldA, FieldR, FieldT with respective text boxes. When i select a value in FieldR, R text box should show, if i select FieldA, FieldA text box should show and R textbox should be hidden and so on. So this is based on last selection made on specific field. 

    Any help much appreciate it. 

    @sunny_talwar @swuehl 

    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
  • 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

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.