Qlik Community

Ask a Question

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
4,889 online

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

Qlik Academic Program

Qlik gives qualified university students, educators, and researchers free Qlik software and resources to prepare students for the data-driven workplace.

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.

Events

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

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.

About

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

Blogs

Hear directly from Qlik employees in our ten unique blogs.

Qlik Resources

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

Support

Access Support programs, Knowledge Base, Updates blog, and Release Notes.

Community Sitemap

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

Recent Discussions

  • No Boards Found
  • forum

    Connectivity & Data Prep

    Has anyone connected Qlik Sense to the Strava API?

    Hey Qlik Community,Has anyone successfully connected to the Strava API to query data? In my spare time I do a lot of cycling and running and I upload ... Show More

    Hey Qlik Community,

    Has anyone successfully connected to the Strava API to query data? In my spare time I do a lot of cycling and running and I upload the data from my Garmin wearable to Strava. I'd like to be able to query this information to do some analysis. If anyone has done something similar or connected to Garmin Connect I'd be very interested to see how you did this.

    Thank you for all the help!

    Tanner Glenn

    Show Less
  • forum

    New to Qlik Sense

    load latest 4 years

    Hi,I have 13 years in "Years" column but i need to load only the latest 4 years in load editor. Years column:Years200920102011201220132014201520162017... Show More

    Hi,

    I have 13 years in "Years" column but i need to load only the latest 4 years in load editor.

     Years column:

    Years
    2009
    2010
    2011
    2012
    2013
    2014
    2015
    2016
    2017
    2018
    2019
    2020
    2021

     

    i need to load:

    Years
    2018
    2019
    2020
    2021

     

    if we are in 2022, the Years loaded should be:

    Years
    2019
    2020
    2021
    2022

     

    and so on. Thanks

    Show Less
  • forum

    QlikView App Dev

    Get current Period based on set analysis

    Hello all,I need to create a filter that does not show the current period, so I want to create it on nprinting based on qlikview set analysis.I have t... Show More

    Hello all,

    I need to create a filter that does not show the current period, so I want to create it on nprinting based on qlikview set analysis.

    I have this data

    idodel_0-1627467481740.png

    I have tried this one but with no success:

    max({<[ReportDate]={'$(=Today())'}>}PeriodPXFYX)

    what measure I need to create in order to solve it.

    FOR EXAMPLE: 

    I need today to return the value: "P3-FY22" so after create that i can eliminate that data on the report.

    Thanks for help

    Ido

     

    Show Less
  • forum

    Japan Support

    【Partner Enablement Session】Qlik Sense SaaS editions – Updates

    Qlik Sense のクラウド版のお問合せについて、共有させていただきたいケースがありますので、3月に行った 【Partner Enablement Session】Qlik Sense SaaS editions – to start Supporting をベースに、更新版を Qlik Sen... Show More

    Qlik Sense のクラウド版のお問合せについて、共有させていただきたいケースがありますので、3月に行った 【Partner Enablement Session】Qlik Sense SaaS editions – to start Supporting 
    をベースに、更新版を Qlik Sense SaaS editions – Updates との内容で、8月5日に、Partner Enablement Sessionを開催させていただきました。お忙しい中、ご参加ありがとうございました。

    資料では、リンクをクリックしていただければ、該当のWebページが表示されるようになっていますので、ご活用ください。
    当日、参加できなかった方もいると思いますので、ビデオもアップロードしております。
    資料は、英語になっていますが、当日の説明は、日本語で行っています。

    今回の資料には、3月に行った 【Partner Enablement Session】Qlik Sense SaaS editions – to start Supporting のケース内容は、含まれていないので、初めてサポートされる方は、3月開催資料の5番、6番の項目も、ご確認ください。

    Show Less
  • forum

    Ideation Discussions

    Deny Excel export in Qlik SaaS

    In Qlik Sense for Windows it is possible to allow (or deny) for dedicated users the download of datas to Excel.This should also be available in Qlik S... Show More

    In Qlik Sense for Windows it is possible to allow (or deny) for dedicated users the download of datas to Excel.

    This should also be available in Qlik SaaS.

    Can I found supporters for that?

    Regards

    Show Less
  • forum

    Integration, Extension & APIs

    Extract Month and Year from file name separately

    hi I have a file name like this Abc-June-2021.xlsxNow i am trying to extract Month and year like this in script   Trim(Replace(FileBaseName(),'MMailBo... Show More

    hi 

    I have a file name like this 

    Abc-June-2021.xlsx

    Now i am trying to extract Month and year like this in script 

     

     Trim(Replace(FileBaseName(),'MMailBoxUsage-','')) as MailBox_Date

     

    and the output is June-2021 .. but now i want to extract Month and Year separately from MailBox_Date field .. 

    how i do this ?

     

    Show Less
  • forum

    Security & Governance

    Deny Excel export in Qlik Saas

    Hello,is there a way to deny similiar users to export data from an explication in Qlik Sense SaaS to Excel like it is possible to set a security rule ... Show More

    Hello,

    is there a way to deny similiar users to export data from an explication in Qlik Sense SaaS to Excel like it is possible to set a security rule in Qlik Sense for Windows?

    Thank you

    Show Less
  • forum

    New to Qlik Sense

    Consecutive Occurrence by Month

    There is data like below. How to count consecutive occurrence of a store by month in Script.Store IDYear MonthConsecutive OccurrenceA2021011A2021022A2... Show More

    There is data like below. How to count consecutive occurrence of a store by month in Script.

    Store IDYear MonthConsecutive Occurrence
    A2021011
    A2021022
    A2021033
    A2021044
    A2021061
    A2021072
    B2021011
    B2021022
    B2021071
    Show Less
  • forum

    Integration, Extension & APIs

    ApplyPatches on root element

    Is it possible to use applypatches with path "/"? I have tried this: var patch = new NxPatch() { Op = NxPatchOperationType.Replace, Path = "/", Value ... Show More

    Is it possible to use applypatches with path "/"? 

    I have tried this:

     

    var patch = new NxPatch() { Op = NxPatchOperationType.Replace, Path = "/", Value = "{ \"title\": \"Min rubrik\" }" };
    var patches = new NxPatch[] { patch };
    await genericObject.ApplyPatchesAsync(patches, true);

    but it complains that my JSON has a bad format (Invalid parameters [8]:Invalid parameters(Patch value not on valid JSON format.)). My intention is not to change only the title, it is a small test. I would like to apply a whole JSON object of properties, because I find it very tedious to search for paths and values in the properties.

     

    I have already tried this, and it works:

     

    var patch = new NxPatch() { Op = NxPatchOperationType.Replace, Path = "/title", Value = "\"Min rubrik\"" };

     

    so please don't give me that advice.

     

     

    Show Less
  • forum

    Deployment & Management

    script

    Hi Expert, Need quick help:I have table with below fields : Division FlagValueALPHAA1000ALPHAB100BETAA2000BETAB200GAMMAA3000GAMMAB300 I want one resul... Show More

    Hi Expert,

     

    Need quick help:

    I have table with below fields :

     

    Division FlagValue
    ALPHAA1000
    ALPHAB100
    BETAA2000
    BETAB200
    GAMMAA3000
    GAMMAB300

     

    I want one resulting column which should be calculated as "A-B"

    DivisionResultingValue
    ALPHA900
    BETA1800
    GAMMA2700

     

    Kindly help.

    Show Less

Get Started On Community

Start Here Get Started On Community

Top Participants

Blogs

Product Innovation Blog

Learn about what's new across all of the products in our growing Qlik product portfolio.

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.

German Group

Deutsche User Group

German speaking - This group makes it easier to collaborate in your local language.

Request to join

Brazil Group

Brazil

This group for Brazil users. All discussions are in Portuguese.

open to all

Industry Group

Public Sector Group

This is a open Group for the Public Sector

All are welcome

Events

Espresso Webinars - From Data Integration to Analytics in Action

These webinars get straight to the point, they are strong, short, and with immediate effect – like an espresso.

Upcoming and On-Demand

Events

Talk to Experts Tuesday

You’ve got questions? We’ve got answers! Talk to Experts is a live Q&A Webinar series! Join and ask your questions about Qlik Sense Enterprise, Client Managed.

June 29, 2021 10AM EST

Events

Cloud Data and Analytics Tour

Ready to steer your business towards data-informed growth? Our Cloud Data & Analytics Tour is the perfect place to start your journey.

Choose your Region