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.

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:

The average for all days is 258.625. 

I want the output to be the following:

Thanks for any assistance. 

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

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?

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?

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?

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?

Agradeço pessoal!

--

Thank you guys!

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!

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

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