Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
1,617 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.

Welcome to the Qlik Alerting Product Forum! Join in on the discussion around Qlik’s intelligent alerting solution for Qlik Sense! This is an open group to share and collaborate!

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

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.

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

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 ten unique blogs. Check out the new Product Insight & Ideas Blog!

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

Recent Discussions

  • No Boards Found
  • forum

    New to QlikView

    Compare a period this year with the same period last year

    Hello Everyone!I have a little problem with the following expression:I want to calculate the difference between the "Netto" of a period compared to th... Show More

    Hello Everyone!

    I have a little problem with the following expression:

    img.PNG

    I want to calculate the difference between the "Netto" of a period compared to the "Netto" of the same period of the previous year but I don't know how to do that. Please, could anyone text me the right expression?

    Thanks!

    Show Less
  • forum

    Qlik Sense App Development

    Accumulative sum by 2 dimensions

    I'm trying to get a cumulative month to month sum on a table which is grouped by customer and year.The idea is to sum "Total" value each month and the... Show More

    I'm trying to get a cumulative month to month sum on a table which is grouped by customer and year.

    The idea is to sum "Total" value each month and then subtract that accumulated amount from the "CommittedSpend" column, which is the same for each year.

    In the example below, first year of committed spent was $612,000 and the actual spent was $123,892 so the calculation was $612,000-$123,892=487,107.

    On the second month, the spent was $175,997 and the accumulated spent was $300,890(124,892+175,995). Then the remaining was the subtraction of $612,000-$300,890 giving a result of 311,109, and so on.

    This calculation should end on the 12th month of each year and then start again on the next year(if applied) for each customer.

    I was using the code below, but that works only when a select a customer from a filter but it stops working if no selection is made.

     

     [CommittedSpend]-RANGESUM(ABOVE(TOTAL SUM(Total),0,12))

     

    Ilhui_0-1606424891473.png

     

    Show Less
  • forum

    New to Qlik Sense

    How to calculate previous months data when selecting current month ?

    Hi Team,I want to populate the pervious 3 months data when I'm selecting a month name.Paid Month Long Name is my filter. For example if I select April... Show More

    Hi Team,

    I want to populate the pervious 3 months data when I'm selecting a month name.

    JishnuGS_0-1606476231749.png

    Paid Month Long Name is my filter. For example if I select April 2020, I need to get the Sum(POCA) of March 2020, February 2020 and January 2020.

    Could you please help me with the query?

    Thanks,
    Jishnu 

    Show Less
  • forum

    Qlik Sense Advanced Authoring

    Re: Export all measures and dimensions from QlikSense

    Hi Guys, I need to export all the measures and dimensions from QlikSense along with sheet name for my documentation. I know this feature is availble i... Show More
    Hi Guys,
     
    I need to export all the 
    measures and dimensions from QlikSense along with sheet name for my documentation. 
    I know this feature is availble in Qlikview (Settings-> Expressions Overview -> Export) but I unable to find any extension and properties same for qliksense. 
     
    Could you please help me. thnaks in advance!!
     
    Regards,
    Arunesh 

     

     

     

    Show Less
  • forum

    Qlik Sense App Development

    Measure to count distinct value, comparing dates but ignoring relations

    Hello,I'm trying to develop a chart but I am not able to build a measure in the way I desire.Consider these two tables:they are connected through ID_U... Show More

    Hello,

    I'm trying to develop a chart but I am not able to build a measure in the way I desire.

    Consider these two tables:

    Schermata 2020-11-27 alle 16.55.42.png

    they are connected through ID_USER. 

    I want to count the distinct id_shipment_detail where DATE=DATE_TICKET.

    With this measure

    count(distinct if ( DATE=DATE_TICKET ,ID_SHIPMENT_DETAIL))

    it seems to me that the count considers the condition DATE=DATE_TICKET but excludes from the count the row with 'user4' (i believe it is because user4 is not in tableB).

    How can I count the total of distinct ID_SHIPMENT_DETAIL, considering the comparison between dates and also including the rows of table A that have no connection with table B?

    At the end, if I print a table with DATE, DATE_TICKET and the count measure, I want to obtain the following:

    Schermata 2020-11-27 alle 16.59.10.png

    Thank you

    Show Less
  • forum

    Qlik Sense App Development

    Consumer Confidence Index from Data Market Eurostat data

    Do you know if in the data catalogue from Eurostat which is available via the Qlik DataMarket the Consumer Confidence Index is available?  
  • forum

    Qlik Sense App Development

    Obtain the latest Year - Sum Quantity Sold

    Hi - I am trying to create a variable that does the following:Data contains Sales Date for the past four years (2016 - 2019) and the quantity soldI wo... Show More

    Hi - I am trying to create a variable that does the following:

    • Data contains Sales Date for the past four years (2016 - 2019) and the quantity sold
    • I would like have a variable which calculates the sum of the quantity sold for the most recent year (hence 2019)

    Table fields:

    SalesDate

    QuantitySold

    Variable:

    vYearMaxQuantitySold:

    =Sum({$<[SalesDate.autoCalendar.Year] = {$(=max([SalesDate.autoCalendar.Year]))}>}[QuantitySold])

    I try the formula above - does not work - any thoughts ? Jerry

    Show Less
  • forum

    Qlik Sense App Development

    Qlik - Forecasting Based on Previous Year

    HiI have a scenario, where i have to forecast the data based on the last Year Month Data. Below is the sample dataQn : With the given data below - i n... Show More

    Hi

    I have a scenario, where i have to forecast the data based on the last Year Month Data. Below is the sample data

    Qn : With the given data below - i need to forecast the data for Sep-20 till Dec - 2020 (Based on the Months Previous Year Data)

    Ex:  For Sept 2020 - I should get the value of Sept 2019, as i dont have the value for Sept 2018

    For Oct  2020 - I should get the value of Oct 2019, as i dont have the value for OCt 2018

    For Nov 2020 - I should get the Average value of Nov2019 and Nov 2018 and goes on

     

     

    MonthPB
    Nov-189041
    Dec-189747
    Jan-199243
    Feb-197839
    Mar-1913000950
    Apr-1910621127
    May-1911752534
    Jun-1911144306
    Jul-199192501
    Aug-1910075416
    Sep-197092894
    Oct-195640611
    Nov-194613950
    Dec-194557715
    Jan-204384742
    Feb-204777633
    Mar-207893871
    Apr-204339084
    May-204649449
    Jun-205785399
    Jul-204760955
    Aug-204747258
    Sep-20 
    Oct-20 
    Nov-20 
    Dec-20

     

     

     

    @sunny_talwar 

     

    Regards,

    SK

    Show Less
  • forum

    Qlik Brasil

    Colocar ano a ano em barras

    Olá pessoal.Tenho 2 colunas uma com  Total e outra com a Data de 2019 até 2020queria colocar isso em barras e mostrar jan/2019 jan/2020 e etc lado a l... Show More

    Olá pessoal.

    Tenho 2 colunas uma com  Total e outra com a Data de 2019 até 2020

    queria colocar isso em barras e mostrar jan/2019 jan/2020 e etc lado a lado comparando os meses do ano passado com desse ano usando a medida de Total

    tentei algumas formulas que achei aqui, mas não deu certo.

    o que devo colocar na minha medida e na minha dimensão do grafico?

    Obrigada desde ja

     

    Show Less
  • forum

    QlikView Scripting

    clearing certain fields in a Current Selections box when clickin on certain Ch...

    On sheet  6  Charts ,based  chosen options is shows related data in all charts,  however when  clikcing one  certain  Chart i want to automaticly  cle... Show More

    On sheet  6  Charts ,

    based  chosen options is shows related data in all charts, 

     however when  clikcing one  certain  Chart i want to automaticly  clear one  off the  choosen option showing in the

    choosen option list box 

    for that clikced chart

    now i have to that manualy

    Show Less

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

Data Revolution Virtual Summit

The new normal requires a new approach to data. Join this event to learn about the latest trends and approaches for accelerating value from your data.

October 27 - 29, 2020 Virtual Summit

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