Qlik Community

Ask a Question
Welcome to Qlik Community
cancel
Showing results for 
Search instead for 
Did you mean: 
2,300 online
Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video

Data Analytics Forums

Forums for Qlik Data Analytics solutions. Ask questions, join discussions, find solutions, and access documentation and resources.

Data Integration Forums

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.

Product Insight & Ideas

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

Qlik Resources

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

Events

Learn about upcoming Qlik related events, webinars and local meetups.

Blogs

Hear directly from Qlik employees in our ten unique blogs.

About Qlik Community

Get started, find How-To documents, and join general non-product related discussions.

Community Sitemap

Here you will find a list of all the Qlik Community forums.

Recent Discussions

  • No Boards Found
  • forum

    QlikView App Development

    Selection/calcualtion runs slow (timeout) using web client, but fine in QV Deskt...

    We have a QV application which have problems with tiemout during calculation/selection when running the application using QVS/QWS and web client. We h... Show More

    We have a QV application which have problems with tiemout during calculation/selection when running the application using QVS/QWS and web client. We have an interface where the user can select which fields to display including calculated aggregated columns and the columns are displayed in a table object. This slection would result in one row being displayed in the table box (using probably 5000 rows in the underlying table for the aggregated column). When the user selects the calculated column it take a very long time and get calculation error after about 2 min (probably IE timeout). 

    I took the qvw file and loaded in Qlikview desktop and same selection/calculation finish in 5 seconds. 

    The qvw file is 1.8 GB, 202 mill rows and is about 6 GB loaded. 

    I notice we get the same problem in our test environment. Not the same data and smaller (1.1 GB). Our test QVS/QWS server has 32 GB memory. When executing the calculation I notice how memory usage increase from about 5 GB for QVS up to take all availab le memory (and not ever finishing before timeout).

    When using QV desktop memory usage is about 6GB all the time (more of course when displaying more data in UI).

    What can cause this? I understand that running through QVS/QVWS and web client is slower but not like this. Also the application worked fine some time ago with same amount of data. 

    Show Less
  • forum

    QlikView App Development

    Show missing data as 0

    Hi All,I've a country eg ABC, it's data is missing in source DB for weeks 12, 13, 14, 17 and 50.As I already have a master calendar, so I can see miss... Show More

    Hi All,

    I've a country eg ABC, it's data is missing in source DB for weeks 12, 13, 14, 17 and 50.

    As I already have a master calendar, so I can see missing weeks as grayed out (Excluded) in list box.

    Is there any way I can show data as 0 for those missing weeks in a line chart.

    List of dimension and measures used in line chart.

    Dimension - Week

    Measure - Count(app_Id)

     

     

    Regards,

    Sumit

     

     

     

    Show Less
  • forum

    Qlik Sense Deployment & Management

    Port 9200 (Qlik License Service) does not come up after changing ciphers in serv...

    Greetings!We are following the instructions provided by Qlik's documentation to change the ciphers used in port 9200 (Qlik License Service).  We chang... Show More

    Greetings!

    We are following the instructions provided by Qlik's documentation to change the ciphers used in port 9200 (Qlik License Service).  We changed to section on [license.parameters]  in service.conf as shown below, but now the port does not come up

    [licenses.parameters]
    -qsefw-mode
    -cipher-suites=TLS_RSA_WITH_AES_256_GCM_SHA384,TLS_RSA_WITH_AES_128_GCM_SHA256
    -app-settings="..\Licenses\appsettings.json"

    We are running a single node instance of QSE June 2020 Patch 3 (13.82.11) on Windows Server 2012 R2 Standard.

    Has anyone had a similar problem?  If so, how did you solve it?

    Please advise.

    Cheers,

    ++José

    Show Less
  • forum

    Qlik Connectors Discussions

    Expired Connectors

    Do the Qlik Connectors have to be re-installed on a regular basis? We're using the May 2019 and they recently stopped working due to 'LICENCE_TIME_LIM... Show More

    Do the Qlik Connectors have to be re-installed on a regular basis? We're using the May 2019 and they recently stopped working due to 'LICENCE_TIME_LIMIT_EXCEEDED'. The solution given is to update to the latest version. That isn't practical to do without time to test and make sure it doesn't cause issues. So basically these become unusable to us if they have to be updated after a set period of time or they stop working. 

    Thanks in advance.

    Show Less
  • forum

    New to Qlik Sense

    Chart dimension skipping some values for the measure

    Hello everyone,Here is what I am trying to do: I have for each product ID the monthly sales forecast in one table, and then in another one for each ID... Show More

    Hello everyone,

    Here is what I am trying to do: I have for each product ID the monthly sales forecast in one table, and then in another one for each ID and for each site I have one line per daily orders. Also, I have another table with the dates where I can ship (removing weekends for example).

    I am trying to have a chart where I would be able to see for the current month (for the dates I have loaded) how am I progressing compared to the forecast, with the forecast just increasing every day by the monthly value divided by the number of days, and then seeing a cumulating line with the orders up to that day.

    I have tried naming my calendar field in the same name as the order days to show them on the same graph, and using the below two formulas to get my two lines:

     

    rangesum(above(sum(Forecast)/vNumberOfDays, 0, rowno()))
    rangesum(above(sum(order_volume), 0, rowno()))

     

    My problem with this is the following: the forecast is only calculated for the days where there are shipments, otherwise it is not calculated, resulting in a false value at the end (some days are skipped in the graph and the line is not increasing), and the graph ends at the latest date where there is a shipment, not the last one of the calendar.

    On the picture below, the end value should be around 1.4k, and as we can see a new forecast value is only calculated where there is an order one.

    etiennesan_0-1611550409582.png

    Do you have any idea on how to do this? Is it possible to display the order line by comparing the order date with the shippable date in the dimension?

    Thank you for your help!

    Show Less
  • forum

    Qlik Sense SaaS & Multi-Cloud

    Are apps with nPrinting impacted when migrated to QlikCloud?

    Hi folksWe are migrating our apps/dashboards to QlikCloud, including a couple that generate nPrinting output and from what I am reading it looks like ... Show More

    Hi folks

    We are migrating our apps/dashboards to QlikCloud, including a couple that generate nPrinting output and from what I am reading it looks like nPrinting isn't yet integrated with QlikCloud (maybe this has changed 🤞)

     

    I was wondering if anyone has come across what might happen to the apps and their nPrinting output as and when they get reloaded in QlikCloud. 

     

    Would be great to see if anyone has gone through this already and advise whether we maybe need to change the app in the short term. Or perhaps leave that app on Enterprise on-premise for the time being

     

    Kindest Regards

    Jonna

    Show Less
  • forum

    Qlik Connectors Discussions

    problem with Jira Connector and Labels?

    Hello, I have and issue with the Jira web connector and Jira label: when in a given Jira issue I have several different labels, the connector only ret... Show More
    Hello, I have and issue with the Jira web connector and Jira label: when in a given Jira issue I have several different labels, the connector only returns one (see screenshot). Anybody experience the same issue? Thanks in advance, Show Less
  • forum

    New to Qlik Sense

    BOXPLOT limit days

    Hello,I want to represent the last 6 days of data as a boxplot but I'm having dificulties.I don't know exactly where should I enter the expression.So ... Show More

    Hello,

    I want to represent the last 6 days of data as a boxplot but I'm having dificulties.

    I don't know exactly where should I enter the expression.

    So I have as Box field City,  as X-AXIS the Date and on the measure the averge of sales(avg sales).

    Normally if no data/interval of data is selected I would show the last 6 days. If I put on the X-AXIS the expresion my boxplot breaks and I get "the chart is not displayed because it contains only undefined values"

    Expression the X-AXIS  for the last 6 days

    =IF(GetSelectedCount(DateAll)>0, Date(DateAll,'DD-MMM'),
    if(DateAll<='$(=YESTERDAY)' and DateAll>='$(=YESTERDAY-6)',Date(DateAll,'DD-MMM')))

    What am I missing here? AmI suppose to use an agg on the avg(sales) ?

    Show Less
  • forum

    Qlik Sense App Development

    Date record creation based on existing dates of MSL

    Dear Community,Your help is appreciated for the below question. Thanks in advance!!AS shown below one MSL has Created Dates in months of june,july,dec... Show More

    Dear Community,

    Your help is appreciated for the below question. Thanks in advance!!

    AS shown below one MSL has Created Dates in months of june,july,december. Now i have to generate records so that each ME will have created dates > then the existing dates and less than the Max(created date) for this MSL also each ME will have Created Date month in the list of months MSL has got. and Response Score should be of latest month avaiable for that ME.

    MSL IDME IDCreated DateResponse Score
    1101july5
    1102june4
    1102july5
    1103december2
    1104june3

    So in this case records generated must be as below:

    Explanation: MSL Months= June, July, December. Now ME ID 101: He has record of July, so the next month in MSL list is December so in below table you see december record created.

    For ME ID 102: already June, july are existing and nxt mnth in msl list is December, so this record is created in below table.

    For ME ID 103: December is the latest mnth for this me and this month is the last month in MSL List. So we need not do anything for this record.

    For ME ID 104: THis ME has record in june. Nxt months in the list of MSL are july and december ; so these two records are created as below.

    MSL IDME IDCreated DateResponse Score
    1101december5
    1102december5
    1104july3
    1104december3

    And this has to be reated for more than one MSL.

    Show Less
  • forum

    Community Corner

    Qlik Community: Published document is not visible for Qlik community users

    Hi Community members/Qlik Community Site Manager,I have published a QlikView document in Qlik community underQlik Community --> Data Analytics Forums ... Show More

    Hi Community members/Qlik Community Site Manager,

    I have published a QlikView document in Qlik community under

    Qlik Community --> Data Analytics Forums --> QlikView --> QlikView Documents.

    The document is visible only under my login. It is not visible for community members. I don't know the reason.

    I need your help to make my document visible again to community members.

    Thanks

    Pradeep

    Show Less

Get Started On Community

Start Here Get Started On Community

Top Participants

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.

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

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