Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
3,276 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

    Set analysis - using 4 variables to compare date ranges 1 year apart

    Hello experts - I hope you can help.I have created a table which shows sales quantities for each salesperson within a date range which is set using 2 ... Show More

    Hello experts - I hope you can help.

    I have created a table which shows sales quantities for each salesperson within a date range which is set using 2 calendar controls (start and end dates for the range)

    The date on the 'start' calendar sets variable vStartTranDate, and the date on the 'end' calendar sets variable vEndTranDate.

    The expression for the sales quantity column (which works fine) is this:

    = sum({<SourceOfSale={'CallCentre'}, DateOfTransaction= { "$(= '>=' & date(vTranStartDate,'YYYY-MM-DD') & '<=' & date(vTranEndDate,'YYYY-MM-DD'))"  } >} SalesQuantity)

    I want the next column to be the same, but for transaction date range 1 year back from the user's chosen start and end dates

    First I setup two variables to derive the right range (vOneYearBeforeTranStartDate & vOneYearBeforeEndStartDate) which simply use AddYears to subtract 1 year from each of vStartTranDate & vEndTranDate

    Then I added the new column with this expression:

    = sum( { $ <SourceOfSale={'CallCentre'}, DateOfTransaction= { "$(= '>=' & date(vOneYearBeforeTranStartDate,'YYYY-MM-DD') & '<=' & date(vOneYearBeforeTranEndDate,'YYYY-MM-DD'))"  } > } SalesQuantity)

    This produced zeroes, this must be because within the current selection there is no data for the earlier date range. ie the user selects a range from December 17th 2013 to January 16th 2014, so data from 1 year before is excluded.

    So then I tried replacing = sum( { $ <SourceOfSale={'CallCentre'} etc with = sum( { 1 <SourceOfSale={'CallCentre'} which kind of works but not really because it remains unaffected by further selections on other fields, which is not what I want

    Then I tried -

    = sum( { $ <DateOfTransaction=, SourceOfSale={'CallCentre'}, DateOfTransaction= { "$(= '>=' & date(vOneYearBeforeTranStartDate,'YYYY-MM-DD') & '<=' & date(vOneYearBeforeTranEndDate,'YYYY-MM-DD'))"  } > } SalesQuantity)

    - thinking it would ignore the user's date selection and instead respect only the vOneYearBefore... variables - just more zeroes

    The only other suggestion I've seen that looks vaguely helpful is to use something like

    Sum( { $ < Year = { $ (=Only(Year)-1 } > } SalesQuantity )

    which would be fine until you get into ranges which span more than year (like in my December 17th 2013 to January 16th 2014 example)

    There's a lot of reading out there on this, but it seems geared to the logic that would make that last theory work, and that doesn't help me with the scenario of free date selection rather than set years/quarters/months.

    At this point any advice would be gratefully received. Thank you.

    Show Less
  • Qlik Sense App Development

    Average for month using Total

    I am trying to create an expression that would show the average for an entire month. Here is the set analysis that I currently have.  AVG({<DateType={... Show More

    I am trying to create an expression that would show the average for an entire month. Here is the set analysis that I currently have. 

     

    AVG({<DateType={'STAFFING_CENSUS'}, PROVIDER_TYPE_ROLLUP = {'All RN'}, Year=, Month=, [Month-Yr]=, DATE={'>=$(=MonthStart(Today()))<=$(=MonthEnd(Today()))'}>}AGGR(SUM({<DateType={'STAFFING_CENSUS'}, PROVIDER_TYPE_ROLLUP = {'All RN'}, Year=, Month=, [Month-Yr]=, DATE={'>=$(=MonthStart(Today()))<=$(=MonthEnd(Today()))'}>}[Actual Total Staffing]),[Shift Text],DATE))

     

    It returns the following data:

    DateAverage
    1/1/2020260.6667
    1/2/2020268
    1/3/2020256.6667
    1/4/2020253.16667
    1/5/2020253.16667
    1/6/2020243.16667
    1/7/2020257.16667
    1/8/2020266.83333
    1/9/2020263.33333

     

    The average for all days is 258.625. 

    I want the output to be the following:

    1/1/2020258.625
    1/2/2020258.625
    1/3/2020258.625
    1/4/2020258.625
    1/5/2020258.625
    1/6/2020258.625
    1/7/2020258.625
    1/8/2020258.625
    1/9/2020258.625
      

     

    Thanks for any assistance. 

    Show Less
  • New to Qlik Sense

    My qliksense desktop is getting closed by itself while working

    Hi All,I am working on qliksense desktop November 2019 release and is observing from last one week , it is not working properly. It closes the Qlik de... Show More

    Hi All,

    I am working on qliksense desktop November 2019 release and is observing from last one week , it is not working properly. It closes the Qlik desktop app by itself while working and then I have to relogin to continue my work and today it is worst I have been trying everything, I downloaded Qlik again so that if there is any issue it can be resolved. Has anybody faced the same issue in the past. Please guide me what is the matter and how it can be resolved?

     

    Many Thanks

    Shilpa

    Show Less
  • New to QlikView

    Simple table

    I would like add a table that has a column with data from a loaded table and a second column with no data, but filled with a certain color based on th... Show More

    I would like add a table that has a column with data from a loaded table and a second column with no data, but filled with a certain color based on the Data in Column 1.  Similar to below.

     
     

    simple chart.JPG

    Is this possible?

     

    Show Less
  • Qlik Sense App Development

    Section Access only allowing USER or ADMIN, but not both.

    Hi,I have an odd issue with my section access.  Only ADMINs are getting access (not USERs), so I loaded my section access into a table to see what it ... Show More

    Hi,

    I have an odd issue with my section access.  Only ADMINs are getting access (not USERs), so I loaded my section access into a table to see what it was doing. That's when I discovered if I include a mix of ADMIN and USER users, only the ADMIN ones are loaded. If I change it to be only USER (or even add in some others like TEST, DUMMY etc) , then it loads everything. I've tried loading the section access inline and also from an xlsx file.

    My section access script:

    Section Access;

    LOAD * inline [

    ACCESS,USERID,COST_CENTRE
    ADMIN,ABCDE\abc1111,*
    USER,ABCDE\def2222,1000
    USER,ABCDE\ghi3333,2000
    ];

    section application;

    My table script:

    TEST:
    LOAD * inline [
    ACCESS,USERID,COST_CENTRE
    ADMIN,ABCDE\abc1111,*
    USER,ABCDE\def2222,1000
    USER,ABCDE\ghi3333,2000
    ];

    So my question is, how am I supposed to have ADMIN and USER in section access? Or am I supposed to only have ADMIN or USER, not both?

    Show Less
  • QlikView Layout & Visualizations

    Sorting by time

    Hi,I have a Straight table where one of many columns is Time:10:01 am10:02 am10:03 am... and so onI want to be able to sort on time by clicking the Ti... Show More

    Hi,

    I have a Straight table where one of many columns is Time:

    10:01 am

    10:02 am

    10:03 am

    ... and so on

    I want to be able to sort on time by clicking the Time column => but when I do, it sorts in a rather strange way, with no logic (at least it seems) in the sort.

    When I check the sort properties I find the choices to sort by by "text", "number/value", "frequency," and "Load order"...

    Could this have something to do with Time not being text or a number? I have tried sorting by both of them, but it does'nt sortthe way I want it to... Can anyone give some hints/directions for how I can handle this types of sorts?

    Show Less
  • New to QlikView

    Gráfico de dias/ Day chart

    Pessoal, eu preciso fazer um gráfico de barras que me mostre o período de tempo em que um "item" está aberto, aqui a imagem do exemplo do que preciso:... Show More

    Pessoal, eu preciso fazer um gráfico de barras que me mostre o período de tempo em que um "item" está aberto, aqui a imagem do exemplo do que preciso:

    --

    Guys, I need to make a bar graph that shows the period of time that an "item" is open, here is an example image of what I need: (over 20 days, 0 to 2 days..)

    cats.jpg

    Só que a unica informação que eu tenho de dias e meses, vem em uma tabela com esse formato:

    --

    But the only information I have of days and months, comes in a table with this format:

    cats2.jpg

     

    Eu sou nova no qlik ainda, como posso fazer para calcular esse tempo que quero (dias, meses) por itemntendo uma tabela com esse formaro?

    --

    I'm still new to qlik, how can I calculate the time I want (days, months) per item with a table with this format?

     

    Agradeço pessoal!

    --

    Thank you guys!

     

    Show Less
  • Qlik Sense App Development

    Data Handling with Multiple Measures

    I have a table with multiple measures.  I'd like to filter out rows where Measure #1 = 0 while ignoring Measure #2.  Un-checking "Include Zero Values"... Show More

    I have a table with multiple measures.  I'd like to filter out rows where Measure #1 = 0 while ignoring Measure #2.  Un-checking "Include Zero Values" under Add-Ons/Data Handling evaluates both measures and only filters out the rows where both #1 and #2 are zero.

    Thanks for any assistance in advance!

    Show Less
  • Qlik NPrinting Discussions

    REST API Connector fails while the configuration is Correct

    Hello every one, I am trying to use QV REST API Connector 1.3. to my Qliksense Nprinting November 19. it fails and I do not know what the problem is. ... Show More

    Hello every one, 

    I am trying to use QV REST API Connector 1.3. to my Qliksense Nprinting November 19. it fails and I do not know what the problem is. I used this reference: Community Reference and I followed the steps properly.  if I  eliminate ":4990/api/v1/login/ntml" it works and the connection is successful to the server. but I think the following part ":4990/api/v1/login/ntml" is needed to get connected by REST. I don't know why the full address doesn't work. any hint?

     

    Thank you in advance

    REST.JPG

    Show Less
  • QlikView App Development

    Charts and Tables printing settings

    Hello Community.Any idea how I can center a chart when I want to print it to PDF? I have the printer icon enabled on one of my charts, configured the ... Show More

    Hello Community.

    Any idea how I can center a chart when I want to print it to PDF? I have the printer icon enabled on one of my charts, configured the printer general settings, layout and header/footer etc, but when I finally print to PDF it is skewed to the left. I would like to have it centered. 

    Secondly, how can I get the heading text on each page that is printed? Currently only shows up on first page. 

    Thanks 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 January 31, and save $300.

May 11- 14, 2020 Global Conference

Events

Events & Meetups

Participate in an upcoming local Qlik Meetup


Events

Customer Spotlight Series

Discover the secrets behind data-driven transformation with real-world examples from Qlik customers.

Watch the Series Today