Qlik Community

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

    New to Qlik Sense

    Splitting Quarter data into trailing 13 months and getting columns for month and...

    I am trying to split my quarter data into trailing 13 months and also the years, I am not sure how to do this. I have posted the original logic for th... Show More

    I am trying to split my quarter data into trailing 13 months and also the years, I am not sure how to do this. I have posted the original logic for the quarter data. So I need the columns 'Monthstart()' and 'Yearstart()' Please help!

     

    Original formula for Quarter data column

    =SUM(IF(QUARTERSTART(OT_Period)='10/01/2020',OT_Overtime_YTD))

     

    The 'OT_Overtime_YTD' is the dollar amounts. Essentially the columns would be. 

     

    Region/Location/Employee/Monthstart()/Yearstart()

     

     

    Show Less
  • forum

    Qlik NPrinting Discussions

    Send report with NPrinting November 2020 to FTP

    Hi,It's possible send report generate from NPrinting November 2020 directly to FTP? Best regards,Sr. Esneider,
  • forum

    Deployment & Management

    Sheet Actions Not Working

    We are trying to set up an action on sheet to 'select values in a field' - the action should be that when the sheet is opened the current 'Month-Year'... Show More

    We are trying to set up an action on sheet to 'select values in a field' - the action should be that when the sheet is opened the current 'Month-Year' is selected from the MonthYear field - but it does not currently work.

    We are using the formula Date(Today(),'MMM-YYYY') to find today's Month-Year, this returns the value 'Mar-2021', and we can see that we have a value of 'Mar-2021' in our MonthYear field. When we close the app and reopen, or just navigate away from the sheet and then back to it, the selection is not applied.

    We have tried replacing the formula with a hard-coded text string  of 'Mar-2021' and this also does not work.

    Has anyone else experienced this issue in SaaS?

    Show Less
  • forum

    QlikView App Dev

    Looking for some help understanding parameters and variables

    Hello,In an effort to get a better understanding of variables, set analysis and $ expansion, I have a question:In QlikView, I have this table:MonthNum... Show More

    Hello,

    In an effort to get a better understanding of variables, set analysis and $ expansion, I have a question:

    In QlikView, I have this table:

    MonthNumberSales
    1100
    2300
    3125
    4175
    5400
      

    I also have this variable:

     

    vSalesSoFar = sum({< MonthNumber = {"<=$1"} >} ROW_COUNT)

     

     

     In a TextBox, when I enter this expression:

     

    =$(vSalesSoFar(4))

     

    I get the result, 700, as expected. It is summing Month Numbers that are less than or equal to 4.

    In the table, when I add this expression:

     

    =$(vSalesSoFar(MonthNumber))

     

    I get 0.

    My first question is: Why doesn't the expression see the MonthNumber as the parameter?

     

    To check this, I changed the expression to actually enter a number, in the table:

     

    =$(vSalesSoFar(4))

     

    I get 700 on each row, which makes sense to me.


    Then I created this variable:

     

    vMonthPlus = $1 + 10

     

    When I entered this expression in the table:

     

    =$(vMonthPlus(MonthNumber))

     

    I get the correct output on each row:

    MonthNumbervMonthPlus
    110
    220
    330
    440
    550


    My second question is: What is the difference between the two variables that the MonthNumber is recognized in one (vMonthPlus) but not the other (vSalesSoFar)?

    Thank you.

    Show Less
  • forum

    Deployment & Management

    Butler Qlik Reload Alert configuration

    Hi,Has anyone installed and configured Butler Tool from qlik garden to generate reload alerts?https://community.qlik.com/t5/Qlik-Gallery/Ptarmigan-Lab... Show More

    Hi,

    Has anyone installed and configured Butler Tool from qlik garden to generate reload alerts?

    https://community.qlik.com/t5/Qlik-Gallery/Ptarmigan-Labs-Butler-open-source-reload-alerts/ba-p/1799056

    If yes, can you please let me know the steps you have followed for successful alert.

    The documentation in Butler website is slightly confusing.

    Thanks

    Show Less
  • forum

    App Development

    Qlik Sense Charts are not counting unique values

    I have a bar chart that is acting as if I input the DISTINCT function into my set analysis when I haven't. There are 2 'Alerts' that have records in 2... Show More

    I have a bar chart that is acting as if I input the DISTINCT function into my set analysis when I haven't. There are 2 'Alerts' that have records in 2 different 'Areas', so the alert key is doubled, but the chart only counts them once each. If i break up the set analysis by one of the dimensions and add them together the count works properly. I can't find a setting or something that explains this behavior. Anyone else have this happen? How can I make it count them?

    sique132_0-1623360984314.png

    sique132_1-1623360994736.png

    sique132_2-1623361003150.png

     

    sique132_3-1623361014618.png

     

     

    Show Less
  • forum

    QlikView App Dev

    QV 12 Testing - QMC Error

    Hi,We are upgrading from v11 to v12.  I have a document that I can reload manually from QV desktop.  When I try and schedule this document in QMC it f... Show More

    Hi,

    We are upgrading from v11 to v12.  I have a document that I can reload manually from QV desktop.  When I try and schedule this document in QMC it fails with the following error in the Log file :

    ERROR - EXECUTE Command Failed. AllowExecuteCommand setting violation detected.


    I'm trying to copy a QVD from one folder to another after it has been created. I have checked that these are selected in user preferences :


    doc_settings.PNG


    Is there anything else I can try?


    Thanks,


    Phil

    Show Less
  • forum

    QlikView Administration

    Create YYYYMM and Year field in script from a date field

    Hi,I have a field in my script called "Ordering_Date", the format of this column is set as a date (see attached image). I would like to create another... Show More

    Hi,

    I have a field in my script called "Ordering_Date", the format of this column is set as a date (see attached image). I would like to create another field that essentially is a column that captures just the year and month, in the format "YYYMM" from the Ordering_Date field  as well as a column that captures just the year. Would this be a convert formula? What should I add to my script to load those two requested columns?

    Please advise.

     

    Thanks in advance,

    Clem

    Show Less
  • forum

    New to Qlik Sense

    Getting values based on a string match in another column of chart type table

    Hi all,I am new to Qlik and have been working on a table visualization. Unfortunately, I cannot share the actual data and hence I am using examples li... Show More

    Hi all,

    I am new to Qlik and have been working on a table visualization. Unfortunately, I cannot share the actual data and hence I am using examples like 'abc''xyz'...I have a column in my table chart, where every row contains either the string 'discount' or the string 'Policy' along with other words. I have another column (amount) which contains the corresponding values for these. 

    It looks something like this....Again, the chart type is Table

    TypeAmount
    abc discount30
    xyz policy100
    abc discount80
    xyz policy50

     

    I want to create two separate columns  'Discount Amount' and 'Policy Amount' which will get the values from 'Amount' depending on whether the column contains 'Discount' or 'Policy' ad have the column totals at the top.

    What I'm trying to get is as follows:

    TypeDiscount amountPolicy Amount
     110150
    abc discount30-
    xyz policy-100
    abc discount80-
    xyz policy-50

     

    Any help with this is highly appreciated. 

    Thanks!

    Show Less
  • forum

    New to Qlik Sense

    Showing only data with the last append date

    I am looking for a method to only show data that comes from the last append date from my data source. My data looks like this:[Current Date] | [Employ... Show More

    I am looking for a method to only show data that comes from the last append date from my data source. My data looks like this:

    [Current Date] | [Employee ID] | [Office]  | [Job Title]

    01/01/2021       | John Adams     | Tokyo     | Sales

    01/01/2021       | Mark Smith       | Chicago | Analytics

    01/01/2021       | Dan Williams    | London  | Illustrator

    01/01/2020       | John Adams     | Tokyo     | Sales

    01/01/2020       | Mark Smith       | Chicago | Analytics

    01/01/2020       | Dan Williams    | London  | Illustrator

    01/01/2020       | Mary Carter       | Oxford    | Receptionist

    01/01/2019       | Mark Smith       | Chicago | Analytics

    01/01/2019       | Dan Williams    | London  | Illustrator

    01/01/2019       | Mary Carter       | Oxford    | Receptionist

     

    I want the final data to look like this in the app:

    01/01/2021       | John Adams     | Tokyo     | Sales

    01/01/2021       | Mark Smith       | Chicago | Analytics

    01/01/2021       | Dan Williams    | London  | Illustrator

     

    As you can see, I pulled all the data from the most recent data the was appended to my dataset. I need this to be an expression that I add to formulas for charts, tables, and KPIs - it cannot be a restriction in the data load editor (because the full dataset is used is a section of the app).

    Does anyone have a formula or something that can help me do this?

    Thank you!

    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