Qlik Community

Ask a Question
Welcome to Qlik Community
cancel
Showing results for 
Search instead for 
Did you mean: 
2,043 online
Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES

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

    New to Qlik Sense

    add community sheets that are published to the app as base sheets

    Hello,With the current version of qlik sense if I have users that have created community sheets that are published, how can I add them to the dashboar... Show More

    Hello,

    With the current version of qlik sense if I have users that have created community sheets that are published, how can I add them to the dashboard as base sheets?

    I thought there was an approve option?

    Thank You,

    Michael

    Show Less
  • forum

    Qlik Sense Advanced Authoring

    Load selected files that listed in another table

    Hi experts,I would like to know if there is a way to load selected files that are listed in another table, and ignore others.My situation is as follow... Show More

    Hi experts,

    I would like to know if there is a way to load selected files that are listed in another table, and ignore others.

    My situation is as follow.

    • The QS is loading files from the folders organized by date.
      Ex. C:\Data\YYYYMMDD\BOM_ProductNumberXXX.xls
    • The users will upload the files as when the new files are available.
    • There is  MasterPlan.xls that contain all the in-scope products, along with other info for each products. This spreadsheet is loaded into the QS.

    What happen is that the users are not following the list of the products in the MasterPlan and there are files that not required being uploaded as well. 

    Here is my load scrip.

    TableMasterPlan:

    LOAD
    Site,
    Business,
    PLC,
    Trim(Products) as Products,
    ProductDescription,

    FROM [$(vRefTablePath)/MasterPlan.xlsx]
    (ooxml, embedded labels, table is MasterPlan);

     

    FOR Each vDir in DirList('$(vDataPath)/*')

    FOR each vFile in filelist (vDir&'\*.xls' )

    Table:

    LOAD Distinct
    TRIM(Mid(filebasename(), 16)) as Products,
    Date(Floor(FileTime())) as ReportDate,
    @13 as SpecID,
    @2 as MatlNumber,
    @3 as MatlDescription,
    @14 as "Spec. Type"
    FROM [$(vFile)] (biff, no labels, header is 10 lines)
    Where @14='MAT_PART_E';

    Next vFile

    Next vDir

     

    Appreciate any suggestion that you may have to modify the load script to load just the products listed in the MasterPlan table. For ex., if there are 50 files in the folder, and the Masterplan has 20 products, the load script will load the files matching the Products in Masterplan, and skip others.

    Show Less
  • forum

    New to Qlik Sense

    Load data with a Wildcard in fields

    Hello dear Experts,I want ot load data with the next logic:I have a field called "Account" which contains many logs who start with this structutre "x1... Show More

    Hello dear Experts,

    I want ot load data with the next logic:
    I have a field called "Account" which contains many logs who start with this structutre "x11000-0000-0000", "x11000-1000-2000", etc.

    Is that possible to make a wildcard to load all the data of this field which start with "x1100*" like a wildcard load or something?

    Im setting some operation into the the script which contemplate many logs of this fields, but put every row that i want of this field could be a really long operation, thats why im looking to use something like a wildcard load.

    Example:
    [Account ID] = 'x11000*' / [Account ID] = 'x21000*' as RazonCirculante

    I would greatly appreciate your help.

    Regards.

    Show Less
  • forum

    Qlik NPrinting Discussions

    Does your NPrinting also crash often during Excel template development?

    Using MSExcel 2007 with NPrinting 16 against Qlikview 12. Upgrading is doubtful.I'd be applying changes to the spreadsheet template. Then, to test, I ... Show More

    Using MSExcel 2007 with NPrinting 16 against Qlikview 12. Upgrading is doubtful.

    I'd be applying changes to the spreadsheet template. Then, to test, I request a preview with a preset limited report filter.

    Then Excel crashes, NPrinting loses its connection, and crashes the template editor, throwing away the changes.

    I have resorted to saving and closing every single change, combined with off-site source control, just to limit the damage these crashes cause.

    It's stifling my production speed.

    Did you encounter this? If so, did you fix it? How?

    Show Less
  • forum
  • forum

    Qlik Sense App Development

    Set date range as Set Modifier

    Hey community!I've been struggling to define a data range as set modifier. This set analysis syntax works:=Sum ({1<Attribute={F_2020_02,F_2020_03,F_20... Show More

    Hey community!

    I've been struggling to define a data range as set modifier. This set analysis syntax works:

    =Sum ({1<Attribute={F_2020_02,F_2020_03,F_2020_04,F_2020_05,F_2020_06,F_2020_07,F_2020_08,F_2020_09,F_2020_10,F_2020_11,F_2020_12,F_2021_01}>} Value)

    It looks at an Excel with an Attribute column that holds month information: F_2020_1 is 1 January 2020 and so on. The goal is to have the date values adapting according to today's date so it can always look back 12 months.

    I tried defining the attribute range in the loading script as such:

    Let SavingMeterDateRange = 'F_'&Date(Today()-334,'YYYY_MM')&',F_'&Date(Today()-306,'YYYY_MM')&',F_'&Date(Today()-275,'YYYY_MM')&',F_'&Date(Today()-245,'YYYY_MM')&',F_'&Date(Today()-214,'YYYY_MM')&',F_'&Date(Today()-184,'YYYY_MM')&',F_'&Date(Today()-153,'YYYY_MM')&',F_'&Date(Today()-122,'YYYY_MM')&',F_'&Date(Today()-92,'YYYY_MM')&',F_'&Date(Today()-61,'YYYY_MM')&',F_'&Date(Today()-31,'YYYY_MM')&',F_'&Date(Today(),'YYYY_MM');

    Which does correctly result in:

    F_2020_02,F_2020_03,F_2020_04,F_2020_05,F_2020_06,F_2020_07,F_2020_08,F_2020_09,F_2020_10,F_2020_11,F_2020_12,F_2021_01

    But when applying this to the syntax, the result is zero. I guess that's because it's not recognized the same way. How can I make Qlik Sense understand that it should look for the resulting attributes?

    Show Less
  • forum

    New to Qlik Sense

    Reference Line moves above visible area in graph

    Hello,I have a simple age histogram. Added a few reference lines, mean, mean+ SD and mean-SD.This is for all the data.Now I make selections / filter b... Show More

    Hello,
    I have a simple age histogram. Added a few reference lines, mean, mean+ SD and mean-SD.
    This is for all the data.
    padmanabhv_0-1610945493383.png
    Now I make selections / filter based on what the user is looking for.
    The graph changes (as expected) but the refernce lines go above the graph (and also seem wrong ?!)
    Isn't the mean supposed to be of only the values left after selection ? Or am I supposed to make that evident in the formula for the histogram ? Meaning, the formula currently is 
    Reference line : Mean=Avg(age)
    Is it supposed to be something else, which reflects the age of only selected values ?

    And how do I view them ? I can see a small 2 and an up arrow, but cannot click or scroll to see them.

    padmanabhv_1-1610945515292.png
    Thank you !

     

    Show Less
  • forum

    QlikView Deployment

    After deleting log-files, no tasks visible and two QlikView Servers

    Hello,after deleting files in the folder C:\ProgramData\QlikTech\QlikViewBatch, "something" happened with the QlikView server.1) All tasks are not vis... Show More

    Hello,

    after deleting files in the folder C:\ProgramData\QlikTech\QlikViewBatch, "something" happened with the QlikView server.

    1) All tasks are not visible - they exist and run as planned, but in 'Status' we cannot see the tasks

    2) In System/Setup/QlikView Server, two Server exist. One of them sends an error

    pwagner_0-1610955163431.png

     

    Do you have an idea how we can solve this situation?

    @Albert_Candelario?

    Best regards, Patrick

     

    Show Less
  • forum

    New to Qlik Sense

    WEIGHTED AVERAGE AND IF STATMENT

    Need to plot bar chart to compare weighted average hours for 2020 vs 2019 Products.1) Calculate weighted average hours for2020 Products2) Calculate we... Show More

    Need to plot bar chart to compare weighted average hours for 2020 vs 2019 Products.

    1) Calculate weighted average hours for2020 Products

    2) Calculate weighted average hours for 2019 Products if 2020 Products QTY is greater than 0.

    which mean for product E, sum of 2020 QTY is 0. It is excluded from 2019 weighted average.

    MonthORDERProduct NameHOURSQTY2019 HPP
    Jan1Product A10040
    Jan2Product B150250
    Jan3Product C200360
    Jan4Product D100470
    Jan5Product E50010
    Jan6Product A200640
    Jan7Product B100750
    Jan8Product C150260
    Jan9Product D200170
    Jan10Product E200010

     

    Below is the correct value:

    2020 AVERAGE HOURS48.19
    2019 AVERAGE HOURS55
    Show Less
  • forum

    Qlik Sense App Development

    Box-plot The chart is not displayed because it contains undefined values qlik se...

    Hi All,I am trying to display a box plot for two experimental group fields, but getting weird error which I could not resolved and provided below. Sam... Show More

    Hi All,

    I am trying to display a box plot for two experimental group fields, but getting weird error which I could not resolved and provided below. 

    box-plot error qliksense.JPG

    Sample of the data

    sample data for qliksense.JPG

    If anyone knows what is the problem please let me know

    Thank you

     

    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