# Welcome to Qlik Community

cancel
Showing results 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.

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.

# Recent Discussions

#### 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.

Show Less

#### 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:

 Date Average 1/1/2020 260.6667 1/2/2020 268 1/3/2020 256.6667 1/4/2020 253.16667 1/5/2020 253.16667 1/6/2020 243.16667 1/7/2020 257.16667 1/8/2020 266.83333 1/9/2020 263.33333

The average for all days is 258.625.

I want the output to be the following:

 1/1/2020 258.625 1/2/2020 258.625 1/3/2020 258.625 1/4/2020 258.625 1/5/2020 258.625 1/6/2020 258.625 1/7/2020 258.625 1/8/2020 258.625 1/9/2020 258.625

Thanks for any assistance.

Show Less

#### 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

#### 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.

Is this possible?

Show Less

#### 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;

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

section application;

My table script:

TEST:
ACCESS,USERID,COST_CENTRE
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

#### 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

#### 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..)

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:

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?

--

Thank you guys!

Show Less

#### 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

#### 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?

Show Less

#### 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.

Show Less

## Top Participants

MVP

22138

MVP

8555

Employee

8345
• #### Gysbert_Wassenaar

MVP & Luminary

8123
• #### jagan

MVP & Luminary

7957

Employee

6453
• #### marcus_sommer

MVP & Luminary

4849

MVP

4818
• #### rwunderlich

MVP & Luminary

4115

Employee

3895

# Qlik Community Manager Blog

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

#### Blogs

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

# Blogs

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

# Join a Group

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

# Qlik Deployment Framework

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

2700+ Members

# Qlik Healthcare

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

750+ Members

# 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 & Meetups

Participate in an upcoming local Qlik Meetup

# Customer Spotlight Series

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

Watch the Series Today