Qlik Community

Ask a Question
Welcome to Qlik Community
cancel
Showing results for 
Search instead for 
Did you mean: 
916 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

    Create a dimension that creates a field for last login year

    Dear Qlik community,In a table, I have  2 dimensions, 'User ID' and 'Last login dt' (yyyy-mm-dd).I want to create a 3rd dimension that has a list of '... Show More

    Dear Qlik community,

    In a table, I have  2 dimensions, 'User ID' and 'Last login dt' (yyyy-mm-dd).

    I want to create a 3rd dimension that has a list of 'UserID' whose 'last login dt' is more than 2 years ago.

    I want to use set analysis to achieve this task.

    thanks,

    AS

    Show Less
  • forum

    New to Qlik Sense

    Create a measure to find the difference between 2 calender dates

    Dear Qlik community,I have a silly or basic question!I have 2 calender dates D1 and D2. I have to find the difference between these 2 dates in terms o... Show More

    Dear Qlik community,

    I have a silly or basic question!

    I have 2 calender dates D1 and D2. 

    I have to find the difference between these 2 dates in terms of days. For example:

    if D1 = 15 Mar 2021 and D2 = 21 Mar 2021

    then D2 - D1 should give = 6 days

    Can anyone help me?

     

    Best,
    A.S

    Show Less
  • forum

    Connectivity & Data Prep

    Using Qlik to track stages of file, and provide related documents via links.

    Looking to see if Qlik can provide links to documents within an app. We use a cloud hosting service for documents. And one of our web pages we have ma... Show More

    Looking to see if Qlik can provide links to documents within an app. We use a cloud hosting service for documents. And one of our web pages we have made allows us to track documents, and pull from our document management service (dms). However, as we look to retire this website, we are hoping to include it within Qlik, but building out a document tracking app within Qlik pulling data from our database to get the stage of a file, and provide links from our dms.

    Is this possible, and what would be the best way to go about it.

    Show Less
  • forum

    QlikView App Dev

    Average of a count expression

    Hello guys,The following chart shows me the number of aircraft flying per time, with the following expression and dimension://Expression count({<NCIA=... Show More

    Hello guys,

    The following chart shows me the number of aircraft flying per time, with the following expression and dimension:

    //Expression
    count({<NCIA={'$(vAirComp1)'}>} DISTINCT KEYI)
    //Dimension
    HHSI

    brunolelli87_1-1618503489106.png

    But I have more than 1 day and more than 1 airline (NCIA), and if I don't select one specific date and/or airline (NCIA) the system will calculate all counts for that time, as you can see below:

    brunolelli87_0-1618503421414.png

    My question is:
    How can I show the average of counts? I mean, the average of aircraft flying at that itme.

     

    Thank you guys!

    Show Less
  • forum

    New to Qlik Sense

    Extracting field transformation from app load script [Qlik Sense]

    Is there a way, using the API, to retrieve the transformations applied to a field during the data load script?For example:MyTable:LOAD num(mystringfie... Show More

    Is there a way, using the API, to retrieve the transformations applied to a field during the data load script?

    For example:

    MyTable:

    LOAD num(mystringfield) as MyNumField

    RESIDENT tmp_table;

    I'd like to retrieve the final field name (MyNumField) as well as the transformation applied (num(mystringfield)).

    I know some tools like Nodegraph do this kind of task (lineage) but we're not big enough to warrant such a tool and was also interested in trying it myself. I have been unable to find this information so far.

    Show Less
  • forum

    QlikView Administration

    Qlik sense upgrade applying patch 9 to Sep 2020 version

    Dear Team,I want to upgrade my existing Qlik Sense version Sep 2020 13.95.3(Base Version)  and apply patch 9 of Sep 2020.I have HA setup  comprising o... Show More

    Dear Team,

    I want to upgrade my existing Qlik Sense version Sep 2020 13.95.3(Base Version)  and apply patch 9 of Sep 2020.

    I have HA setup  comprising of one central node which has all services installed and one RIM node which has all  services installed except Repository database.

    I just want to know when  i apply patch 9  of Sep 2020 will it have any impact to  Qlik root CA  certificate.

     

     I have to dead sure as i have to apply this to running production system and ensure nothing breaks.

     

    Any advise/help  is much appreciated.

     

    Regards

    Arvind

     

     

    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

    New to Qlik Sense

    Duplicate Load from Script

    Hi,Someone helped me write this script, so it's a bit beyond my capabilities.  It is converting all income data whatever currency or distance measurem... Show More

    Hi,

    Someone helped me write this script, so it's a bit beyond my capabilities.  It is converting all income data whatever currency or distance measurement is used into USD and miles.  For some reason it is loading my data multiple times and I don't know why. 

     

    conversionMap:
    Mapping LOAD
    AutoNumberHash128(Curnc_Year,Currency_Abbr,'currency') as ConversionKey,
    USD_Equivalent
    FROM [lib://Documents (1qconsulting_debi.cook)/Currency Conversion.xlsx]
    (ooxml, embedded labels, table is Sheet1);

    TempTable:
    LOAD
    YearID as TestYearID,
    SubtextRow as Testsubtext,
    [Year] as testyear,
    if (SubtextRow = 'United Arab Emirates Dirham', 'AED', if(SubtextRow = 'Canadian Dollars', 'CAD')) as CurrencyAbbr
    Resident [ResponseTable]
    where match(SubtextRow, 'Canadian Dollars', 'United Arab Emirates Dirham')>0;

    left Join ([ResponseTable])
    Load
    TestYearID as YearID,
    testyear as Year,
    CurrencyAbbr
    resident TempTable;
    drop table TempTable;

    TempTable:
    LOAD
    YearID as TestYearID,
    SubtextRow as Testsubtext,
    [Year] as testyear,
    if (SubtextRow = 'Kilometers','Kilometer') as DistKilometer
    Resident [ResponseTable]
    where match(SubtextRow,'Kilometers')>0;

    left Join ([ResponseTable])
    Load
    TestYearID as YearID,
    testyear as Year,
    DistKilometer
    resident TempTable;
    drop table TempTable;

    Data:
    NoConcatenate Load
    *,
    if(Conversion = 'currency', Response / ApplyMap('conversionMap',AutoNumberHash128(num#(Year),CurrencyAbbr,Conversion),1),
    if(Conversion = 'distance' and DistKilometer = 'Kilometer', Response/1.60934,
    if(Conversion = 'sqmile' and DistKilometer = 'Kilometer', Response/1.60934*1.60934 ,
    if(Conversion = 'acre' and DistKilometer = 'Kilometer', Response/.404686, Response) )))
    as ConvertedResponse,
    ApplyMap('conversionMap',AutoNumberHash128(num#(Year),CurrencyAbbr,Conversion),1) as USD_Equivalent
    resident [ResponseTable];
    drop table [ResponseTable];

    drop field Response from Data;
    rename field ConvertedResponse to Response;

     

    Thanks

    Show Less
  • forum

    QlikView App Dev

    Global calculation condition

    Hi guys,is it possible to apply the same calculation condition to all the sheets of a Qw file setting it in one place instead of placing it in every c... Show More

    Hi guys,

    is it possible to apply the same calculation condition to all the sheets of a Qw file setting it in one place instead of placing it in every chart?

    (I'd like to avoid the calculation if no-selections are made, so that a computer freeze due to the large amount of data to be analyzed can't occurs).

    Thank you so much.

    N.

       

    Show Less
  • forum

    Community Corner

    Unable to post to "documents" thread under Sense and View when I previously coul...

    Hello Qlik Community Admin team,I used to be able to post to "documents" thread under Sense and View, but I get a "permissions" error message whenever... Show More

    Hello Qlik Community Admin team,

    I used to be able to post to "documents" thread under Sense and View, but I get a "permissions" error message whenever I try to create a new document now.

    I contacted Mike Tarallo to ask for his advice and he has pointed me towards you. Could you please help me out with this?

    Many thanks for your help in this matter.

    Kind regards,

    Cheenu

    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