Qlik Community

Welcome to Qlik Community

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

This forum will provide you with event highlights and related content to get you energized and ready for Qlik’s largest customer and partner event of the year.

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.

Discussion Boards and Documents for Qlik Services.

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 nine unique blogs. Check out the new Customer Success Blog!

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

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.

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

Recent Discussions

  • QlikView App Development

    Another set analysis period question

    HelloI am trying to do some set analysis within a table,  I want to take range from the start period to period 9The variable for start period is vStar... Show More

    Hello

    I am trying to do some set analysis within a table,  I want to take range from the start period to period 9

    The variable for start period is vStartPeriod_CY (eg 201900), and I am trying to get to the range  201900 to 201909 into the set analysis

    For  example I tried the below but it didnt seem to work.  Can you see what i am doing wrong ?

    Many thanks Paul

     

    sum({$<period = {">=$(vStartPeriod_CY)<=$(=vStartPeriod_CY + 09)"},
    costc = {681,685},
    bud2_line = {"OFFICE COSTS"},
    Datasource = {'Actual'}
    >} $(vCurrency)) * Infra%

    Show Less
  • New to Qlik Sense

    Graph comparing previous quaters with current quarters of a year

    Hi,I am fairly new to QS and not able to arrive at a sol for below issue.I have my data like below with dimensions being Portfolio, reporting date and... Show More

    Hi,

    I am fairly new to QS and not able to arrive at a sol for below issue.

    I have my data like below with dimensions being Portfolio, reporting date and  segment.

    Portfolioreporting_datesegmentaccount_volume
    S31Aug2019S117987
    S31Aug2019S219
    S31Aug2019S31
    S31Jul2019S129
    S31Jul2019S214109
    S31Jul2019S32
    S30Jun2019S114
    S30Jun2019S2124121
    S30Jun2019S342
    S31May2019S14246
    S31May2019S234
    S31May2019S32
    S30Apr2019S132
    S30Apr2019S237
    S30Apr2019S32
    S31Mar2019S132
    S31Mar2019S237
    S31Mar2019S32
    S28Feb2019S1346
    S28Feb2019S23
    S28Feb2019S32
    ….……..……..…..
    H31Aug2019H14364
    H31Aug2019H2432
    H31Aug2019H31
    H31Jul2019H1324
    H31Jul2019H2432
    H31Jul2019H34
    H30Jun2019H13
    H30Jun2019H2342
    H30Jun2019H342
    H31May2019H125
    H31May2019H234
    H31May2019H32
    H30Apr2019H132
    H30Apr2019H237
    H30Apr2019H32
    H31Mar2019H132
    H31Mar2019H237
    H31Mar2019H32
    H28Feb2019H1346
    H28Feb2019H23
    H28Feb2019H32

     

    I select a Portfolio(H/S/….) and a reporting date ,lets say I select aug19 and S

    I should see graph and data as below

     

    Aug-18

    Nov-18

    Feb-19

    May-19

    Aug-19

     

    Accounts

    148277

    150958

    351

    4282

    18007

     

    Change

    #N/A

    0.01808

    0.0115

    0.01966

    0.01368

     

    and a combo graph plotting the both volume and change. (The %change formula in the example is probably not correct. I meant (previous value -current value)/previousvalue.

    Can some one pls help

    Show Less
  • Qlik Sense Integration, Extensions, & APIs

    Please help with HubSpot API pagination settings

    Hi,I'm using Qlik Sense' REST API connector to pull data from HubSpot CRM. HubSpot documentation reads:"Get all of the deals in a portal.  Returns a p... Show More

    Hi,

    I'm using Qlik Sense' REST API connector to pull data from HubSpot CRM. HubSpot documentation reads:

    "Get all of the deals in a portal.  Returns a paginated set of deals.

    In addition to the list of deals, each request will also return two values, offset and hasMore. If hasMore is true, you'll need to make another request, using the offset to get the next page of deal records." (from Get all deals‌ )

    Default records returned is 100.

    I need help configuring the 'pagination type' settings in Qlik Sense. Please help.

    Show Less
  • New to QlikView

    Chart calculation in the script

    Hi Geeks,This might be simple but I am breaking my head. I want the calculation that is done on the chart to be implemented in the script.Open Invento... Show More

    Hi Geeks,

    This might be simple but I am breaking my head. I want the calculation that is done on the chart to be implemented in the script.

    Open Inventory = Previous Month Closing Inventory(Expression : Above(Closing Inventory))

    Closing Inventory = Open Inventory + In Sales - Out Sales

    This is easy in the chart as I can use the column labels and get it done but seems tricky in the script.

    Reason behind needed in the script: If nothing is selected, all good. But if I select a month, the calculation starts for the selected month. Open Inventory can't take the previous month Closing Inventory. So, if it is done in the script, everything will be pre-calculated.

    I tried to be detail to my best . Let me know if any questions and thanks in advance.

     

    -Naresh

    Show Less
  • New to Qlik Sense

    If Statement with dates

    Hello dear experts,I have a field called Fecha as a date, i'm trying evaluate it with a rate of dates depending of the value which evaluating Date fie... Show More

    Hello dear experts,
    I have a field called Fecha as a date, i'm trying evaluate it with a rate of dates depending of the value which evaluating Date field, once i  try to load data the next error comes(Attached image).
    Loaderror.PNG

    if(Fecha<Date(30/01/2015,'DD/MM/YYYY'),
    if(PM < PE15,1,0),
    if(Fecha>= Date(06/01/2016,'DD/MM/YYYY'),
    if(PM < PE16,1,0),
    if(Fecha<= Date(10/05/2016,'DD/MM/YYYY'),
    if(PM < PE161,1,0),
    if(Fecha<= Date(17/11/2017,'DD/MM/YYYY'),
    if(PM < PE17,1,0),
    if(Fecha<= Date(29/04/2019,'DD/MM/YYYY'),
    if(PM < PE,1,0)
    )
    )
    )
    )
    ) as Sub_PE


    Thanks for help.

    Regards.

    Show Less
  • New to Qlik Sense

    expression

    Hi,  I have a pivot table with data that includes Fiscal Yeas 2019 and 2020 (I just included 2020 data).  Last year I had a background color expressio... Show More

    Hi,  

    I have a pivot table with data that includes Fiscal Yeas 2019 and 2020 (I just included 2020 data).  Last year I had a background color expression of :

    if(sum([BGT OBL PLAN AMTS])/Sum([BGT AUTHORIZED]) > .92, 'green', lightred())

    I would like to have that expression for 2019 but set my 2020 color expression at >.25.

    Any help would be greatly appreciated.  

    Source doc column header for fiscal year is: FY

    Thank you! 

     

    Show Less
  • New to QlikView

    Date Format

    Hi All,In the Script I am trying to convert Date filed like below but  after reloading the field is banl doesnot show any values in it  Date(weekstart... Show More

    Hi All,

    In the Script I am trying to convert Date filed like below but  after reloading the field is banl doesnot show any values in it 

     

    Date(weekstart(TempDate,'DD/MM/YYY'),'DDMMMYY') as TestWeekStart,

     

    The TempDate format is like :  01/23/2020 

     

    How do i convert this into the weekstart format in 1Jan20

     

    Thanks in Advance 

    Show Less
  • New to QlikView

    Filters not working

    Hi Team, Filters not giving proper results.If i filter for FY20 and Sep. PO count should be 152 and Requestor count should be 57instead of PO count :1... Show More

    Hi Team,

     

    Filters not giving proper results.

    If i filter for FY20 and Sep. PO count should be 152 and Requestor count should be 57

    instead of PO count :144 and  Requestor count :53.

    Can you please help?

     

    Regards,

    Savithri

     

    Show Less
  • New to Qlik Sense

    Counting changes in values of a field

    Can't seem to figure this out. I have weekly (Friday) snapshot data on over 500 Projects with a Status field. My data is one .xlsx file that I keep co... Show More

    Can't seem to figure this out. I have weekly (Friday) snapshot data on over 500 Projects with a Status field. My data is one .xlsx file that I keep concatenating to every week. My data spans all of 2019 to date (1/24/20).  

    There are over 15 statuses, but I am trying to count how many projects have switched to Complete status in 2020. There are currently 42 projects that have a Complete status, but most of them have become Complete in 2019. 

    How can I count when Status field changes to Complete (from any other status)? Should/can I do this at chart level, or in load script?

    Sample data of one project: (altered for simplicity)

    PROJECT IDDATESTATUSCOMPLETION DATE (NEW FIELD)
    AD23111/29/2019Testing-
    AD23112/6/2019Testing-
    AD23112/13/2019Awaiting Confirmation-

    AD231

    12/20/2019Awaiting Confirmation-
    AD23112/27/2019Awaiting Confirmation-
    AD2311/3/2020Awaiting Confirmation-
    AD2311/10/2020Complete1/10/2020
    AD2311/17/2020Complete-
    AD2311/24/2020Complete-


    That project should be in my count, since it became Complete on 1/10/2020.  This project should NOT be counted....

    PROJECT IDDATESTATUSCOMPLETION DATE (NEW FIELD)
    AD18811/29/2019Awaiting Confirmation-
    AD18812/6/2019Awaiting Confirmation-
    AD18812/13/2019Complete12/13/2019
    AD18812/20/2019Complete-
    AD18812/27/2019Complete-
    AD1881/3/2020Complete-
    AD1881/10/2020Complete-
    AD1881/17/2020Complete-
    AD1881/24/2020Complete-


    .....Since it became Complete in 2019.

    Thank you!!

    Show Less
  • QlikView Scripting

    Galaxy model (two fact tables, multiple dimensions)

    Hi all,I am trying to understand why this model does not work. I have two fact tables plus multiple dimensions (see image below).   Why i have this ci... Show More

    Hi all,

    I am trying to understand why this model does not work. I have two fact tables plus multiple dimensions (see image below). 

     

    Circularreferences.PNG

     

    Why i have this circular references when having unique keys?

    Of course I could avoid that by concatenating these tables, but I need to understand why in Qlik having tow fact tables linked to the same dimension cause troubles.

    Thank you in advance,

     

     

    Show Less

Blogs

Qlik Community Manager Blog

Hear from the Qlik Community team about the latest platform enhancements for October and November 2019.

Blogs

Qlik Support Updates Blog

Read the latest blogs from Qlik Support and get important and useful support information.

Blogs

Blogs

Hear directly from Qlik employees and stay current on the latest and greatest information about Qlik products.

Groups

Join a Group

Join one of our Qlik Community user groups around an Industry, Location & Language, or Topic.

Groups

Qlik Deployment Framework

This group hosts information related to the Qlik Deployment Framework (QDF).

2700+ Members

Groups

Qlik Healthcare

This group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights.

750+ Members

Events

Qlik World 2020

Transform your digital world. Join us for our annual conference (formerly Qonnections) in Phoenix, AZ. Register by February 29th to save $200.

May 11- 14, 2020 Global Conference

Events

Events & Meetups

Participate in an upcoming local Qlik Meetup


Events

Qlik Insider: What's New in 2020?

Join us on for a deep-dive discussion and tailored product demonstration on the newest capabilities delivered as part of Qlik’s most recent product release.

February 26, 2020