Qlik Community

Welcome to Qlik Community

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

    switch name field in Master items -> Dimensions

    Hi to all.Is there a possibility to confiugre the name field in "Master items" -> "Dimensions" (Qlik Desktop in Version June 2019)with variables so... Show More

    Hi to all.

    Is there a possibility to confiugre the name field in "Master items" -> "Dimensions" (Qlik Desktop in Version June 2019)
    with variables so that the field name switches according to set parameters?

    Thanxs for advice.

    andreascarlos

    Show Less
  • New to Qlik Sense

    Optimize Not Exists() Incremental Load

    Dear all,I'm trying to speedup an SAP incremental extraction of a very large table, the script i'm using is this:MSEG: LOAD *, MANDT&'|'&MBLN... Show More

    Dear all,

    I'm trying to speedup an SAP incremental extraction of a very large table, the script i'm using is this:

    MSEG:
    LOAD *,
    	MANDT&'|'&MBLNR&'|'&MJAHR&'|'&ZEILE as [%Key MSEG Incremental];
    SELECT *
    FROM MSEG
    	Where .... ;
    
    
    
    Concatenate(MSEG)
    Load *
    From MSEG.qvd (qvd)
    	where not Exists([%Key MSEG Incremental],MANDT&'|'&MBLNR&'|'&MJAHR&'|'&ZEILE);
    
    Drop field [%Key MSEG Incremental];
    
    
    Store MSEG into MSEG.qvd (qvd);

     

    The SAP select is quite fast and in a couple of minutes all new record are extracted, the problem is to concatenate old values with the new ones.

    To do this i'm using Not Exists() function by checking the concatenation of key fields of MSEG table.

    This last step required more than 30 minutes... is there a way to speedup this check step ?

     

    Show Less
  • QlikView App Development

    Qlikview Fast Change is not working

    I have created one QV report in which i have added one chart which shows data.In that chart properties i have tick fast change allowed type as: Pivot ... Show More

    I have created one QV report in which i have added one chart which shows data.

    In that chart properties i have tick fast change allowed type as: Pivot table and Straight table.

    My QV desktop version is 12. While selecting one dimension and one measure and changes the type,at that time it is not working.

    I have cre

    Can anyone help me out please?Because i am just stucked in it and couldn't find out the solution.

     

    Show Less
  • Qlik NPrinting Discussions

    Color text by forumula

    Hello, I need to put one value in powerpoint with Nprinting 18 in defining the text and color by value. Bu example, If the val>0, put ins... Show More

    Hello,

     

    I need to put one value in powerpoint with Nprinting 18 in defining the text and color by value.

     

    Bu example, If the val>0, put insteaf of val the text 'Positive' in green and If val<0, put insteaf of val the text texte 'Negative' in Red

     

    Thanks in advance for your help

    Show Less
  • New to Qlik Sense

    Configure Refresh data Qlik Sense Desktop

    Hi to all!!!Anyone knows if it´s possible to configure or use a function so an App refresh the data at especifc time every day?I´m using azure and is ... Show More

    Hi to all!!!

    Anyone knows if it´s possible to configure or use a function so an App refresh the data at especifc time every day?

    I´m using azure and is possible to open Qlik Sense at specific time but I have not been able to configure the app to refresh  / load the data

    Any help will be more than apreciate!!

    Show Less
  • New to Qlik Sense

    Field selection with set expression in toggle button

    I'm using the button for navigation extension and I want to toggle one field value. The idea is to select all the values below one limit. The limit is... Show More

    I'm using the button for navigation extension and I want to toggle one field value. The idea is to select all the values below one limit. The limit is simply

    avg(field1)+2*stdev(field1)

    I found out that 

    = '<= $(=92870)'

     works perfectly, but when I try to replace number with the limit like this

    ='<= $(=$(=avg(field1)+2*stdev(field1)))'

    the button stops working, even when the expression editor says everything is OK and even shows the correct limit exactly as when I wrote the number manually

    ok.png 

    Any idea why this doesn't work? 

    Show Less
  • Qlik Sense App Development

    qsVariable

    I am trying to use the qsVariable extension in other to allow the user to input (>digits) or l(< digits) then the visualization can be sorted ac... Show More

    I am trying to use the qsVariable extension in other to allow the user to input (>digits) or l(< digits) then the visualization can be sorted according to the value.

    Sum({$<Fact={$(#vSum)}>}Fact)

    i use the syntax above to create an app. however, it doesnot recognize the following symbols (< >)

    thank you.

    Show Less
  • New to Qlik Sense

    AddMonths for multiple values

    Hello!I have a statement: =Date(AddMonths(Date#((GetFieldSelections([Rok-Miesiąc], ', ', 99)), 'YY-MM'), -12), 'YY-MM')and it works if the end us... Show More

    Hello!

    I have a statement: 

    =Date(AddMonths(Date#((GetFieldSelections([Rok-Miesiąc], ', ', 99)), 'YY-MM'), -12), 'YY-MM')

    and it works if the end user picks only one date - e. g. if he picked 19-06 it prints out the 18-06 value.

    If he picks two or more dates it doesn't work, but the statement without AddMonths works perfectly - it prints all the values the user picked.

    Why the AddMonths works only for one value? How can I change the statement to make it work?

    I tried to use Concat, but it still doesn't work.

    Show Less
  • QlikView App Development

    limit drop down select list

    hi, is it possible to limit the drop down select list ( in straight table ) to a fix number of values , say 10 ?
  • New to Qlik Sense

    How to make the value shown in the chart not exceed the value of the Filter pane...

    How to make the value shown in the chart not exceed the value of the Filter pane? This problem has been bothering me for a long time. Please help... Show More

    How to make the value shown in the chart not exceed the value of the Filter pane? This problem has been bothering me for a long time. Please help me. Thank you.

    Note: A supplier has multiple transaction records.

    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.