Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
2,521 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 Qlik Sense

    define limits graphicaly manually

    Hi,  i would like find a way to define an upper/ower limit manually.Let the user, point and clic, point by point  to define a line. As ... Show More

    Hi, 

     

    i would like find a way to define an upper/ower limit manually.

    Let the user, point and clic, point by point  to define a line. As far as i looked for, i didn't find any extension for that kind of functionnality.  

    Anyone got an hint ?

    Show Less
  • New to Qlik Sense

    Import Variables from Excel and assign to client advisor

    Hi,I imported variables from Excel into Qlik Sense Script, but it can't be assigned to a client advisor. How can I do it?In Script I have following:Ex... Show More

    Hi,

    I imported variables from Excel into Qlik Sense Script, but it can't be assigned to a client advisor. How can I do it?

    In Script I have following:

    Expressions:
    LOAD
    Variable,
    Expression,
    Comment
    FROM [lib://Mapping/Mastertable_Variabl.xlsx]
    (ooxml, embedded labels, table is Tabelle1);

    Let vNumberOfRows = NoOfRows('Expressions');
    For vI = 0 to (vNumberOfRows - 1)
    Let vVariable_Name = Peek('Variable',vI,'Expression');
    Let [$(vVariable_Name)] = Peek('Expression',vI,'Expression');
    Next

     

    And the Table is:

    VariableExpressionComment

     

    The variable import is working, but when i want the variable by client advisor it calculate for each the same value.

    Any idea?

    Show Less
  • Qlik Sense App Development

    Max function with limited selection

    Hi all,I have a set of 2 year's data and i want to calculated a daily price range. I use max(rate)-min(rate) in a table also with other two dimension ... Show More

    Hi all,

    I have a set of 2 year's data and i want to calculated a daily price range. I use max(rate)-min(rate) in a table also with other two dimension currency pair and client.  I want the max and min only reflect its daily range when i select a date but calculated a cross all client. An example will be  when i select a client, a date and a currency pair, the max() returns the max number for the day, for the currency pair but across all client. 

    I tried Max( total < currencyPair > rate), which gives the correct result as long as i only select date. I want also be able filter the client. Can nay one hlep me with it?

    Thanks!

    Show Less
  • Qlik Education Discussions

    Set Analysis intersection in the same field

    Hello everyone,This is a glimpse of my dataset:I want to make a table within my app with set analysis to show what rows are the same for different mon... Show More

    Hello everyone,

    This is a glimpse of my dataset:

    clipboard_image_1.png

    I want to make a table within my app with set analysis to show what rows are the same for different months, but in a way that always compares current month with previous month, and also current month with a month before previous month. 

     

    Basically I want to see the intersection between months, but since my table is updated monthly, I always need to compare current month with others, and I want to do so without specifically naming every month.

    If I need to clarify more, please ask.

    Thanks in advance.

    Regards,

    Milos

    Show Less
  • Qlik Sense App Development

    Generate month and year fields for a data set that don't contain date fields

    Hi,I have create an app using qlik sense. The source data is excel files and every file represent one month. So I get every month an excel file to loa... Show More

    Hi,

    I have create an app using qlik sense. The source data is excel files and every file represent one month. So I get every month an excel file to load it. All the files have the same structure, so I use the following approach:

    Table:
        Load
            A,
            B,
            C,
            D,
    FROM [lib://AttachedFiles/Jan2019.xlsx]
    (ooxml, embedded labels, table is Sheet1);

    Concatenate Load
            A,
            B,
            C,
            D,
    FROM [lib://AttachedFiles/Feb2019.xlsx]
    (ooxml, embedded labels, table is Sheet1);

    .....

    How can I dedicate the month and the year while there is no field can be used as date.

    I think it can be solve by generating a number field in every file and use it as month:

    Table:
        Load

    Month,A,B,C,D
    1,name,surname,country,city
    1,name,surname,country,city
    1,name,surname,country,city


    FROM [lib://AttachedFiles/Jan2019.xlsx]
    (ooxml, embedded labels, table is Sheet1);

    Concatenate Load


    Month,A,B,C,D
    2,name,surname,country,city
    2,name,surname,country,city
    2,name,surname,country,city


    FROM [lib://AttachedFiles/Feb2019.xlsx]
    (ooxml, embedded labels, table is Sheet1);

    .....

    but i don't know how to achieve this in the script while there is too much rows. And how it could be generated automatically every month.

    Thanks in advance   

     

    Show Less
  • New to QlikView

    count distinct id if value equel 0/zero for the last 5 years

    Hi all,I have tried searching the forum but do not seem to be able to find a solution that solves my problem.I have a data set like the on attached.Wh... Show More

    Hi all,

    I have tried searching the forum but do not seem to be able to find a solution that solves my problem.

    I have a data set like the on attached.

    What i need is a expression that count the ids, that for the last 5 years have acc_int = 0 (for all the years), to be used text box

    Can you help?

    thanks

    schibler

     

     
     
    Show Less
  • Qlik Sense Deployment & Management

    Qlik Sense architecture Issue

    Hello, i have some issues. Qlik Sense (QMC and HUB) no longer loads extensions or images + access problems on a lot of apps. Errors of ... Show More

    Hello, 

    i have some issues. Qlik Sense (QMC and HUB) no longer loads extensions or images + access problems on a lot of apps. 

    Errors of this type on many applications and for everyone

    How can i resolve this please ?

    Found attached the errors

    Show Less
  • QlikView Deployment

    How to count without null (null value in datetime)

    Hi can someone help me to figure out this = If(Len(Trim(allconvoyear))=0, Null(),count({<allstatus={'TAMAT PENGAJIAN','BELUM BERKONVOKESYEN'},... Show More

    Hi can someone help me to figure out this

     

    = If(Len(Trim(allconvoyear))=0, Null(),count({<allstatus={'TAMAT PENGAJIAN','BELUM BERKONVOKESYEN'},eduPersonAffiliation={'Sarjana Muda','Doktor Falsafah','Diploma Lepasan Ijazah','Sarjana'}>}allmatric_no))

     

     

    i dont want to count null value for allconvoyear because in my graph the convoyear null value is showing the null value 9k++

     

    clipboard_image_0.png

     

    clipboard_image_1.png

    Show Less
  • Qlik Sense App Development

    I need to create 2 calculated columns using ranking from multiple columns

    I have the following table:Service NameJanRank in JanFebRank in FebMarRank in MarAprRank in AprRanking CounterLatest Month of RankingABC51021446754027... Show More

    I have the following table:

    Service NameJanRank in JanFebRank in FebMarRank in MarAprRank in AprRanking CounterLatest Month of Ranking
    ABC510214467540272457194Apr
    BDE289424767137544561214Apr
    DGE463734632237306551734Apr
    GFH459844591337415553124Apr
    .................................
    DJE437893554153133173123293Mar
    KIJ4234103987283322123481262Mar

     

    I have used Rank() in order to rank the number of tickets in  each month

    Ex: since service ABC is having the highest no of tickets in Jan, it has rank 1 (Rank in jan). However the same service is in Rank 5 in Feb.. and so on.

     

    I need a formula to calculate the last 2 columns...

    If a particular service name is having a rank(<=20) in all the months, ranking counter must show 4 and the column named "latest month of ranking" would be Apr.

    (Since that particular service falls under top 20 in all the months and the latest month being Apr)

     

    Similarly, for service name KIJ, it has been in top 20 for 2 out of 4 months (jan and mar), thus the ranking counter must show 2 and the latest month would be Mar.

    This calculation must be made dynamic whenever i  obtain the future month's data. i.e.. Next month i would get May data and create a column -- Rank in May.

    At this point, the "ranking counter" and "latest month of ranking" must automatically reflect with the new changes.

     

    Is there a feasible solution for this requirement?

     

    Show Less
  • New to Qlik Sense

    How to connect Qlik sense to an access database

    Hello, I try to connect Qlik sense desktop to an existing database.I tried by ODBC and OLEDB and I always have the same problem :I can connect to... Show More

    Hello, 

    I try to connect Qlik sense desktop to an existing database.

    I tried by ODBC and OLEDB and I always have the same problem :I can connect to the database, see the Tables names but it doesn't load any value/columns... It stays empty... An idea to help ?

    I tried with OLEDB, ODBC 32 bits, ODBC 64 bits, maybe there is a problem with the DNS

    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