Qlik Community

Ask a Question
Welcome to Qlik Community
cancel
Showing results for 
Search instead for 
Did you mean: 
1,813 online
Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY

Data Analytics

Forums for Qlik Data Analytics solutions. Ask questions, join discussions, find solutions, and access documentation and resources.

Data Integration

Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources

QlikWorld

This forum will provide you with event highlights and related content to get you energized and ready for QlikWorld Online.

Groups

Join a Group that is right for you and get more out of your collaborations. Some groups are closed. Closed Groups require approval to view and participate.

Qlik Gallery

Share your best Qlik apps and discuss impacts with peers! Show your work and get recognized for innovative uses of Qlik technologies.

Ideation

Participate in Qlik Technical Previews, submit ideas, and review documentation.

Qlik Resources

Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.

Events

Learn about upcoming Qlik related events, webinars and local meetups.

Blogs

Hear directly from Qlik employees in our ten unique blogs.

About

Get started, find How-To documents, and join general non-product related discussions.

Community Sitemap

Here you will find a list of all the Qlik Community forums.

Recent Discussions

  • No Boards Found
  • forum

    New to Qlik Sense

    Why even use set analysis ?

    What's the point of using set analysis since it accepts only Data Model Fields and not Dimensions .1. I see that almost every case where we need set a... Show More

    What's the point of using set analysis since it accepts only Data Model Fields and not Dimensions .

    1. I see that almost every case where we need set analysis, it can be replaced by a combination of other functions like aggr(), if() etc. So do we really require set analysis?

    2. I have a date field in my data model called "order_date" and dimensions "order_year", "order_week" which are derived from "order_date" field using formula Year(order_date) and Week(order_date) . I can't use these two dimensions in my set expressions. For eg, I can't use these dimensions like this 

    =Sum({<order_year={"<=$(=vMaxYear)"}>}Sales) 

    because "order_year" being a dimension can't be used and this formula will throw an error.   So how do you handle situations like these and does Set analysis even help when I have my Calendar fields as Dimensions? If so, in what cases? 

    Thanks in Advance

    @Henric_Cronström @sunny_talwar @swuehl 

    Show Less
  • forum

    QlikView Administration

    linked objects

    Hi All,I am pretty new to QlikView. I am trying to create linked objects.I follow the Copy & Paste as a linked object procedure but when I try to open... Show More

    Hi All,

    I am pretty new to QlikView. I am trying to create linked objects.

    I follow the Copy & Paste as a linked object procedure but when I try to open the object properties, Qlikview crashes and closes down.

    Any suggestions?

    Thank you in advance

    carlo

    Show Less
  • forum

    App Development

    Lookup function not returning any value

    Hi, I am attempting to use the lookup function to return a value within a table I am loading. The table is a list of securities where some have an und... Show More

    Hi, 

    I am attempting to use the lookup function to return a value within a table I am loading. The table is a list of securities where some have an underlying security identified with it. Since the underlying security is a security itself, I want to use the underlying security ID to lookup the name of the security where they key value is FKIDENDITYID. For example, the security name 'IBM_Bond' (fkidentityid = 21) has an underlying id = 41. The security name for fkidentityid = 41 is 'IBM'.  

    However, the lookup shown below returns no data. I have tried it with and without the brackets in every combination. 

    I am loading the table below via Oracle connection:

    [STDB_GC_INSTRUMENT]:
    LOAD
          [FKIDENTITYID],
          [FKUNDERLYINGID] AS [STDB_GC_INSTRUMENT.FKUNDERLYINGID],
          [NAME],
          Lookup('NAME','FKIDENTITYID',[FKUNDERLYINGID]) AS [STDB_GC_INSTRUMENT.UNDERLYINGNAME];
    SELECT * FROM "2004"."STDB_GC_INSTRUMENT";

     

    Any advice is greatly appreciated 

    Show Less
  • forum

    Qlik Enterprise Manager Discussions

    Best Practices for daily backup of Qlik Sense Applications without saving the da...

    Hoping to gain some insight on best practices for performing daily backups of Qlik Sense apps. Ideally the app's are backed up without data so as to s... Show More

    Hoping to gain some insight on best practices for performing daily backups of Qlik Sense apps. Ideally the app's are backed up without data so as to save disk space.   This seems like it might be best addressed through API but wasn't sure if there are tools or scripts already available.  

    Show Less
  • forum

    App Development

    Loop through tables by 1000 and store result in a single table field

    Hello all,I have come up with a question that seems very advanced for me to do, so I am asking for your insight.Let's say I have the following three t... Show More

    Hello all,

    I have come up with a question that seems very advanced for me to do, so I am asking for your insight.

    Let's say I have the following three tables : Table1, Table2, Table3

    and Table1  id1  has 1:n relationship with id2 of Table 2 (so table 2 has id1_fk in it)

             Table 2 id2 has 1:n relationship with id3 of Table3 (so table 3 has id2_fk in it and also a field called size_field)

    I want to create an entirely new field in Table 1 called SIZE2 that will be populated like that:

    For first  batchfrom 1  to 1000 rows of table1

    - check 1st id1, find the corresponding id2s

    -for these id2s, find the corresponding id3s and  size_field

    - sum size_fields found

    -store in SIZE2 in Table1

    ...

    - check 1000th id1, find the corresponding id2s

    -for these id2s, find the corresponding id3s and  size_field

    - sum size_fields found

    -store in SIZE2 in Table1

    Go on to second batch from row 1001 to 2000. Do again the above in loop until all rows in Table1 (id1) are finished.

     

    Is there a way to do so?

     

    Thanks in advance,

    Ioanna

    Show Less
  • forum

    App Development

    Organizing Visualizations into subfolders

    Is there a way to organize app visualizations into subfolders? i.e. instead of having 20 visualizations, can I put these into 3 or 4 folders for easie... Show More

    Is there a way to organize app visualizations into subfolders? i.e. instead of having 20 visualizations, can I put these into 3 or 4 folders for easier access?

    appreciate your help,

     

    Show Less
  • forum

    New to Qlik Sense

    YTD based on input date

    Can we calculate FYTD based on an input date. for example, if select 3/31 , then the data should be displayed YTD through 3/31.
  • forum

    New to Qlik Sense

    Migrating Data Warehouse from Elasticsearch

    Hi, I am new to the Qlik community and looking for some specific answers as I could not find them elsewhere. 1. What exact Qlik version supports on-pr... Show More

    Hi, I am new to the Qlik community and looking for some specific answers as I could not find them elsewhere. 

    1. What exact Qlik version supports on-premise Linux installation?

    2. What would be enterprise-level pricing for the above-mentioned version?

    3. What is the type of license, this version affiliates to?

    4. Wanted to ask an opinion about the connectivity options of Qlik to different DB like Elasticsearch, MySQL, SQL Server.

    Thanks in advance..!!

     

    Kind regards,

    Prasad

    Show Less
  • forum

    Integration, Extension & APIs

    Driver's SQLAllocHandle on SQL_HANDLE_ENV failed

    Hello dears!I'm trying to connect to a database with QvOdbcConnectorPackage (x64) in QlikView x64 and I'm getting the following error: Driver's SQLAll... Show More

    Hello dears!

    I'm trying to connect to a database with QvOdbcConnectorPackage (x64) in QlikView x64 and I'm getting the following error: Driver's SQLAllocHandle on SQL_HANDLE_ENV failed.

    valeling_1-1618249628376.png

    On the other way, I can successfully connect to the same database in another notebook using the same connector in same versions mentioned above.

    I've read some topics about it and I found the suggestion to force 32 bits in editor, but for this connector it 's not possible to do it.

    Any suggestions?

    Thank you!

     

    Show Less
  • forum

    New to Qlik Sense

    conditional filters for selecting multiple dimensions.

    Hi gurus, I  have a group of dataset like this dataAttributesFlagaRedyesbBluenocPurpleyesdcolorfulnoecolorfulnofcolorfulyesgWhiteno if I filter out Fl... Show More

    Hi gurus,

     

    I  have a group of dataset like this 

    dataAttributesFlag
    aRedyes
    bBlueno
    cPurpleyes
    dcolorfulno
    ecolorfulno
    fcolorfulyes
    gWhiteno

     

    if I filter out Flag yes, it returns me data with Red, Purple and Colorful.

    dataAttributesFlag
    aRedyes
    cPurpleyes
    fcolorfulyes

     

    is there a way, at filter panel for either Attributes or Flag , to achieve a conditional filter to only have Red and Purple without colorful.

    I am thinking an expression like " if Flg = Yes, only attributes =Purple and Red"

    any other ways to achieve this is also welcome. 

    much appreciated.

     

    Show Less

Get Started On Community

Start Here Get Started On Community

Top Participants

Blogs

Qlik Community Manager Blog

Hear from the Qlik Community team about the latest platform enhancements and other topics.

Blogs

Support Updates Blog

Important and useful support information about end-of-product support, new service releases, and general support topics.

Blogs

Blogs

Hear directly from Qlik employees and stay current on the latest and greatest information about Qlik products.

Groups

Covid 19

We are bringing together people and resources in response to the pandemic of Coronavirus, aka COVID-19, aka SARS-CoV-2.

open to all

Groups

QlikView to Qlik Sense

Join the QlikView to Qlik Sense group and help you modernize your BI experience through adoption of Qlik Sense.

open to all

Groups

Qlik Healthcare

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

750+ Members

Events

Online Conference

Join QlikWorld to hear from Qlik CEO, Mike Capone on activating your data for impact. You’ll also have access over 100 breakout sessions covering data integration and analytics, tips for getting the most out of your data, and a view into what the next generation of BI holds.

May 10-12, 2021

Events

Events & Meetups

Virtual Meetups are now a possibility! With the impact of COVID-19, the Qlik Meetup network has expanded its support to include the ability to host your next Meetup online. Email QlikMeetups@qlik.com to get your virtual Meetup started!’

Events

Direct Relief Uses Qlik to Manage Its COVID-19 Supply Chain

Qlik can help you manage your supply chain risks during COVID‑19.The nonprofit organization, Direct Relief, uses Qlik’s Supply Chain solution to scale its delivery of medical supplies worldwide.

Available on Demand