Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
6,742 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 App Development

    Date special period

    Hi!Hope every one is healthy at this time!I have a question. I need a "special period" for Employee Time evaluation in cause of covid! Thank you covid... Show More

    Hi!

    Hope every one is healthy at this time!

    I have a question. 

    I need a "special period" for Employee Time evaluation in cause of covid! Thank you covid! 😉

    I need this Periods for exampe

    month march and year 2020 = Value march2020

    months march and april and year 2020 = april2020

    months march, april, may and year 2020 = may2020 

    .... to (for example June2021)

     

    if i chose the value june2020 automaticly them months march, april, max, june and year 2020 should be choosen.

    Perhaps i think to complicated but i found no solution for this problem.

    Do you have any idea?

     

    Thanks Roland

    Show Less
  • forum

    New to QlikView

    Chaining two Charts togetther and synchronize the Axis

    Hey guys,can you do something like that in Qlikview? would be awesome because right now I took two charts and it looks like chained together but actal... Show More

    Hey guys,

    can you do something like that in Qlikview? would be awesome because right now I took two charts and it looks like chained together but actally it isnt.

    So does Qlikview have this feature?

     

    Picture.png

    Show Less
  • forum

    QlikView App Development

    Get max invoice date by customer and item number when selecting a date in dashbo...

    Hello,I'd really appreciate some help. I have a requirement, in which I need to get the max of invoice date that is <= to the date a user will select ... Show More

    Hello,

    I'd really appreciate some help. I have a requirement, in which I need to get the max of invoice date that is <= to the date a user will select in the dashboard. Basically, we have monthly sales files coming in and for example, if I select the Jan 2019 file, I need to get the latest invoice by item and customer before the end date of that fiscal month for all of the items listed in that file. 

    Example:

    I have 3 invoices (coming from my invoice table and joining to the file via item number)

    Customer ,Item#, InvoiceNumber, InvoiceDate

    A, 1234, 786599,1/25/2019

    A, 1234, 99999, 12/22/2018

    A, 1234, 70888, 1/11/2019

    The end of the fiscal month for the Jan 2019 file will be 1/27/2019, which is the Date field. So, the invoice I'd want to get when the user selects that file/date is the first one with date 1/25/2019.

    The problem is, if I use Max(Aggr(Max({<InvoiceDate = {"<=$(=Date)"}>} InvoiceDate),Customer,ItemNumber)), I'm able to get that date, but it gives me a completely random invoice in my dimension. I mean, it'll give me an invoice for that item and customer, but it does not match my expression. For example,  in this case, it'll give me the invoice with date 12/22/2018, when it should give me the one with date 1/25/2019. I've tried doing this in the script, I've tried using FirstSortedValue as well. I don't quite understand where the issue is.  Each item number will have multiple invoices by different customers, and I just want the latest one for comparison to see if our invoice price matches what is in the file. Any input will be appreciated.

    Thank you.

    Show Less
  • forum

    New to Qlik Sense

    Grouped Bar Chart different colors for each measure

    Hello All,I have a scenario in Qlik Bar Chart, which grouped.I have 1 dimension ( date field) and 2 measure ( sales and pre-sales). I have reference l... Show More

    Hello All,

    I have a scenario in Qlik Bar Chart, which grouped.I have 1 dimension ( date field) and 2 measure ( sales and pre-sales). 

    I have reference line which is average of sale for the entire date range.

    I have implement color of bars based on expression.

    If the bar is above Average Sales the bar color is red and if it is below Average Sales bar color is green.

    Problem is I also want to have different colors for the Sales Bar and Pre-Sales Bar which are grouped in same date.

    Is there a way to achieve this ?

    Image21.PNG

    Image22.PNG

    Image23.PNG

    Image24.PNG

        

    Show Less
  • forum

    Qlik Sense Integration, Extensions, & APIs

    Adding External Users in QMC

    Is it possible to add external users to QMC  through API, Actual scenario is I have List of users in SQL Server DB and I want to add them in QMC. The ... Show More

    Is it possible to add external users to QMC  through API, Actual scenario is I have List of users in SQL Server DB and I want to add them in QMC. The problem is I don't want to add them using ODBC User Directory Connection  (i.e. restrict access to the database, instead will provide the API).

    Any thoughts/suggestion, will much appreciated.

    Show Less
  • forum

    New to Qlik Sense

    Can't open my Qlik Sense Destop

    Hi Folks, i have a  question, do we have any technical problems whithin Qlik Sense?I am not able to open my Qlik Sense Desktop, if i am trying to open... Show More

    Hi Folks,

     

    i have a  question, do we have any technical problems whithin Qlik Sense?

    I am not able to open my Qlik Sense Desktop, if i am trying to open, i have this view (see the attached screen)

    Show Less
  • forum

    New to QlikView

    Set Expression for the expected output

     Dear All,I need a set expression to be written for the last record (RA001A0000030).  This is how it was possible on a simple if statement such as ...... Show More

     

    Dear All,

    I need a set expression to be written for the last record (RA001A0000030).  This is how it was possible on a simple if statement such as ......IF([B/B/F]<500000 AND [B/B/F]+ADJUSTMENT>500000,[B/B/F]+ADJUSTMENT-500000)). Any idea please?

     

    Thanks

    Neville

    CLAIM NUMBERCLASS B/B/F  PROVISION  PAID  ADJUSTMENT  B/C/F 
    RA001A0000025MC                -         600,000     -                       -         600,000
    RA001A0000027MC     600,000            150,000       750,000
    RA001A0000028MC  1,000,000           (300,000)       700,000
    RA001A0000029MC             600,000       600,000
    RA001A0000030MC     250,000            300,000       550,000
    Show Less
  • forum

    Qlik Sense App Development

    Full load at specific time interval

    Hi folks,Greeting for the day. I need assistance for loading data at perticular time frame. At present I'm looking for loading data on hourly bases an... Show More

    Hi folks,

    Greeting for the day. I need assistance for loading data at perticular time frame. At present I'm looking for loading data on hourly bases and capture the load time in some variable, so I can depict that on report.

    I have a script which load and modify data. Should like to update at hourly bases. At present from csv file, but once got link with DB then directly. 

    For any query please write back.

    Regards,

    Sagar.

    Show Less
  • forum

    New to Qlik Sense

    How to display in HTML all the value of get selections using extensions

    Hi, I'm new to Qlik Sense and can't figure out the right code to display the get selected items on the div or front end view of a extension.Below is t... Show More

    Hi, I'm new to Qlik Sense and can't figure out the right code to display the get selected items on the div or front end view of a extension.

    Below is the code that I'm using. (I'm using Extension for Qlik Sense desktop)

    extSelect.PNG

    I can get the selected value with this code and display it on the browser console.

    I have searched and have not find one of any documentation or examples of  displaying the selected value on a Qlik Sense Extensions. I have some requirements regarding how the selected fields should look. Below is the sample selected fields should look when a field is locked the object will go orange.

    this should be look of filter selectedthis should be look of filter selectedthis should be look when a field is locked the objectthis should be look when a field is locked the object

    Can anybody help me with the right code syntax?

    Show Less
  • forum

    New to Qlik Sense

    Location Tag field

    Can anyone clarify me with Tag location field in the below link.I just got confused with this question https://www.freecram.com/question/Qlik.QSDA2019... Show More

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