Skip to main content

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 188,116 members
  • 7,970 online
  • 1,741,663 posts
  • 133,547 Solutions
Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW

Welcome to Qlik Community

FOR NEW MEMBERS

Everything you need to make your Qlik Community experience valuable.

SEARCH KNOWLEDGE BASE

Explore official Support and member created content.

QLIKWORLD 2023!

Welcome Emmy award-winning Katie Linendoll as our emcee and world record-holding cave diver John Volanthen as our keynote speakers.

Analytics

Forums for Qlik Analytic 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 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.

Support

Chat with us, search Knowledge, open a Case, read the latest Updates Blog, find Release Notes, and learn about our Programs.

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 Qlik Community

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.

Qlik Academic Program

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

Community Sitemap

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

Recent Discussions

  • forum

    App Development

    Scripting Assistance for Variable

    Hi all, Silly question this one. Please paste the below code in an empty QlikView file. My Code fails on the 'Match' statement. I need some assistance... Show More

    Hi all,

    Silly question this one.

    Please paste the below code in an empty QlikView file. My Code fails on the 'Match' statement. I need some assistance to get this to work please, and I've tried all options I can think of.

    Thank you

     

     

    Tbl:
    load
    chr(40) & concat(Code, ',') & chr(41) as Codelist;
    LOAD * INLINE [
    Code
    28
    29
    30
    ];
    Let MyVar = FieldVAlue('Codelist',1);
    drop table Tbl;


    DemoData_1:
    LOAD * INLINE [
    Student, Code
    Peter, 28
    Pam, 88
    Paul, 30
    ];

    DemoData:
    NoConcatenate load
    *
    Resident
    DemoData_1
    where match(Code, $(MyVar)) > 0 ; //this is where it fails - I've also tried $(MyVar), with no luck - it runs, but returns nothing

    drop table DemoData_1;

    exit SCRIPT

     

    Show Less
  • forum

    Qlik Cloud Data Integration

    Qlik Data Gateway - Failed often

    Hi there, just got the problem yesterday and today that 8 out of 10 times i try to load data via Qlik Data Gateway it fails with the notice: "Requeste... Show More

    Hi there,

    just got the problem yesterday and today that 8 out of 10 times i try to load data via Qlik Data Gateway it fails with the notice:

    "Requested endpoint could not be provisioned due to failure to acquire a load slot:"

     

    Flo_Kopp_0-1673367461476.png

    Any of you got some ideas ?

    Show Less
  • forum

    Move to SaaS

    Unable to connect to the gateway (DirectAccess-2006)

    Hi, start to use Qlik gateway, and few days a ago we start to get errors on our app reloads: <Requested endpoint could not be provisioned due to failu... Show More

    Hi, start to use Qlik gateway, and few days a ago we start to get errors on our app reloads:

    <Requested endpoint could not be provisioned due to failure to acquire a load slot: Unable to connect to the gateway (DirectAccess-2006)>

    maybe someone saw such before? and know how to solve it.

    Show Less
  • forum

    Qlik Replicate

    Replicate: SAP Extractor not fetching data

    We have a SAP Extractor replicate job built over a standard SAP HR extractor. When executed without any selection criteria  over SAP RSA3 transaction,... Show More

    We have a SAP Extractor replicate job built over a standard SAP HR extractor. When executed without any selection criteria  over SAP RSA3 transaction, there is data in the extractor. However, we don't get any data out of Replicate tas.k Any suggestions on what might be causing this issue ?

    SAP -

    Abhi_719_0-1679933239185.png

    Replicate -

    Abhi_719_1-1679933431727.png

     

     

     

    Show Less
  • forum

    New to Qlik Sense

    Cumulative Sum - AGGR by dimension

    Data looks like this -  Family Name Gift Date PledgeNum Pledged Individual Name IsGivingShared Sum(GiftDetail_Amount) Cumulative Family Amount Max(... Show More

    Data looks like this - 

    Family Name Gift Date PledgeNum Pledged Individual Name IsGivingShared Sum(GiftDetail_Amount) Cumulative Family Amount Max(GiftDate)
    Family1 5/10/2022 - No Individual1 False $ 200.00 200 5/10/2022 0:00:00  TT
    Family1 10/9/2022 - No Individual1 False $ 250.00 450 10/9/2022 0:00:00  TT
    Family2 3/13/2023 - No Individual2 False $ 325.00 775 3/13/2023 0:00:00  TT
    Family3 9/25/2022 - No Individual3 False $ 314.00 1089 9/25/2022 0:00:00  TT
    Family4 6/23/2022 27 Yes Individual4 True $ 50.00 1139 6/23/2022 0:00:00  TT
    Family4 7/23/2022 27 Yes Individual4 True $ 50.00 1189 7/23/2022 0:00:00  TT
    Family4 8/26/2022 27 Yes Individual4 True $ 350.00 1539 8/26/2022 0:00:00  TT
    Family4 9/23/2022 27 Yes Individual4 True $ 300.00 1839 9/23/2022 0:00:00  TT
    Family4 9/26/2022 27 Yes Individual5 True $ 100.00 1939 9/26/2022 0:00:00  TT
    Family4 ######## 27 Yes Individual5 True $ 100.00 2039 10/25/2022 0:00:00  TT
    Family4 ######## 27 Yes Individual4 True $ 200.00 2239 10/25/2022 0:00:00  TT
    Family4 ######## 27 Yes Individual4 True $ 470.00 2709 11/17/2022 0:00:00  TT
    Family4 ######## 27 Yes Individual5 True $ 100.00 2809 11/25/2022 0:00:00  TT
    Family4 ######## 27 Yes Individual4 True $ 200.00 3009 12/15/2022 0:00:00  TT
    Family4 ######## 27 Yes Individual5 True $ 100.00 3109 12/25/2022 0:00:00  TT
    Family4 1/25/2023 27 Yes Individual5 True $ 100.00 3209 1/25/2023 0:00:00  TT
    Family4 2/24/2023 27 Yes Individual4 True $ 200.00 3409 2/24/2023 0:00:00  TT
    Family4 2/25/2023 27 Yes Individual5 True $ 100.00 3509 2/25/2023 0:00:00  TT

     

    I'm using this expression for Cumulative amount in the above table:  RangeSum(Above(total sum(GiftDetail_Amount),0,rowno(total)))

    What I need is to aggr the cumulative amount by Family (a dimension). I want the data to look like table below - I've tried several things but cannot get it to work. Can anyone help me?? 

    Family1 5/10/2022 - No Individual1 False $ 200.00 200 5/10/2022
    Family1 10/9/2022 - No Individual1 False $ 250.00 450 10/9/2022
    Family2 3/13/2023 - No Individual2 False $ 325.00 325 3/13/2023
    Family3 9/25/2022 - No Individual3 False $ 314.00 314 9/25/2022
    Family4 6/23/2022 27 Yes Individual4 True $ 50.00 50 6/23/2022
    Family4 7/23/2022 27 Yes Individual4 True $ 50.00 100 7/23/2022
    Family4 8/26/2022 27 Yes Individual4 True $ 350.00 450 8/26/2022
    Family4 9/23/2022 27 Yes Individual4 True $ 300.00 750 9/23/2022
    Family4 9/26/2022 27 Yes Individual5 True $ 100.00 850 9/26/2022
    Family4 10/25/2022 27 Yes Individual5 True $ 100.00 950 10/25/2022
    Family4 10/25/2022 27 Yes Individual4 True $ 200.00 1150 10/25/2022
    Family4 11/17/2022 27 Yes Individual4 True $ 470.00 1620 11/17/2022
    Family4 11/25/2022 27 Yes Individual5 True $ 100.00 1720 11/25/2022
    Family4 12/15/2022 27 Yes Individual4 True $ 200.00 1920 12/15/2022
    Family4 12/25/2022 27 Yes Individual5 True $ 100.00 2020 12/25/2022
    Family4 1/25/2023 27 Yes Individual5 True $ 100.00 2120 1/25/2023
    Family4 2/24/2023 27 Yes Individual4 True $ 200.00 2320 2/24/2023
    Family4 2/25/2023 27 Yes Individual5 True $ 100.00 2420 2/25/2023
    Show Less
  • forum

    Qlik Cloud Data Integration

    Change Spaces for all QVD files

    Hi folks, I have to move all the QVDs from Spaces to the Shared space - I have seen various articles on REST calls, powershell scripts to make API cal... Show More

    Hi folks,

    I have to move all the QVDs from Spaces to the Shared space - I have seen various articles on REST calls, powershell scripts to make API calls - I implemented in Postman a simple to get a list of spaces and although it kind of works it couldn't get all of the spaces we have. I have checked the spaces one by one for permissions and the account I use has all of the permissions available so I don't believe that is the issue - is there a bug in the API or more probably am I calling it incorrectly?

    In postman I use the bearer token, newly created in case that is the issue, then the URl is 

    https://XXXXX.qlikcloud.com/api/v1/spaces/

    The resulting JSON  only pulls 10 spaces but I have 30 - is there something else I need to do to get the full list?

    Thanks

     

    Show Less
  • forum

    App Development

    Zero represented as blank in xls export (unwanted)

    Hi,QS is behaving strangely after the upgrade Feb2018 enterprise to Apr2019 enterprise (but also in my Feb2019 Desktop).When exporting a table to exce... Show More

    Hi,

    QS is behaving strangely after the upgrade Feb2018 enterprise to Apr2019 enterprise (but also in my Feb2019 Desktop).

    When exporting a table to excel, the cells which contain a zero are represented as blank. The value is present in the cell (you can see it when you click on it) but it happears as blank.

    zero as blank.png

     

     

     

     

     

     

     

     

     

    if you look at the format in xls you see the following:

    format.png

    This is the code I used to create a table containing numbers from 0 to 9:

    load RowNo()-1 as riga
    AutoGenerate 10;

     

    It does not happen if I slitly change the code to:

    load (RowNo()-1)/3 as riga
    AutoGenerate 10;

    zero as zero.png

     

     

     

     

     

     

     

     

     

    In this case the format in excel is the generic one:

    format2.png

     

    1) Has anyone experienced the  same issue?

    2) Is there any way to fix it for the entire app? Maybe using some kind of variable similar to MoneyFormat. I have thousands of fields and it is unthinkable to change the format one by one.

    Thank you for your support.

    Show Less
  • forum
  • forum

    Integration, Extension & APIs

    Qlik Sense Map zooming issue

    Hello, I have created a mashup using sense object id. so far everything working fine the only issue I was facing is when I am pulling the map object i... Show More

    Hello,

    I have created a mashup using sense object id. so far everything working fine the only issue I was facing is when I am pulling the map object id inside the <div> the map size gets small (maybe zoom) but when I load the page again everything gets normal.

    There is something wrong with click map behavior don't know why this happening.

    Any help?

    Show Less
  • forum

    Qlik NPrinting

    nPrinting SR4 Designer, Excel window jumping out of container

    Not a major issue but since the SR4 release when I preview an Excel report using the designer, sometimes the excel window jumps out of the designer fr... Show More

    Not a major issue but since the SR4 release when I preview an Excel report using the designer, sometimes the excel window jumps out of the designer frame and into it's own Excel tab in task bar. 

    If you accidentally close the excel window then the only way to close designer is ending task via task manager  - because of the continuous error "The RPC server is unavailable".

    nPrinting May 2022 SR4

    nPrinting  Designer May 2022 SR4

    Microsoft® Excel® for Microsoft 365 MSO (Version 2301 Build 16.0.16026.20214) 32-bit

    Windows 10 Pro 21H2

     

    Any advice?

    Thanks

    nPrint.PNG

    Error when you accidently close the excel window.PNG

     

     

    Show Less

Blogs

Community News

Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!

Blogs

Qlik Academic Program Blog

Read the latest blog around the Qlik Academic Program.

Blogs

Qlik Product Innovation Blog

If you want to know what's new across all of the products in our growing Qlik product portfolio.

Blogs

Support Updates Blog

Get the latest Support information about end-of-product support, new service releases, and general support topics.

Blogs

Qlik Design Blog

Read all about Qlik solutions: scripting, data modeling, visual design, extensions, best practices and more.

Location and Language Groups

Choose a Group

Join one of our Location and Language groups. Find one that suits you today!

Collaborate

Healthcare User Group

Healthcare User Group

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

All are welcome

Japan Group

Japan

Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。

Request to join

Brasil Group

Brazil

Welcome to the group for Brazil users. .All discussions will be in Portuguese.

open to all

Events and Webinars

QlikWorld 2023, Technical Workshops!

10+ hours of roll up your sleeves, immersive working sessions. A $1000 value included in your conference pass!

Choose your workshops

Events and Webinars

Qlik and Qlik Community Hosted Events

Subscribe to our Events and Webinar page so you do not miss an event opportunity!

choose and register

Event

Welcome to Qlik

Join the "Welcome to Qlik" webinar and learn about the Qlik Ecosystem, such as Qlik Community, Learning, and Help.

On-Demand

Events

Upcoming Events and Webinars

There is more than one way to find upcoming events, look on the right side of any Qlik Community forum!

Upcoming

Events and Webinars

Qlik and Qlik Community Hosted Events

Subscribe to our Events and Webinar page so you do not miss an event opportunity!

choose and register

Event

Welcome to Qlik

Join the "Welcome to Qlik" webinar and learn about the Qlik Ecosystem, such as Qlik Community, Learning, and Help.

On-Demand

Events

Upcoming Events and Webinars

There is more than one way to find upcoming events, look on the right side of any Qlik Community forum!

Upcoming