Qlik Community

Welcome to Qlik Community

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

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


Challenge the status quo

See why Qlik (Attunity) is recognized in the 2019 Gartner Magic Quadrant for Data Integration Tools.

Recent Discussions

  • New to QlikView

    Calculo Intervalos de datas diferente do filtro de competência

    Olá pessoal só novato no qlikview e gostaria de saber se é possível realizar um cálculo de um período filtrando outro.Exemplo quando eu seleciono a co... Show More

    Olá pessoal só novato no qlikview e gostaria de saber se é possível realizar um cálculo de um período filtrando outro.

    Exemplo quando eu seleciono a competência do mês de agosto/2019 ela apresenta os dados de agosto / 2019 ok, porem eu preciso que ele utilize a competência selecionada e menos sessenta dias e mostrar todos os valores, como se o período tivesse noventa dias deverá mostrar os dados de 16/05/2019 a 14/08/2019.

    Inicio da competência = 15/07/2019
    Fim da Competência = 14/08/2019
    Limite para soma = 16/05/2019

    Show Less
  • QlikView Layout & Visualizations

    Need to find and clear "Always One Selected" or other limiting function.

    As implemented as a server Web Dashboard, the "Always One Selected" features seems to be enabled.  At one time this was a desired feature and now... Show More

    As implemented as a server Web Dashboard, the "Always One Selected" features seems to be enabled.  At one time this was a desired feature and now it is not desired.  There are 10 sheets.  ...One Seletected... is related to a Date column.  Each sheet has been investigated for having the 'box checked' and none were found.  The forced selection is only active in the server Web Dashboard instance.  In the Qlikview instance in development or WebView the forced one selected function is not active.

    (I do know that the Always One Selected selection is grey and only available when one is selected)

    Is there a way to search / find what sheet and object might be driving ...one selected...? 

    Is there another method to drive ...one selected... that I might search and attempt to clear function?  

    Might there be a conflict between the local version and dashboard version that needs to be addressed?

    Show Less
  • New to Qlik Sense

    Licenses Need to Embedded and Create Mashups

    Hi to all!!!!I will like to start working with Embedded Charts / Graphs with Qlik Sense Desktop. The purpose is to send and update data into clients w... Show More

    Hi to all!!!!

    I will like to start working with Embedded Charts / Graphs with Qlik Sense Desktop. The purpose is to send and update data into clients webpages and intranet portals.

    I will like to know what licenses do I need to have and to understand the procedure to be able to embedded and create mash ups for clients.

    When I get the link from a graph or table from Qlik sense Desktop do I need another license to be able to embedded this chart or graph into a client page or intra net?

    When I get the link from a graph or table from Qlik sense desktop where does the info is store? Do I need to buy or get a different license so once I close the Qlik sense desktop the table or graph remain "active" on the web?

    To create mash ups do I need a license different than Qlik Sense Desktop? Is it possible to create those with Qlik sense business cloud?

     

     

     

    Show Less
  • New to Qlik Sense

    Functions firstsortedvalue and aggr

    Dear all, I have been battling with this problem for many days now and would like to ask for some help on how to solve. I have a table of data wh... Show More

    Dear all, I have been battling with this problem for many days now and would like to ask for some help on how to solve.

     

    I have a table of data which contains the costs of products depending on the date I bought them :

    DateItemCost
    01/01/2019A1
    01/02/2019A2
    01/03/2019A3
    01/02/2019B6
    01/05/2019B9
    01/07/2019B3
    01/04/2019C5
    01/05/2019C7
    01/06/2019C5

     

     

    I am trying to create a table to show the costs of the products showing the price of the first buy and the last buy of each one of them:   

     

    ItemInitial CostFinal Cost
    A13
    B63
    C55

     

    I am trying to use this two functions ( FirstSortedValue and aggr) but it won´t work for me, I would need some help.

    This is an example of how I am using the functions:

    FirstSortedValue( distinct Cost, aggr(Max(  Cost), Item, Date),1) and FirstSortedValue( distinct Cost, -aggr(Max(  Cost), Item, Date),1)

    But it won´t give me the first and last value, It gives me tha maximun and minimun values.

    Thank you very much in advance, I hope you can give me some assistance with this.

     

    Show Less
  • Qlik Sense App Development

    STORE Only Section-AccessED Rows

    I am given a large (3.6gb) binary which includes data from all over the world and has around 57 tables. A section access is applied for a column in on... Show More

    I am given a large (3.6gb) binary which includes data from all over the world and has around 57 tables. A section access is applied for a column in one of the 57 tables resulting me and my fellow countrymen only being able to work on rows relevant for my country (e.g. Malaysia).

    I am trying to export all these tables into QVDs by performing a series of STOREs for each of the 57 resident tables  into individual QVDs. However, the resulting QVDs are still that of the global binary (3.6gb). From there, I will load back the QVDs and the use app's resulting binary for downstream country-specific apps.

    Is there a way to export into QVDs only the rows that Section Access allows me to?

    I could perform a WHERE filter on the particular resident table with the country column but that would also require me to understand the complex join conditions across all the 57 tables for me to perform the subsequent INNER KEEPs.

    Show Less
  • Qlik Sense App Development

    Error: Access Denied

    Hi everyone,I am using the enterprise version of Qlik Sense and from time to time, when I am working on the published application,  appears sudde... Show More

    Hi everyone,

    I am using the enterprise version of Qlik Sense and from time to time, when I am working on the published application,  appears suddenly the error : "An error has occured. Access denied" and after I click on the close button, I can continue working on the sheet I was previously working, but some information might be missing, such as words or numbers. 

    Does anyone know, why is this happening?

    Thanks in advance.

    Regards,

    Ellie

    Show Less
  • New to Qlik Sense

    Static Trend Line - Sales Goal

    I am trying to add a trend line to a combo chart showing monthly sales compared to an annual sales goal. The value of the annual sales goal is a stati... Show More

    I am trying to add a trend line to a combo chart showing monthly sales compared to an annual sales goal. The value of the annual sales goal is a static value (i.e. Annual Sales Goal = $120) and therefore should start at $0 then increase by a value of $10 for each month throughout the year.  I have reviewed the forum comments regarding calculated trend lines but none appeared to address the static need. Any offers of assistance would be greatly appreciated.

    clipboard_image_0.png

    Show Less
  • QlikView Publisher

    QVDS performance and QMSChunkSize

    I wanted to share my ‘ChunkSize’ experience in case it helps someone at some point in the future. I’m running QV11 SR2 and called support with a corru... Show More

    I wanted to share my ‘ChunkSize’ experience in case it helps someone at some point in the future. I’m running QV11 SR2 and called support with a corrupted QVPR. They helped me restore it, and noticed that my ‘ChunkSize’ was set to 100. They asked me to set the value to 20 and we ended the call (after restarting services). I noticed that night that my QVDS tasks all ran much slower – about 5x slower – than normal. I contacted support the next day and they reset the value back to 100. After a restart everything was back to normal again. The chunk size was the only system change that happened, and I’m certain it caused the performance hit.

    ChunkSize can be found in the QV Management Service Config file:

    C:\Program Files\QlikView\Management Service\QVManagementService.exe.config

        <add key="QMSChunkSize" value="100"/>

    Support said the version prior to mine (I won’t assume they mean QV11 SR1) had some issues with the chunk size being set high, so the solution was to lower it. This is why they told me to set it at 20. After I noticed my issues they asked around and found that my version was reported to work better with a larger setting (100).

    Apparently the QVDS and the QVMS communicate via something called a work order (XML based perhaps?). The chunk size is the size of this message.

    I figured I would share since I couldn’t find anything online about this setting.

    Show Less
  • QlikView Scripting

    not changing value in text box after choose any date field

    Hi Guys, I'm working on a sales report on qlikview dashboard. I calculate average sales value upto previous month. it's working. But I want to fixed t... Show More

    Hi Guys, I'm working on a sales report on qlikview dashboard. I calculate average sales value upto previous month. it's working. But I want to fixed the value in the text box but that's not working. When I choose date or month from the field the average value is changed but I don't want any effect for the average value in the text box. I use a set analysis in the equation. Here is the equation:

    =num((Sum({<Month-=,Mday-=,Month-={"$(=vCurrentMonth)"},Year={"$(=vCurrentYear)"}>}Gross_Value)/
    (count(distinct {<Month-=,Mday-=>} Month)-1))/1000000,'###0.0')

    where, vCurrentMonth=2019

    Please help me ASAP, Thanks.

    Show Less
  • Qlik Sense App Development

    section access - cannot get past this error

    Posted this in a different forum but no luck there. Hoping this is another place to ask my question regarding section access.I was able to get my sect... Show More

    Posted this in a different forum but no luck there. Hoping this is another place to ask my question regarding section access.

    I was able to get my section access to be working perfectly fine through all the great help received from this forum. Now, we decided to store our users in a separate table in our database and decided to pull the data from the db vs. doing an inline in the script. 

    --------------- my script -------------

    SECTION ACCESS;

    LIB CONNECT TO ***

     


    LOAD * INLINE [

    ACCESS, USER_ID, ACCESS_ID
    ADMIN, domain\andrew, 
    USER, domain\dummyuser, 1
    ADMIN, INTERNAL\SA_SCHEDULER,*,
    ];


    SECTION APPLICATION;


    LOAD * INLINE [

    ACCESS_ID, DEPARTMENT

    1, MARKETING

    2, FINANCE

    3, ACCOUNTING

    4, IT

    5, Other

    ];

    ---------- end --------------

    Pretty much I am making the user "dummy" to only see the value 1 which is Marketing data only. This works fine. Once I brought in the same table but through the database (which stores the exact same data, except I had to create an additional column since an * is considered a varchar).

    This shouldn't change anything but please correct me if I am wrong. But upon running the script this is the constant error I get and cannot get past this error. I tried reverting the script to go against the inline and am still getting an error for the script that was once working. I'm a bit lost and reaching out for some additional help or anything you guys may see that I am missing.

    error - 

    Access was denied after reload. Check that the user that reloads the script is included in the section access part of the script.
     

    Thanks a bunch.

    Show Less

Blogs

Qlik Community Manager Blogs

Hear from the Qlik Community team about the latest platform enhancements, announcements, and more.

Blogs

Qlik Education Blog

Check out the latest Education Blog written by Kevin Hanegan,Qlik Chief Learning Officer.

Blogs

Blogs

Hear directly from Qlik employees and stay current on the latest and greatest information about Qlik products. We have 8 blog types for you to choose from.

Groups

Join a Group

Join one of our Qlik Community user groups around an Industry, Location & Language, or Topic.

Groups

Qlik Deployment Framework

This group hosts information related to the Qlik Deployment Framework (QDF).

2700+ Members

Groups

Qlik Healthcare

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

750+ Members
Sue_Stage : List Private Messages : Sign out : Switch user COMMUNITY Qlik Community Settings for: Community Qlik Community ChooseGo to Community ADMIN STUDIO TOOLBOX DISCUSSION STYLES FEATURES SYSTEM DISPLAY CONTENT USERS MOD TOOLS METRICS COMMUNITY STRUCTURE Search for settings Announcements Custom Content Custom Pages ActiveCast Featured Threads Promoted Search Select Custom Content Setting Event Card event-card Custom Content 7 Text

Events

Qlik Insider Webinar Series

What's New in 2019. Register for the Qlik Insider Webinar Series to stay connected on our latest releases

Available On Demand Webinar

Events

Events & Meetups

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

Events

Welcome to Qlik

Join the “Welcome to Qlik” webinar and learn about the Qlik Ecosystem

Tuesday, August 27, 2019 Webinar
Show help for this page