Qlik Community

Welcome to Qlik Community

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

May Qlik Alert You – 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!

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

    New to Qlik Sense

    Can I control two objects with the same filter if the objects reference differen...

      Do the tables need to be joined?Example:  Table 1:Country  HospitalsUSA           St Francis HospitalUSA           Thomas Jefferson Med. CenterCanad... Show More

      Do the tables need to be joined?

    Example:  

    Table 1:

    Country  Hospitals
    USA           St Francis Hospital
    USA           Thomas Jefferson Med. Center
    Canada     Montreal Medical Center




    Table 2:

    Country  Num_of_Patients
    USA           250,000,000
    Canada    90,000,000




    There are other visualization platforms where I can load the two tables without joining them, and then define the filters to control elements in both tables.  

    Is this possible in Qlik Sense?  Or do I need to join the tables when I load the data?

    If I do join the tables, do he joined fields have to have the same exact name?  Or is there a way to define them to be the same field?  (ie Country in one table might be called Country_Name in another).

    Thanks!







    Show Less
  • forum

    New to QlikView

    Qlikview truncate part of string

    Hi everyone,I ran a qlikview document to load data from my excel spreadsheet but noticed that some of the strings in a column was truncated. (for exam... Show More

    Hi everyone,

    I ran a qlikview document to load data from my excel spreadsheet but noticed that some of the strings in a column was truncated. (for example: 'Lee Hartman & Sons' became ' Sons').

    When I go to the excel document, copy that field, paste value to a new column and delete the old one, then reload the qlikview document, it works correctly.

    I suppose it's some setting in that excel column that doesn't work well with Qlikview. Does anyone know what might have caused this? I don't want to manually change this every time.

    Thank you!

    Show Less
  • forum

    QlikView Scripting

    Date# Value format error

    If I load only the Willow spreadsheet, I get "Field not found error Field '1/1/2019' not found". I have ensured the Excel formats are dates and I have... Show More

    If I load only the Willow spreadsheet, I get "Field not found error Field '1/1/2019' not found". I have ensured the Excel formats are dates and I have tried date#( [1/1/2019],'M/D/YYYY') as [1/1/2019],  and date#(num#(Month),'M/D/YYYY') as Month. For the life of me, I cannot figure out why.

     

    EPIC_HOURS_CROSSTABLE:
    UNQUALIFY*;
    CrossTable(Month, Hours, 😎
    LOAD [GPL Project #],
    [Ticket #],
    trim(subfield( subfield([Requesting Market],'/'),',')) as EPIC_MARKET,
    // if(wildmatch( trim(subfield( subfield([Requesting Market],'/'),',')),'CHI'),'National', trim(subfield( subfield([Requesting Market],'/'),','))) as EPIC_MARKET,
    [Project Name],
    Comments as HOURS_COMMENTS,
    //[Module for Hours],
    subfield(SubField([Module for Hours],'/',1),',') as [Module for Hours],
    [SA Assigned],
    Status as HOURS_STATUS,
    date#( [1/1/2019],'M/D/YYYY') as [1/1/2019],
    [2/1/2019],
    [3/1/2019],
    [4/1/2019],
    [5/1/2019],
    [6/1/2019],
    [7/1/2019],
    [8/1/2019],
    [9/1/2019],
    [10/1/2019],
    [11/1/2019],
    [12/1/2019],
    [1/1/2020],
    [2/1/2020],
    [3/1/2020],
    [4/1/2020],
    [5/1/2020],
    [6/1/2020],
    [7/1/2020],
    [8/1/2020],
    [9/1/2020],
    [10/1/2020],
    [11/1/2020],
    [12/1/2020],
    [1/1/2021],
    [2/1/2021],
    [3/1/2021],
    [4/1/2021],
    [5/1/2021],
    [6/1/2021],
    [7/1/2021],
    [8/1/2021],
    [9/1/2021],
    [10/1/2021],
    [11/1/2021],
    [12/1/2021],
    [1/1/2022],
    [2/1/2022],
    Column1
    FROM
    [..\External_Data\Epic Capacity Worksheet Willow.xlsx]
    (ooxml, embedded labels, header is 8 lines, table is Optimization, filters(
    Remove(Col, Pos(Top, 14)),
    Remove(Col, Pos(Top, 13)),
    Remove(Col, Pos(Top, 12)),
    Remove(Col, Pos(Top, 11)),
    Remove(Col, Pos(Top, 10)),
    Remove(Col, Pos(Top, 9))
    ));

     

    Final:
    LOAD [GPL Project #],
    [Ticket #],
    if(wildmatch(EPIC_MARKET,'CHI'),'National',EPIC_MARKET) as EPIC_MARKET,
    [Project Name],
    if(WildMatch([Module for Hours],'MyChart','EC Link','Care Everywhere') ,'Ambulatory',[Module for Hours]) as [Module for Hours],
    [SA Assigned],
    Hours,
    date#(num#(Month),'M/D/YYYY') as Month
    RESIDENT
    EPIC_HOURS_CROSSTABLE
    where addmonths(monthstart(date(today())),-1)>=Month;
    //where today()-1>=Month;

    Drop TABLE EPIC_HOURS_CROSSTABLE;

     

    Show Less
  • forum

    Qlik NPrinting Discussions

    NPrinting Scheduled Reports

    How do I send a customized message when NPrinting scheduled reports to be delivered by email do not generate any data. Thanks for your suggestions.
  • forum

    Qlik Sense Advanced Authoring

    说的话结果发生的风格就是电话qweqweqwe

    但就是功夫就红色的功夫就红色的功夫就红色的国家和分公司asdasdasdasd
  • forum

    Qlik NPrinting Discussions

    NPrinting19: Send PDF as attachment and not via .zip file

    Hi, I am working on some reports with an excel template that we need to send out as PDF Reports attached to an email. Some users may receive a single ... Show More

    Hi, 

    I am working on some reports with an excel template that we need to send out as PDF Reports attached to an email. Some users may receive a single report while others may receive multiple reports in the same email. 

    When I first began working on these reports, I sent out an email to myself to make sure the variables in the email body worked and the attachment was just the report itself as a pdf. However, now when the reports get sent out, whether its a single report or multiple reports, the attachment is a .zip file. 

    We shifted these reports from NPrinting16 so the end users are used to and prefer receiving these reports as PDFs attached to the emails they receive. I was unable to find a way to change the attachment type and was wondering if anyone has any suggestions as to how I can remove the .zip file and just keep the PDF attachment.

    Thank you!

    Show Less
  • forum

    New to Qlik Sense

    Max Year as Set Expression

    Hi,I need to be able to have a paired bar chart where 1 bar can be filtered by year BUT is always the average for all responses. The other bar can be ... Show More

    Hi,

    I need to be able to have a paired bar chart where 1 bar can be filtered by year BUT is always the average for all responses. The other bar can be filtered by year and is specific company response.  Currently my expressions are;

    Group Average:  = avg ( distinct {1<QPermID={"AM0425_R*"}>} Response)

    Company Response:  = MAX( distinct {$<QPermID={"AM0425_R*"}>} Response)

    If I want to change the year, the Company Response responds as expected.  I can filter by a specific company and a specific year.  However, with a set expression of '1', my Group Response doesn't change.  

    In other expression in my app, I use the orange expression below. This allows the Group response to always be the max year and it will also change to whatever is the max year that I've selected in my filter...

    =(Avg({1<Year = {$(=Max(num#(Year ,'####')))}>} Aggr(Sum({1<QPermID={"AM0425_R_1*"}>}Response),YearID,Year)))

    I have tried placing {1<Year = {$(=Max(num#(Year ,'####')))}>} into my group and company responses for the paired bar, but they are ignored.  The expression isn't broken, it just doesn't get applied. That means my Group Average is always inclusive of all years of data. 

    In my example App,

    • Sheet 1 "Example Bar" shows the data.  It's already set to max year.  The average for that data is 46.4.
    • Sheet 2 "Paired Bar" shows my objective graph.  The average for the far left bar should also be 46.4.  However, because it doesn't respond to filter nor my Max Year expression ({1<Year = {$(=Max(num#(Year ,'####')))}>}) it's using all year's data and instead results in an average of 52.8.

    I'm open to a whole new expression as long as it gets me what I need.  Thanks

    Show Less
  • forum

    New to QlikView

    Convert Year Month and Week Begin Date from sql to load script

    Can you please help me convert the 2 below sql scripts into load statements?1)  Concat(CONVERT(VARCHAR,[Calendar Year]),iif(len(CONVERT(VARCHAR,[Calen... Show More

    Can you please help me convert the 2 below sql scripts into load statements?

    1)  Concat(CONVERT(VARCHAR,[Calendar Year]),iif(len(CONVERT(VARCHAR,[Calendar Month Number]))=            1,'0'+CONVERT(VARCHAR,[Calendar Month Number]),CONVERT(VARCHAR,[Calendar Month Number]))) AS YEAR_MONTH

    2)  DATEADD(DAY, 2 - DATEPART(WEEKDAY, [Calendar Date]), [Calendar Date]) AS WEEK_BEGIN_DATE

     

    Thank you in advance!

    Show Less
  • forum

    New to Qlik Sense

    Dashboard, Cambio de divisas

    Saludos Colegas,Alguien ha realizado Dashboard que realice cambio de divisas o monedas, osea de Euro a Dollars, si es posible porfavor orientarme.Grac... Show More

    Saludos Colegas,

    Alguien ha realizado Dashboard que realice cambio de divisas o monedas, osea de Euro a Dollars, si es posible porfavor orientarme.

    Gracias

     

     

    Show Less
  • forum

    QlikView App Development

    Include RSS in QlikView Application

    Hi,i would like to load an RSS Feed into a QVD. How can i do this ?RegardsVolker

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