Qlik Community

Ask a Question
Welcome to Qlik Community
cancel
Showing results for 
Search instead for 
Did you mean: 
1,824 online
Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY

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

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.

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.

Qlik Academic Program

Enabling professors and students with data and analytics.

About

Get started, 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

    Japan

    粗利金額を挿入したい

    特定の軸(フィールド)が条件を満たした場合、粗利金額を挿入する方法があればご教示ください。例えば、売上金額 10,000円に対して粗利が空白だとします。そこに特定の軸の条件を満たすレコードの粗利金額は売上金額10,000円×0.5=5,000円と自動で挿入したいのです。ちなみに粗利率は固定で大丈夫で... Show More

    特定の軸(フィールド)が条件を満たした場合、粗利金額を挿入する方法があればご教示ください。

    例えば、

    売上金額 10,000円に対して粗利が空白だとします。そこに特定の軸の条件を満たすレコードの

    粗利金額は売上金額10,000円×0.5=5,000円と自動で挿入したいのです。

    ちなみに粗利率は固定で大丈夫です。0.5(50%)です。

    難しいのは特定の軸の条件を満たさないレコードには正しい粗利金額が既に入っております。

    何か良い方法はございますでしょうか?

    Show Less
  • forum

    App Development

    Current liabilities KPI

    Hi My Friends... I have the next Expression in Table or KPI Graphics...=num((Sum(Aggr(if(sum({<[ACCNT_CODE]={"32*","33*","34*","12*","13*","14*","132*... Show More

    Hi My Friends... I have the next Expression in Table or KPI Graphics...

    =num((Sum(Aggr(if(sum({<[ACCNT_CODE]={"32*","33*","34*","12*","13*","14*","132*","133*","134*","135*","136*","137*","138*", "A*", "E*", "R*"}, [FUND]={"10*"}, [YearPeriod]=, [MonthYearPeriod]={"<=$(=max(MonthYearPeriod))"}, [MonthPeriod]=>}[AMOUNT]) >= '0.000',
    sum({<[ACCNT_CODE]={"32*","33*","34*","12*","13*","14*","132*","133*","134*","135*","136*","137*","138*", "A*", "E*", "R*"}, [FUND]={"10*"}, [YearPeriod]=, [MonthYearPeriod]={"<=$(=max(MonthYearPeriod))"}, [MonthPeriod]=>}[AMOUNT]),0),ACCNT_CODE))),'#,##0.00')

    The result is as follows:

    JASalinas_0-1623809310019.png

    But In other Accounting Program the result is as follows:

    JASalinas_1-1623809628799.png

    It does not show me those two accounts because they had no movement in the current month,

    I need you to show them to me even if they have no movements in that month

    Thanks in advance!...

     

    Show Less
  • forum

    Security & Governance

    Qlik Support - Case Ticket

    I have created a case ticket at Qlik Support, unfortunately I have uploaded sensitive information. Any possibility to edit or delete the comment?I hav... Show More

    I have created a case ticket at Qlik Support, unfortunately I have uploaded sensitive information. Any possibility to edit or delete the comment?

    I have tried but no options. Can any one help.

    Thank you

    Show Less
  • forum

    App Development

    Restricting month rows to a range

    Hi,I'm new to Qliksense and have a problem i've been trying to find a solution on.I am able to create a table such as the below which is pulled from a... Show More

    Hi,

    I'm new to Qliksense and have a problem i've been trying to find a solution on.

    I am able to create a table such as the below which is pulled from an excel sheet to show in the visualisation. 

     

    MonthABCRemarks
    Apr-1994839552  
    May-19102694956  
    Jun-191005051757  
    Jul-1992242509  
    Aug-1994082338  
    Sep-1977458256  
    Oct-19118299281  
    Nov-19110946264  
    Dec-19887193  
    Jan-2014265266  
    Feb-207020425682060 
    Mar-208868639582455 
    Apr-2014805675583210 
    May-2065484226385473 
    Jun-2031624220087673Remarks are here
    Jul-205723128887961 
    Aug-205791931688277 
    Sep-206100846788744 
    Oct-207474845189195 
    Nov-207254950089695 

     

    However, i have 2 different sheets, one for FY2020 (Apr 2020-May 2021) and the other for FY2019 (Apr 2019-May 2020). I would like each sheet to restrict to the relevant rows that are shown. So for the first sheet FY2019 , i want it to show months Apr 2019 - May 2020 only such as the below. In fact, i have created the variable FY2019 to be ">=Apr-19<=Mar-20" and hoped to use this in the visualisation somewhere but can't figure out where or how.

    In the visualisation i've added the columns as dimensions but not sure how i can further filter them to how i want them. Do help.

    MonthABCRemarks
    Apr-1994839552  
    May-19102694956  
    Jun-191005051757  
    Jul-1992242509  
    Aug-1994082338  
    Sep-1977458256  
    Oct-19118299281  
    Nov-19110946264  
    Dec-19887193  
    Jan-2014265266  
    Feb-207020425682060 
    Mar-208868639582455 
    Apr-2014805675583210 
    May-2065484226385473 
    Show Less
  • forum

    New to Qlik Sense

    Loading a Picture Into Qlik

    Hi, I am building a dashboard for a team and would like to put a team logo into the dashboard. How do I upload a picture to be used in the dashboard? ... Show More

    Hi, 

    I am building a dashboard for a team and would like to put a team logo into the dashboard. How do I upload a picture to be used in the dashboard? 

     

    Thanks!

    Show Less
  • forum

    New to Qlik Sense

    Linking loaded tables

    Hi All, I have two files that I need to link and I cannot figure out the best way to do it.  The first file has two items user_ID and user_name.  The ... Show More

    Hi All, 

    I have two files that I need to link and I cannot figure out the best way to do it.  

    The first file has two items user_ID and user_name.  The second has multiple columns of data with names of people that hold job positions such as role_1, role_2, etc.  The challenge is that these are Sharepoint lists and the export from Sharepoint only gives you the user_ID for each of these roles.  I thought I could map these during the load, but I would need to map each of the columns back to the user file and unless I am wrong, mapping is only to connect one column.

     

    Is there a way to create a master item that matches the number in  role_1 to the user_ID field in the User Info List.  In this example Role_1 = 15, User_ID 15 = zimmermann, amber.  I want the role_1 for Cafeteria to show Zimmermann, Amber.  Is this possible?

    User List:

    IDtitle
    14Smith, Fred
    15Zimmermann, Amber
    16Doe, Jane

     

    Role List:

    Locationrole_1role_2role_3
    Market141615
    Store161514
    Cafeteria151416

     

      Desired view:

    Locationrole_1role_2role_3
    MarketSmith, FredDoe, JaneZimmermann, Amber
    StoreDoe, JaneZimmermann, AmberSmith, Fred
    CafeteriaZimmermann, AmberSmith, FredDoe, Jane

     

    It would be great if there was a way to load these (btw...this is only a paired down example, I have about 20 roles that have these unique ids), but I am also okay with creating 20 master items.  Anyone know how I can achieve this?

    Thanks in Advance!

    Show Less
  • forum

    App Development

    Boxplots and set analysis

    Hi community,I'm working woth the June 2017 release of Qlik Sense Desktop, and I'm fighting with boxplots. I want boxplot for workers and their sales,... Show More

    Hi community,

    I'm working woth the June 2017 release of Qlik Sense Desktop, and I'm fighting with boxplots. I want boxplot for workers and their sales, and a boxplot independent by selection of the single worker.

    The first boxplot is quite easy.

    dimension: worker

    measure: Sum(sale)

    Then I would like a boxplot independent by the selections of the worker, to compare the worker's behaviour with an overall behaviour.

    dimension: worker

    measure: Sum({$<[worker]=>}sale)

    The problem is there: set does not works properly (maybe my mistake).

    Attached an app with the example, and also a pie chart that is independent from worker selection.

    I'm frankly doubtful, because for example R does not need a dimension for a boxplot, here a simple example (different data, but you can easily understand) with the result:

    boxplot(x<-c(1,2,4,2,5,7,2))

    Rboxplot.PNG

    But Qlik yes, and maybe this is the key.

    However, my question is: can I have a boxplot independent by selections? If so, also independent by its dimension? And how?

    Thanks in advance

    EDIT:

    It seems there is a bug in Qlik, could you help me?

    Dirk Scharffetter, Jeffrey Goldberg, Mattias Malre Michael Tarallo

    EDIT:

    Posted in the Qlik Bug Group

    Boxplots and Set Analysis

    Show Less
  • forum

    Search the Community

    Precio qliksense en 2014 o 2015

    Me pueden ayudar, estoy buscando el costo de Qliksense en 2014 o 2015, alguien tendrá este dato por favor Saludos
  • forum

    QlikView App Dev

    Year End Calendar - Week Issue

    Hello, I’m looking for some assistance please with the Calendar that is used on QlikView. It’s the Master Calendar that affects all our production QVD... Show More

    Hello, I’m looking for some assistance please with the Calendar that is used on QlikView. It’s the Master Calendar that affects all our production QVDs so I’m afraid to make too many changes to it.

    My colleague who looked after the calendar at Year End has left the company and I’m still relatively new in the role and feeling some pressure to resolve 😊

    What is happening is that Fiscal Week 1 2021 is showing as Fiscal Week 53 2021.

    I need to split out the weeks, however, they are currently showing as below:

    • Fiscal Week 52 2020 –> 19/12/2020 – 25/12/2020
    • Fiscal Week 53 2020 -> 26/12/2020 – 29/12/2020 (Year End 29/12/2020)
    • Fiscal Week 53 2021 -> 30/12/2020 – 01/01/2021 (This needs to be Fiscal Week 1 2021)
    • Fiscal Week 2 2021 -> 02/01/2021 – 08/01/2021

    This is the way the calendar is showing at the moment for Jan 2021:

    podge2019_0-1610537454983.png

    Fiscal Week 2021-53 is showing the below dates:

    podge2019_1-1610537454989.png

    Fiscal Week 1 is showing from 02/01/2021 to 08/01/2021 – so essentially looking to remove the Fiscal Week 2021-53 and have it as Fiscal Week 1 and the current Fiscal Week 1 becomes Fiscal Week 2.

    I’ve attached the calendar script (with some data removed) we currently have so any guidance or assistance would be appreciated.

    Show Less
  • forum

    QlikView Integrations

    Bookmark

    HolaI have a shared bookmark in qlikview, how can I set that bookmark as default, so each time I open qlikview the bookmark is activated thanks!!  Show More

    Hola

    I have a shared bookmark in qlikview, how can I set that bookmark as default, so each time I open qlikview the bookmark is activated 

    thanks!! 

    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 QlikView.

May 18, 2021 10AM EST

Events

Qlik Insider - Webinar Series

This webinar will cover key new capabilities that drive Active Intelligence in your organization, helping your users go beyond the dashboard, to collaborate and take action at the point of decision.

May 26, 2021