Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
2,714 online

Find the forums for your Qlik data analytics products to ask a question, start a discussion, or review documentation.

Find the forums for your Qlik Data Integration products to ask a question, start a discussion, or review documentation.

This forum will provide you with event highlights and related content to get you energized and ready for Qlik’s largest customer and partner event of the year.

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.

Discussion Boards and Documents for Qlik Services.

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 nine unique blogs. Check out the new Customer Success Blog!

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

Qlik partners with leading technology companies to develop integrations, extensions, and connectors to the Qlik platform.

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.

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

Recent Discussions

  • QlikView App Development

    Qlikview report - Colors KO in Accesspoint (QlikView 12.10)

    Hello,I have a QlikView report containing differents Qlikview objects: color graphics, a basemap image ...With QlikView the restitution is ok,With acc... Show More

    Hello,
    I have a QlikView report containing differents Qlikview objects: color graphics, a basemap image ...
    With QlikView the restitution is ok,
    With accesspoint colors are ok for bar graphs, curve, sector ... but KO for the basemap and the bar graphs placed on it.
    See Attachment

    QlikView 12.10

    User parameters / print : Color forced

    Any idea about that ?

    Cordially - Jacques

    Show Less
  • Qlik Sense App Development

    Create separate .qvd files to eventually concatenate

    Hi, I am looking to use one qvd file to store 12 hours of data. Then at the end of 12 hours, I want to concatenate that data with another qvd file tha... Show More

    Hi, 

    I am looking to use one qvd file to store 12 hours of data. Then at the end of 12 hours, I want to concatenate that data with another qvd file that serves as a historical data file. I'm hoping this will speed up my load time.  Can someone help me get started with this process?  How do I specify when the 12 hour data should be moved to the historical data? What are some key commands/functions others have used when doing this?

     

    Thank you! 

    Show Less
  • QlikView Connectors

    Automated Upload of excel/csv files generated from Qlikview application to Share...

    Hi Everyone,I am able to load data from excel files available at SharePoint location however as a next part of automating end to end process I also ne... Show More

    Hi Everyone,

    I am able to load data from excel files available at SharePoint location however as a next part of automating end to end process I also need to upload data back to SharePoint using the same Qlikview application.

    Can you please extend your help & support here to achieve this.

    Many Thanks in advance !!!.

     

     

    Show Less
  • QlikView App Development

    Issue because of reduced data based on Year column

    Hi All, Previously I had 6 years of data but now I have reduced it to 3 years.I used below reduction formula for this.Let vStartYear = year(today())-3... Show More

    Hi All, Previously I had 6 years of data but now I have reduced it to 3 years.

    I used below reduction formula for this.

    Let vStartYear = year(today())-3;

    LOAD
    Year,
    Data,
    ...
    FROM ... where Year >= $(vStartYear);

     

    But in some of my KPIs developers kept Year= blank to avoid any selection on Year column but it sems that because of the same filter my data is not matching.

    My expressions are as per below,

    OrderBookValueLC= Num (Sum ({$<[%Date Selection] = {'Sales Document Creation Date'}, Year =, Quarter =, Month =, [Year Month] =, [Year Week] =, Date =>} [Orderbook Value LC]), '# ##0')

     

    OrderBook Documents = Num (Count ({$<[%Date Selection] = {'Sales Document Creation Date'}, Year =, Quarter =, Month =, [Year Month] =, [Year Week] =, Date =>} DISTINCT If ([Orderbook Value LC] > 0 OR [Orderbook Value LC] < 0 OR [Orderbook Quantity] > 0 OR [Orderbook Quantity] < 0, [Orderbook Document Number Count])), '# ##0')

     

    OrderBookLines = Num (Count ({$<[%Date Selection] = {'Sales Document Creation Date'}, Year =, Quarter =, Month =, [Year Month] =, [Year Week] =, Date =>} DISTINCT If ([Orderbook Value LC] > 0 OR [Orderbook Value LC] < 0 OR [Orderbook Quantity] > 0 OR [Orderbook Quantity] < 0, [Orderbook Document Item Count])), '# ##0')

     

     

    Could you please suggest on this.

     

    Show Less
  • Qlik Sense App Development

    Top 10 Debtors for Rolling 12 Month

    Hi I am trying to output Top 10 Debtors balance per month for the last 12 months in a chart, dimension Month and Measure Balance (see attachment). I a... Show More

    Hi 

    I am trying to output Top 10 Debtors balance per month for the last 12 months in a chart, dimension Month and Measure Balance (see attachment). I am able to code it using set analysis, however it shows same Top 10 Debtors as ranked for last month for the rolling period of 12 months. I would like to show Top 10 Debtors to be calculated for each months of rolling 12 months. Measure is defined like below and uses AsOfCalendar approach:

    Sum(
    {$<
    DateNum={">=$(=num(AddMonths(date($(vMaxSnapshotDateNumPrev)),-11)))<=$(=$(vMaxSnapshotDateNumPrev))"},
    [%Flag_IsThisDate]={1},
    [Debtor]={"=Rank(AGGR(Sum({<DateNum={'$(=$(vMaxSnapshotDateNumPrev))'},[%Flag_IsThisDate]={1}>}[Open Amount]*($(vCurrencyRate))),[Debtor]),4)<=10"}
    >}
    [Open Amount]*$(vCurrencyRate))

    Any ideas?

    Thanks for help in advance, M.

    Chart.pngTOP 10 Rolling 12 Months

    Show Less
  • Qlik Sense App Development

    Range Product Function

    Hi All, I have data structured as the below.  I was wondering if it is possible to create a RangeProduct type function to calculate YTD,QTD,etc calcul... Show More

    Hi All,

     

    I have data structured as the below.  I was wondering if it is possible to create a RangeProduct type function to calculate YTD,QTD,etc calculations.

     

     

    DateReturn
    1/31/20181.011010404
    2/28/20181.005565826
    3/31/20181.007899406
    4/30/20181.0039712
    5/31/20181.005528985
    6/30/20181.005855925
    7/31/20181.007522803
    8/31/20181.007913107
    9/30/20181.00652716
    10/31/20181.002180224
    11/30/20180.996697694
    12/31/20180.992635858

     

    So for example when I select 3/31/2018 I want my calculation for YTD to be 

    Sum({<[Date] = {'3/31/2018'}>}Return) * Sum({<[Date] = {'2/28/2018'}>}Return) * Sum({<[Date] = {'1/31/2018'}>}Return)

     

    Thanks!

    Mark

     

     

    Show Less
  • Qlik Sense App Development

    Previous Date Issue

    I have a Extraction Date field but it has no sequence to it. For example I have dates like05/1/201903/1/20192/1/2019.I always want the Max Date and th... Show More

    I have a Extraction Date field but it has no sequence to it. For example I have dates like

    05/1/2019

    03/1/2019

    2/1/2019.

    I always want the Max Date and the  Previous from Max Date. In this case I need 5/1/2019 and 3/1/2019. I know how to get 5/1/2019 but how will get  3/1/2019. 

    Show Less
  • New to Qlik Sense

    Estados alternos y getSelectedCount

    Buenas tardes. Estoy teniendo un problema para hacer funcionar un simple if con el getselectedcount y estados alternos.Tengo donde filtros de  año:Yea... Show More

    Buenas tardes. 

    Estoy teniendo un problema para hacer funcionar un simple if con el getselectedcount y estados alternos.

    Tengo donde filtros de  año:

    Year    con el estado alterno Fecha

    Year2 con el estado alterno  Fecha2

    Cuando intento usar un if no me responde : 


    if(GetSelectedCount([FechaCalendar.autoCalendar.Year] ,{Fecha})=0, 23,99)

     

    Alguien me puede guiar si estoy armando mal el if o existe alguna restriccion para la funcion GetSelectedcount() con estados alternos.

     

    Desde ya muchas gracias!

    Show Less
  • Qlik Server Side Extensions Discussions

    exportPdf error after switching apps (Uncaught (in promise) {code: 2})

    Hi, can anyone assist me with this error?Every time I try to export a PDF or Image file it goes perfectly but when I close and open another applicatio... Show More

    Hi, can anyone assist me with this error?

    Every time I try to export a PDF or Image file it goes perfectly but when I close and open another application I keep getting this error.

    I've checked and the application is really changing from one to another. If I switch it back, it exports ok again.

    The error is pretty concise and not much informative: error{code: 2}

    ...

    const currentVisualization = await activeApp.visualization.get(visualizationId);
    const pdfUri = await currentVisualization.exportPdf(pdfExportSettings); //<- error thrown
     
    ...
     
    We are using Feb 2019 version.
    Show Less
  • Qlik Sense App Development

    How to get second dimension Labels for corresponding for first dimension in qlik...

    Hi All qlik Experts,Have a nice day.I have requirement like , i want to display  trends data month over month for last 12 months here , if i am in 202... Show More

    Hi All qlik Experts,

    Have a nice day.

    I have requirement like , i want to display  trends data month over month for last 12 months here , if i am in 2020 Jan right

    so, in my line chart i need to display for second  dimension 2020 for Jan 2020 and rest all are 2019 year should be display as a second dimension for all one value i.e 2019. 

     

    Please suggest me here how to do ...

     

    Thanks in advance....

     

    Show Less

Blogs

Qlik Community Manager Blog

Hear from the Qlik Community team about the latest platform enhancements for October and November 2019.

Blogs

Qlik Support Updates Blog

Read the latest blogs from Qlik Support and get important and useful support information.

Blogs

Blogs

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

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

Events

Qlik World 2020

Transform your digital world. Join us for our annual conference (formerly Qonnections) in Phoenix, AZ. Register by January 31, and save $300.

May 11- 14, 2020 Global Conference

Events

Events & Meetups

Participate in an upcoming local Qlik Meetup


Events

Customer Spotlight Series

Discover the secrets behind data-driven transformation with real-world examples from Qlik customers.

Watch the Series Today