Qlik Community

Welcome to Qlik Community

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

Welcome to the Qlik Alerting Product Forum! Join in on the discussion around Qlik’s intelligent alerting solution for Qlik Sense! This is an open group to share and collaborate!

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

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

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.

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!

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

Recent Discussions

  • No Boards Found
  • forum

    QlikView Layout & Visualizations

    Filter using "and" and "Or" on the same field

    I have a field that contains codes for products. some of these products can have more than one code at the same time.I want to give the user the abili... Show More

    I have a field that contains codes for products. some of these products can have more than one code at the same time.

    I want to give the user the ability to filter products by Product Code as follows:

    get all product which has the following codes:  CodeA and CodeB and (CodeC or CodeD)

    Please notice that the product can have either codeC or codeD but not both at the same time, that's why I can not use "and" in addition to the other two code (CodeA and CodeB)

     

    Please advise me on how can I apply this in Qlikview?

    Show Less
  • forum
  • forum

    QlikView Layout & Visualizations

    Conditional Coloring in a Bar Chart with different color

    Hi,I Want Different Colors on a Bar Chart(Grouped ) Side by Side with Two dimensions on X_Axis. .I don't want to Stacked Bar Chart.would like to displ... Show More

    Hi,

    I Want Different Colors on a Bar Chart(Grouped ) Side by Side with Two dimensions on X_Axis. .I don't want to Stacked Bar Chart.

    would like to display Two different Colors like Green and Orange based on the Period Selection with dark and light based on actual versus forecast.

    1) The Actual bars (IT & NonIT) should be dark Green and Orange

    2) The Forecast bars (IT & NonIT) should be light Green and Orange

    Example1: If user select the period 2+10, the Jan and Feb should be dark and the rest will be light colors

    Example2: If user select the period 4+8, from Jan to Apr should be dark and the rest will be light colors

    Period = 4+8Period = 4+8

    Will you please verify the attached SampleData and QVW and need your support to achieve on this.

    Thanks in advance!!!

    Show Less
  • forum

    New to Qlik Sense

    Dynamic Text in Qlik Sense Table - like Python f-string: print(f'My text {Var1}'...

    HiI am trying to put together signals for users based on some kind of data conditions. There will be a set of different rules, that will grow over tim... Show More

    Hi

    I am trying to put together signals for users based on some kind of data conditions. There will be a set of different rules, that will grow over time. Each rule has a specific explanation text for the user. To handle the data from a multiple rules, a standardized result table is defined.

     

    The problem: How can I show the user the explanations containing the data dynamically.

     

    Example Data (please ignore if the data makes sense or not!)

    [Signal_Results]:

    ID, Rule_ID, Val1, Val2
    1,1,10,20
    2,1,30,40
    3,2,5,15

     

    [Signal_Static]:

    Rule_ID, Explanation
    1, Combination A was identified at {Val1} with product {Val2}
    2, Temperature Exception was set to {Val1}. Measured {Val2}

     

    Required Output in Qlik Sense table:

    ID 1 -> Combination A was identified at 10 with product 20
    ID 2 -> Combination A was identified at 30 with product 40
    ID 3 -> Temperature Exception was set to 5. Measured 15

     

    In python this could be solved with a print(f”Combination A was identified at {Val1} with product {Val2}”)

     

    How can I dynamically show the descriptions in Qlik Sense without having to output complete descriptions in my Signal_results table?

     

    Thanks for your help!

    Show Less
  • forum

    QlikView Publisher

    QV Publishers reloads some documents but not others after 12.5 upgrade

    We just upgraded to 12.5.  We have many documents that the publisher processes nightly.  Some of the documents reload just fine while others do not.  ... Show More

    We just upgraded to 12.5.  We have many documents that the publisher processes nightly.  Some of the documents reload just fine while others do not.  We think there might be something with the documents themselves because the same documents do not reload.  I just cannot figure out what needs changed in the document.

    For the documents that the publisher does not reload, when I open them in the client and reload the data, it works just fine.  The same credentials are used to connect to the source DB by the Publisher and the client.

    Here is a sample of the Task Log from the publisher:

    (12/4/2020 7:47:20 AM) Information: DistributeTask[0124f698-90ce-49cb-9bc2-06b76ef207a6] ("filename.qvw"): TryStart - Starting task. Triggered by 'ManualStartTrigger'. Id:00000001-0002-0003-0405-0607080a0b0c. ExecID:a5105d44-c804-47bb-a1bf-b0ea2e1049a4

    (12/4/2020 7:47:20 AM) Information: Entering Task Execution.

    (12/4/2020 7:47:20 AM) Information: ClusterID=1

    (12/4/2020 7:47:20 AM) Information: QDSID=f0893642-d647-b123-dcbf-6e722fedb1b3

    (12/4/2020 7:47:20 AM) Information: TaskID=0124f698-90ce-49cb-9bc2-06b76ef207a6

    (12/4/2020 7:47:20 AM) Information: ExecID=a5105d44-c804-47bb-a1bf-b0ea2e1049a4

    (12/4/2020 7:47:20 AM) Information: MaxRunTime=00:10:00

    (12/4/2020 7:47:20 AM) Information: MachineName=QLIK-PUB

    (12/4/2020 7:47:20 AM) Information: Task execution max attempts=1

    (12/4/2020 7:47:20 AM) Information: Task execution current attempt=1

    (12/4/2020 7:47:20 AM) Information: Task Dependencies are OK

    (12/4/2020 7:47:20 AM) Information: The task "filename.qvw" is starting

    (12/4/2020 7:47:20 AM) Information: Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.

    (12/4/2020 7:47:20 AM) Information: Opening "filename.qvw"

    (12/4/2020 7:47:20 AM) Information: Allocating new QlikView Engine. Current usage count=4 of 5 (of type non-reader).

    (12/4/2020 7:47:20 AM) Information: Max retries:5

    (12/4/2020 7:47:20 AM) Information: Attempt:01

    (12/4/2020 7:47:21 AM) Information: Opened the QlikView Engine successfully. ProcessID=413596

    (12/4/2020 7:47:21 AM) Information: Allocated QlikView Engine successfully. Current usage count=5 of 5 (of type non-reader). Ticket number=50.

    (12/4/2020 7:47:21 AM) Information: Loading document "filename.qvw" (0.14 Mb)

    (12/4/2020 7:47:21 AM) Information: Physical FileSize=0.14 Mb. Memory Allocation Delta for this file=3.14 Mb. Available Physical Memory Before Open=60247.42 Mb. Available Physical Memory After Open=60243.92 Mb. Total Physical Memory=65535.55 Mb.

    (12/4/2020 7:47:21 AM) Information: Attempted to load the document without data.

    (12/4/2020 7:47:21 AM) Information: The document was loaded successfully.

    (12/4/2020 7:47:21 AM) Information: Document was opened successfully

    (12/4/2020 7:47:21 AM) Information: Starting reload

    (12/4/2020 7:47:21 AM) Information: The Source Document is being reloaded. DocumentPath=filename.qvw

    (12/4/2020 7:47:22 AM) Information: Reloading.

    (12/4/2020 7:47:23 AM) Information: Reloading..

    (12/4/2020 7:47:24 AM) Information: Reloading...

    (12/4/2020 7:47:25 AM) Information: Reloading....

    (12/4/2020 7:47:26 AM) Information: Reloading.....

     

    This Reloading... message repeats until the timeout is reached.

    In the document settings Generate Logfile is checked.  However, here is the message from the Document Log tab from the QMC:

    (Document Log) : No document log found for the specific task run (check if Generate Logfile is enabled).

     

    Any ideas what I should try next?

     

    Show Less
  • forum

    New to Qlik Sense

    set analysis help

    Hello.I am creating a simple report in Qlik. I have created the QVD and pulling through the fields into the app.I am trying to understand how to manip... Show More

    Hello.

    I am creating a simple report in Qlik. I have created the QVD and pulling through the fields into the app.

    I am trying to understand how to manipulate the report to show results based off some rules?

    An example of some rules I am trying to implement are: 

    Compare Bound date and inception date:
    If Transaction date < Inception date then include in the report
    If Transaction Type = “New Business” then include in the report extract if:
    Policy effective date > reporting date 

    If the Transaction Type = “Renewal” then include in the report extract if:
    Policy Effective date > reporting date 

     

    I have the Transaction Type dimension in the table, as well as effective date and the reporting date (reload date of the report). however I am trying to undestand how to implement those rules into the set anaylsis? Can someone please help to allow me to understand how to do this? I do have some measures, such as Sum (gwp) field. any help please would be greatly appreciated, 

    Show Less
  • forum

    QlikView Layout & Visualizations

    Relative in a stacked chart: relative to only the dimension value, not total

    Hi, I'd like a stacked bar chart to show the % of calls from each dimension values, relative to the higher hierarchy dimension, not to the total of th... Show More

    Hi, I'd like a stacked bar chart to show the % of calls from each dimension values, relative to the higher hierarchy dimension, not to the total of that specific dimention.

    sibrulotte_0-1607205050266.png

     

    I would like the % to represent the % of the month, not the whole dimension.

    Ex: the value for SAÉ for november is 473, the total for Externes is 404, for a total of 877. 

    So % should be 53.9% and 46.1% respectively. 

     

    How should I structure my data to make it possible?

    Show Less
  • forum

    New to Qlik Sense

    Error en licencia qlik sense

    Hola!Soy nuevo en qlik sense, estoy tratando de activar una licencia ya firmada pero me aparece el error: The license key is not  valid. Ya valide la ... Show More

    Hola!

    Soy nuevo en qlik sense, estoy tratando de activar una licencia ya firmada pero me aparece el error: The license key is not  valid. Ya valide la conexión a https://license.qlikcloud.com Alguien sabe el motivo de este error. Y otra duda alguien sabe como puedo identificar mi partner de Qlik, ya que hace mucho que se realizo la compra de esta licencia.

     

    Les agradezco mucho, Saludos!

    Show Less
  • forum

    Qlik Alerting Discussions

    Alerting triggered from QMC and "Qlik Alerting Monitoring app"

    Hi team ..I had Qlik Sense and Qlik Alerting June 2020, I did an upgrade to September 2020. But I have 2 issues.1.- I scheduled a task in QMC and the ... Show More

    Hi team ..

    I had Qlik Sense and Qlik Alerting June 2020, I did an upgrade to September 2020. But I have 2 issues.

    1.- I scheduled a task in QMC and the alert message is not triggered. I published the app in a stream without success. But, if I triggered the alert from the Web Alerting console .. I receive the email alert.

    Any Tips?

    2.- I am trying to use “Qlik Alerting Monitoring.qvf”, but when I reloaded the app, I received the following error:

    The following error occurred:

    The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. The remote certificate is invalid according to the validation procedure.

    The error occurred here:

    Connection: LOAD [token],

     ******* I have the 2 data connections, it was run the BAT file.

    Thanks a lot

    Gabriel

    Show Less
  • forum

    Qlik Alerting Discussions

    distribute alerts to groups or individual users

    Hi, Is it possible to limit the groups or the individuals a user can distribute his alerts to?e.g. HR users can only distribute alerts to users of the... Show More

    Hi,

     

    Is it possible to limit the groups or the individuals a user can distribute his alerts to?

    e.g. HR users can only distribute alerts to users of the same HR department, Finance users to other finance users, etc.

     

    Kr

    Thomas

    Show Less

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

Data Revolution Virtual Summit

The new normal requires a new approach to data. Join this event to learn about the latest trends and approaches for accelerating value from your data.

October 27 - 29, 2020 Virtual Summit

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