Qlik Community

Ask a Question

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
4,146 online
Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources. Prep for the big move: READ DETAILS

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

    QlikView App Dev

    Set analysis not working

    Hi,Wondering if anyone can help me with a set analysis issue. The below expression works if I make the week number = to 38 (our current week for repor... Show More

    Hi,

    Wondering if anyone can help me with a set analysis issue. The below expression works if I make the week number = to 38 (our current week for reporting) or equal to a variable that also equals 38, however if I were to change the value to any other number the cell goes to null, despite their being a value for all 52 weeks. Curiously despite me using set analysis the expression is also influenced by selecting the week filter, so if choosing anything other than the current week (38) the cell will return a null value. Hopefully I've explained this issue well enough.

     

    Expression:

    Sum(Aggr(Sum ({$<Week={37},Year={$(vLFLCurrYr)},Date=,[Retailer Status]={'OPEN'},
    IT_System_Week= > } DISTINCT [Budget Nett Sales]),[Week],[Retailer Code],[HRL Finance Group]))

    Show Less
  • forum

    QlikWorld Discussions

    Insight Advisor Discovery

    A recent update to Insight Advisor is that there is a new “Discovery” button that generates insights without you having to navigate away from the curr... Show More

    A recent update to Insight Advisor is that there is a new “Discovery” button that generates insights without you having to navigate away from the current sheet. It is no longer a landing view with its own navigation point in the top toolbar. Its new location will improve your consumption of data within the sheet! And "Ask Insight Advisor" search box is always visible within dashboards, allowing you to easily generate insights using natural language processing.

    Tell us how you like the new navigation below!

    Visit this QlikWorld 2021 breakout session led by @Steven_Pressland  for a deeper dive on how to make the most out of the capabilities using Insight Advisor.navigation gif.gif

    Show Less
  • forum

    Brasil

    Função Above em Datas

    Bom dia a todos. Tenho uma tabela que mostra o Código de um chamado e todos os status que este chamado passou. Eu precisava gerar uma coluna na tabela... Show More

    Bom dia a todos. 

    Tenho uma tabela que mostra o Código de um chamado e todos os status que este chamado passou. 

    Eu precisava gerar uma coluna na tabela onde ele calculasse o tempo em que o chamado ficou em cada status (acredito que teria que usar a função ABOVE para realizar esta tarefa. Mas não entendi como ela pode ser usada.

    Depois que eu calcular esses tempos totais de cada chamado eu preciso exibir a soma de todos os tempos subtraindo o tempo em que o chamado ficou com o Status 'AGUARDANTO TERCEIROS' 

    Não sei se no próprio ABOVE eu posso gerar um IF para que quando a coluna de status for Aguardando terceiros ele coloque o tempo a seguir como ZERO.

    paulokpk_0-1632316234823.png

     

    Show Less
  • forum

    New to Qlik Sense

    Qliksense Calendar Chart

    Hello Qlik Enthusiasts , I want to have a little calendar where i can choose a particular date for example, 02-04-2022 and then get all the records wh... Show More

    Hello Qlik Enthusiasts , 

    I want to have a little calendar where i can choose a particular date for example, 02-04-2022 and then get all the records which would be expired until this date. The date is as follows . 

    Student , Document, Expiration Date, Document Status 

    101, Doc1, 12-03-2021, Expired 

    102, Doc2 , 12-09-2022, Valid

    103, Doc3, 12-11-2021, Valid 

    104, Doc4, 31-12-2021, Valid

     

    for now i am calculating status if the expiry date is less than today then its expired. But i want to have a calendar where i can choose a particular date and get all the expired certifcates until that particular date. For example,if i select 31-12-2021 then i would like to get the following output . 

    Student , Document, Expiration Date, Document Status 

    101, Doc1, 12-03-2021, Expired 

    102, Doc2 , 12-09-2022, Valid

    103, Doc3, 12-11-2021, Expired

    104, Doc4, 31-12-2021, Expired

     

    Please help me solve this , Thank you for your valuable time in Advance. 

    Show Less
  • forum

    New to Qlik Sense

    different date functions

    LOAD * Inline [date,sales23-10-2018,10020/11/2018,20015-12-2018,30018 jul 2018,400];how to convert this into single date format 
  • forum

    New to Qlik Sense

    Selecting few values and creating calculated dimension for pivot table

    Hey everyone,I am working on a Pivot table which has to be built based on an already created table chart. The table looks something like this:Store Nu... Show More

    Hey everyone,

    I am working on a Pivot table which has to be built based on an already created table chart. 

    The table looks something like this:

    Store NumberStore nameAccount numberAccount typeAmount
    1ABC1234L73
    1ABC2536M932
    1ABC6666L46
    2PQR8726O15
    2PQR1234L126
    3XYZ2536M87
    3XYZ9287P36
    3XYZ6666L98

     

    I do not want all the account types in the pivot. I am trying to get only account types 'L','M', and 'O' into the Pivot and calculate the % of total by diving the amount with the sum of all amount for that particular account number, and displaying only the topmost value for that account number, which would look something like this:

    Store numberstore nameaccount numberaccount typeamount% of total
    2PQR1234L12663.31%
    3XYZ6666L9868.05%
    1ABC2356M93291.46%
    2PQR8726O15100%

     

    This would have been a very simple  SQL query had I been working on that, but I am new to Qlik and this seems more complicated.

    I read a couple of responses in other forums which suggest creating a variable but I am not sure how would that help me because I am kind of like grouping it by the account number. 

    Any help or suggestions is highly appreciated.

    Thank you!

    Show Less
  • forum

    New to Qlik Sense

    ytd expression error

    =Sum({<OrderDate={">=$(=yearstart(addyears(max(OrderDate)),-1)<=$(=addyears(max(OrderDate)),-1))}>"}Sales)this expression showing error[error in set m... Show More

    =Sum({<OrderDate={">=$(=yearstart(addyears(max(OrderDate)),-1)<=$(=addyears(max(OrderDate)),-1))}>"}Sales)

    this expression showing error[error in set modifier expression]

    how to resolve it

    Show Less
  • forum

    Qlik Education Discussions

    Course Enquiry

    Hello Folks,Could someone tell me? that Is there any MS Course for learning Qlikview in Italy,India,USA,NZ. if so? what could be the course name & Ple... Show More

    Hello Folks,

    Could someone tell me? that Is there any MS Course for learning Qlikview in Italy,India,USA,NZ. if so? what could be the course name & Please share the details......

    Awaiting for responses...

    Show Less
  • forum

    Qlik NPrinting Discussions

    Delete the history of Nprinting generated reports

    Good morning,i noticed that when i generate the reports with the button on my qlik sense app, it is displayed with all the others generated previously... Show More

    Good morning,
    i noticed that when i generate the reports with the button on my qlik sense app, it is displayed with all the others generated previously. Is there a possibility to delete them after they have passed a period of time?

    Example: Type that reports generated before yesterday are cleared.

    And is it possible to automatically block the reports that have been generated for a long time?

    Example: Type if a report takes more than 10 minutes to generate it crashes.

    I hope I was as clear as possible!

    Cattura.PNG

    Show Less
  • forum

    QlikView App Dev

    Neglecting subcategory after uploading data

    Hi there,I need to provide a table with schedulers and their products, but my excel data base contains schedulers from other units I need to exclude w... Show More

    Hi there,

    I need to provide a table with schedulers and their products, but my excel data base contains schedulers from other units I need to exclude without changing the excel file.

    When using if or wildmatch in the table collums my whole column shows no values.

    Is there an easy way to

    1) make qlik neglect those schedulers I dont need after loading the data, like an if or filter function in the data preparation?

    Thanks a lot and stay healthy

    Andi

    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