Qlik Community

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

    New to Qlik Sense

    Line chart - Display dimension with the same values

    Hi  everyone,I have the "Date" and "Price" fields in a table.I would like to have a line chart in which the fields "Date" are displayed as a dimension... Show More

    Hi  everyone,

    I have the "Date" and "Price" fields in a table.

    I would like to have a line chart in which the fields "Date" are displayed as a dimension and "Price" as a KPI.

    The raw data looks like this:

    DatePrice
    01.01.202110,50
    02.01.202112,00
    02.01.202113,00
    02.01.202113,50
    03.01.202111,00

     

    If there are several prices for a date, Qlik does not display a price for the day and does not display the date in the diagram.

    Is it possible that ALL values are shown to me in a line chart? Or is that not possible with a line chart? If not, do you have a suggestion for a nicer and better representation?

    I hope you can help me 🙂

    Show Less
  • forum

    App Development

    Avoid filter on agregate funtcion

    Hi Community!We're facing an undesirable behavior in an agregation funcion working with filters.I'll try to explain myself with screenshots and expres... Show More

    Hi Community!

    We're facing an undesirable behavior in an agregation funcion working with filters.

    I'll try to explain myself with screenshots and expresions.

    We have a table with YearMonth dimension  and an aggr expresion:

    Sum({<$(vSetRolling12Modifier)>}Aggr(Rangesum(Above(count({<$(vSetRolling12Modifier)>}[ID Llamada Entrante]),0,12)), ([Año-Mes], (Numeric, Ascending)) ))

    with this expression we want to show, for every yearmonth, the number of "ID Llamada Entrante" in that month and previous 11  (for 2021-june, the amount of 2020-july -> 2021-june; for 2021-may, the amount of 2020-june -> 2021-may)

    Where $(vSetRolling12Modifier) =

    [Date]=,[Day]=,[Weekday]=,[Year]=,[Month]=,[Quarter]=,[YearMonth]=,
    [_MonthSerial] = {">=$(=Max({1<$(_f_DateIsFuture)={0},_Qvc.DummyField=$(_Qvc.Calendar.v.SelectedFieldList_)>} [_MonthSerial]) - 11)<=$(=Max({1<$(_f_DateIsFuture)={0},_Qvc.DummyField=$(_Qvc.Calendar.v.SelectedFieldList_)>} [_MonthSerial]))"}

    We use vSetRolling12Modifier to avoid calendar filters and to take into account the previous 12 months

    It works fine when we don't apply filter (data has been validated):

    Aggr 1.PNG

     

     

     

     

     

     

     

     

     

     

    But when we apply a YearMonth filter, previous months data changes, wich is no correct.

    Aggr 2.PNG

     

     

     

     

     

     

     

     

     

    Can someone help us to reach the correct expression?

     

    Thanks in advance.

     

    Regards,

    Alonso Torres.

    Show Less
  • forum

    QlikView Administration

    Qlikview application greyed out after opening properties window

    Good morning,I have a very frustrating issue at the moment. I have been working on a Qlik dashboard, however when I was using the properties option fo... Show More

    Good morning,

    I have a very frustrating issue at the moment. I have been working on a Qlik dashboard, however when I was using the properties option for one of my charts I think I clicked off the Properties window and now it's returned me to the main app, but everything is greyed out and I can't click on anything on the application, dashboard or toolbar options. I also can't get back into the properties dialog box to close that down.

    Any help would be great as I fear I may need to close the app losing my work.

    Thanks 

    James

    Show Less
  • forum

    New to Qlik Sense

    costs

    Good morning,I'm trying to link a cost to a specific person. I've got a type of cost and a final date until when that cost is linked.For example the d... Show More

    Good morning,

    I'm trying to link a cost to a specific person. I've got a type of cost and a final date until when that cost is linked.

    For example the date 10/02/2020 is < of 31/07/2020 then the 70 will be linked to pippo and so on....

    How can i do it? If there isn't a date it means that it still works now.

    TAB1:

    LOAD * inline [
    COST, NAME, FINAL_DATE,
    GD56YTG, pippo, 31/07/2020,
    GD56YTG, teo,,
    FF56YTG, gino,];

    TAB2:

    COST,  DATA,  VALUE,
    GD56YTG,10/02/2020,70,
    GD56YTG,11/06/2021,30,
    GD56YTG,20/05/2021,40,
    FF56YTG,20/05/2021,40

    Show Less
  • forum

    Qlik Cloud Data Services

    CosmosDB Connection on Qlik Hosted

    Hello, I have a free tier account of hosted Qlik Sense and I'm trying to ingest my CosmosDB data.The several documents I found e.g. https://support.ql... Show More

    Hello,

     

    I have a free tier account of hosted Qlik Sense and I'm trying to ingest my CosmosDB data.

    The several documents I found e.g. https://support.qlik.com/articles/000077160 cannot help me. The option ODBC in the source type is not displayed for me. Other documents suggest to install a connector but since the service is hosted, I don't have this capacity. Can you help me on this?

    Thank you

    Guillaume

    Show Less
  • forum

    New to Qlik Sense

    Cumalative YTD

    Dear Qlik Community, I am stuck in creating a YTD and need your help.Please look at the table below, i have the Col 2 - Nb of Projects and Col 3 - MTD... Show More

    Dear Qlik Community, I am stuck in creating a YTD and need your help.

    Please look at the table below, i have the Col 2 - Nb of Projects and Col 3 - MTD values. I need to calculate the YTD value

    YTD = weighted average of MTD & Nb. of Projects

    For ex - YTD for Jan-2021 = (80*5)/5 = 80%

    YTD  for Feb - 2021 = (80*5 + 50*6)/(5+6) = 63.63% and so on

    Year/MonthNb. Of ProjectsMTDYTD
    2021-Jan580%80%
    2021-Feb650%63.63%
    2021-Mar760% 
    2021-Apr870% 
    2021-May520% 
    2021-Jun430% 
    2021-Jul520% 
    2021-Aug410% 
    2021-Sep120% 
    2021-Oct830% 
    2021-Nov240% 
    2021-Dec350%

     

       

     

     

    Can some1 help me to create the last column in set analysis using the YTD formula described above? in case of any questions feel free to reach out to me

    Best,
    Akash

    Show Less
  • forum

    New to Qlik Sense

    How to get field Data using REST API using Postman

    I want to extract field data through REST API.  But I am unable to find the best Url to get it. 
  • forum

    Ideation Discussions

    Scroll bar position not preserved

    The scroll bar moves to the left when cyclic dimension is changed.▼object・pivot table・set cyclic group dimension・enable [Preserve Scroll Position]▼pro... Show More

    The scroll bar moves to the left when cyclic dimension is changed.

    ▼object
    ・pivot table
    ・set cyclic group dimension
    ・enable [Preserve Scroll Position]

    ▼procedure
    1. Open the attached sample.qvw file in QlikView Desktop.
    2. Move the scroll bar to the right end.
    3. Change cyclic dimension.
    4. Move the scroll bar to the right end.
    5. Change cyclic dimension.
    6. You can see the scroll bar was moved to the left.

    I want to specify the position of the scroll bar.

    Show Less
  • forum

    Integration, Extension & APIs

    Qlik Sense App and mashup: how the engine works

    Hi,I wanted to know how the Qlik Sesne App and Mashup work on server.I need to know the process/work flow like I have a app with mashups.https://serve... Show More

    Hi,

    I wanted to know how the Qlik Sesne App and Mashup work on server.

    I need to know the process/work flow like I have a app with mashups.

    https://servername/extensions/appmashup.html

    this mashup has dropdowns, KPIs, charts, all are calculated using lists and hypercubes.

    what happens if I open this page? what request sent to QS server? 

    what Qlik Engine do in this case? 

    will Qlik Engine first loads the app on to memory (RAM) then creates calcuations using Hypercube?

    hypercubes use calculation memory or is it separate memory? 

    Show Less
  • forum

    QlikView Administration

    Using QVS API to add users to distribution list

    Hi,I have a question: is there a way to utilize QVS API to add users to distribution list in QlikView?And is there a proper documentation for QVS API ... Show More

    Hi,

    I have a question: is there a way to utilize QVS API to add users to distribution list in QlikView?

    And is there a proper documentation for QVS API for the people who want to call API methods directly from Linux command line (not using C# or PowerShell)? This, as far as I know, is possible using cUrl (at least based on the article below), but I couldn't find an appropriate documentation with all the methods available. 

    https://community.qlik.com/t5/Knowledge-Base/QlikView-Call-QMS-API-with-cURL/ta-p/1717004?_ga=2.149617782.1737571661.1626944753-1696473308.1560249751

    I know a similar question has been asked before (https://community.qlik.com/t5/QlikView-Administration/QMS-API-add-remove-AD-user-to-Publisher-task/td-p/787012 ). However, there is no accepted answer in this thread.

    Best regards,
    Vlad

    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