Qlik Community

Welcome to Qlik Community

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

This forum will provide you with event highlights and related content to get you energized and ready for QlikWorld Online.

Here you will find Qlik Sense resources, partake in interesting discussions, solve problems and foster relationships with Qlik experts from around the globe.

Thank you for joining us in the QlikView Forum, your home for QlikView answers. Discover insights within your data that can transform your business.

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

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!

Qlik partners with leading technology companies to develop integrations, extensions, and connectors to the Qlik platform.

Discussion Boards and Documents for Qlik Services.

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.

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

Recent Discussions

  • No Boards Found
  • forum

    Community Corner

    Set analysis expression for min and max date by default

    Hi All,i need a chart calculation which is sum (sales) has to shown for latest 10 days by default if there is no date selection made. if any date sele... Show More

    Hi All,

    i need a chart calculation which is sum (sales) has to shown for latest 10 days by default if there is no date selection made. if any date selection done then show accordingly. attached the sample data. Please help. 

     

    TIA

    Show Less
  • forum

    New to QlikView

    Opportunities "QlikView"

    There are 5 columns of 10 variables.Can the program:1. Select all possible combinations2. Find the most common matches
  • forum

    New to QlikView

    Rest Api Api calls submitted to the Qlink cloud account has a response OK but u...

     Hi,I tried to made Api Calls (Create App) to Qlink cloud account through postman and the result response was Ok. But, i was not able to view on them ... Show More

     Hi,

    I tried to made Api Calls (Create App) to Qlink cloud account through postman and the result response was Ok. But, i was not able to view on them UI. Is it possible to push JSON data into Qlink cloud account through REST API ? I was unable to find documentation regarding the same and some help topics suggest it is not STABLE and may be changed in future. Can you please let me know how to proceed or any suggestions how to fix this issue ?

    qqqqqqqq.png

     

    wwww.png

     

    Thanks & Regards,

    Chethan Y 

    Show Less
  • forum

    New to Qlik Sense

    Formula for Tochar

    Hello Team,I am not able to include this formula in Qlik sens.Please  can any one  help me out :ToChar ( Original_XYZ_No, "0" ) + " "+ ToChar ( Origin... Show More

    Hello Team,

    I am not able to include this formula in Qlik sens.Please  can any one  help me out :

    ToChar ( Original_XYZ_No, "0" ) + " "+ ToChar ( Original_XYZ_Date, "0" )

     

    Thanks in advance

    Regards

    RK

    Show Less
  • forum

    New to Qlik Sense

    Qliksense: SQL query reached limit despite increasing the query timeout

    Hi,I am trying to load data the table from MySQL server with 21,924,639 rows like the following: [sales_transactions]: SELECT `business_date`, cashie... Show More

    Hi,

    I am trying to load data the table from MySQL server with 21,924,639 rows like the following:

     

    [sales_transactions]:
    SELECT `business_date`,
    	cashier,
    	`check_closed`,
    	`check_no`,
    	`grand_total`,
    	`net_sale`,
    	`store_code`,
    	`store_id`,
    	`transaction_id`
    FROM `xxx_master_of_the_house`.`sales_transactions`
    //LIMIT 3000000
    ;
    
    STORE * FROM [sales_transactions] INTO [lib://../SALES_TRANSACTIONS.QVD](qvd);
    drop table [sales_transactions];

     

    However, I keep running into this error message below.

     

    Error: ERROR [HY000] [Qlik][MySQL] Query execution was interrupted, maximum statement execution time exceeded
    Execution Failed
    Execution finished.

     

     I have already increased the timeout session in QMC to 999 before loading the table.

     

    CUSTOM CONNECT TO "provider=QvOdbcConnectorPackage.exe;driver=mysql;host=xx.xx.xx.xx;port=xxxx;db=xxx_master_of_the_house;SSLMode=PREFERRED;UseTrustStore=false;QueryTimeout=999;"

     

    Is there any other way that I am able to load the data without exceeding the maximum statement execution time?

    Show Less
  • forum

    New to Qlik Sense

    Main App with multiple apps

    HiIs it possible to have the following (as in image) in Qlik Sense, I have seen similar designs in QlikView.Where Sales Forecast Profit Loss are butto... Show More

    Hi

    Is it possible to have the following (as in image) in Qlik Sense, I have seen similar designs in QlikView.

    Where Sales Forecast Profit Loss are buttons or something similar and when you click on it, this will take you to another app and display the dashboard their.

    Also how can you set the app to go directly to the dashboard rather than main page where it shows all sheets.

    As we are using multiple data sources the apps are different.

    Thanks

    Annotation 2020-07-03 164006.png

    Show Less
  • forum

    New to Qlik Sense

    Iteration of the values

    Hi,I have requirement to do the looping until all the values in the column has changed to first value. Please find the below example sample dataOrder ... Show More

    Hi,

    I have requirement to do the looping until all the values in the column has changed to first value. Please find the below example sample data

    Order no,Line item,High Line Item

    345678,15,10

    345678,20,15

    345678,25,20

    345678,30,25

    For the second row high line item is 15  its is indirectly point to line item 15 is pointing to high level item 10 and the output for the second line higher line item should be 10 same for the others. I need to implement this logic on the huge data sets where there will be more number of line items

    Expected output:

    Order no,Line item,High Line Item

    345678,15,10

    345678,20,10

    345678,25,10

    345678,30,10

    Regards & Thanks,

    Chetan

    Show Less
  • forum

    Qlik Sense Advanced Authoring

    Listbox with one selected value

    Hi Guys,Please let me know how to implement the below logic.I need to have 2 listboxes as filter. First filter (a dropdown) has years 2019, 2020 and 2... Show More

    Hi Guys,

    Please let me know how to implement the below logic.

    I need to have 2 listboxes as filter. First filter (a dropdown) has years 2019, 2020 and 2021 and second filter also a dropdown which has months in it (Jan to Dec). All these are static or harcoded values (using inline table) and not coming from any field association i.e. no date fields/columns are associated to these filters. The issue is when Iam selecting 2019 and then March, all the 3 years are selected for March and shown in the report, whereas I just need to show only March values for only 2019 in the report. How to achieve this?

    Show Less
  • forum

    QlikView App Development

    MOSTRAR SOLO ULTIMOS 90 DIAS

    Hola buen día,Soy nueva, recurro a ustedes porque necesito que la siguiente expresión me traiga solo los últimos 90 días desde hoy. Le puse WeeKsAgo p... Show More

    Hola buen día,

    Soy nueva, recurro a ustedes porque necesito que la siguiente expresión me traiga solo los últimos 90 días desde hoy. 

    Le puse WeeKsAgo pero no estaría bien ya que me cuenta semanas completas donde pueden haber mas de 90 días.  También agregué Num(Today(0)-90) pero no me funciona para lo que quiero. 

     

    COUNT (distinct{<[Opportunity.CustName],
    State ={'REAP','TRMITA','TRMITP','TRMITR','VENCIDA','ACEP'},
    Progress ={"40"},
    [Opportunity.TransDate.autoCalendar.WeeksAgo]={0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15},
    LoanProduct = {"Prendarios"}
    >} [Opportunity.CustName]) 

     

    Gracias!

    Show Less
  • forum

    QlikView Scripting

    Best Way to Breakout Balance Field Incrementally

    I was just curious, as it comes up a lot, but is there an easier way to create a balance range than the script below? We also use an input box version... Show More

    I was just curious, as it comes up a lot, but is there an easier way to create a balance range than the script below? We also use an input box version where to enter the range you want, but then if we end up with too many calculated dimensions in a report using that input box, it really affects the performance of the report.  So, is there an easier function to take something like a balance and just say break it out in $100 increments as a new field? Look forward to hearing how others tackle this. 

     

    IF(ACCT_BALANCE<=200,'<200',
    IF(ACCT_BALANCE>=200 AND ACCT_BALANCE<=400,'200-400',
    IF(ACCT_BALANCE>400 AND ACCT_BALANCE<=600,'400-600',
    IF(ACCT_BALANCE>600 AND ACCT_BALANCE<=800,'600-800',
    IF(ACCT_BALANCE>800 AND ACCT_BALANCE<=1000,'800-1000',
    IF(ACCT_BALANCE>1000 AND ACCT_BALANCE<=1500,'1000-1500',
    IF(ACCT_BALANCE>1500,'1500+'
    ))))))) AS BalanceRange

    Show Less

Top Participants

Blogs

Qlik Community Manager Blog

Hear from the Qlik Community team about the latest platform enhancements for April and May 2020.

Blogs

Customer Success Blog

Read all about Qlik's Voice of the Customer program and Customer Success initiatives.

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

Qlik Customers Share COVID-19 Supply Chain Strategies

Amazon Produce Network and Odyssey Logistics discuss how they’re using Qlik to help manage their operations during Covid 19

On Demand Webinar

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