Olá pessoal só novato no qlikview e gostaria de saber se é possível realizar um cálculo de um período filtrando outro.

Exemplo quando eu seleciono a competência do mês de agosto/2019 ela apresenta os dados de agosto / 2019 ok, porem eu preciso que ele utilize a competência selecionada e menos sessenta dias e mostrar todos os valores, como se o período tivesse noventa dias deverá mostrar os dados de 16/05/2019 a 14/08/2019.

Inicio da competência = 15/07/2019
Fim da Competência = 14/08/2019
Limite para soma = 16/05/2019

As implemented as a server Web Dashboard, the "Always One Selected" features seems to be enabled.  At one time this was a desired feature and now it is not desired.  There are 10 sheets.  ...One Seletected... is related to a Date column.  Each sheet has been investigated for having the 'box checked' and none were found.  The forced selection is only active in the server Web Dashboard instance.  In the Qlikview instance in development or WebView the forced one selected function is not active.

(I do know that the Always One Selected selection is grey and only available when one is selected)

Is there a way to search / find what sheet and object might be driving ...one selected...? 

Is there another method to drive ...one selected... that I might search and attempt to clear function?  

Might there be a conflict between the local version and dashboard version that needs to be addressed?

Dear all, I have been battling with this problem for many days now and would like to ask for some help on how to solve.

I have a table of data which contains the costs of products depending on the date I bought them :

I am trying to create a table to show the costs of the products showing the price of the first buy and the last buy of each one of them:   

I am trying to use this two functions ( FirstSortedValue and aggr) but it won´t work for me, I would need some help.

This is an example of how I am using the functions:

FirstSortedValue( distinct Cost, aggr(Max(  Cost), Item, Date),1) and FirstSortedValue( distinct Cost, -aggr(Max(  Cost), Item, Date),1)

But it won´t give me the first and last value, It gives me tha maximun and minimun values.

Thank you very much in advance, I hope you can give me some assistance with this.

I am given a large (3.6gb) binary which includes data from all over the world and has around 57 tables. A section access is applied for a column in one of the 57 tables resulting me and my fellow countrymen only being able to work on rows relevant for my country (e.g. Malaysia).

I am trying to export all these tables into QVDs by performing a series of STOREs for each of the 57 resident tables  into individual QVDs. However, the resulting QVDs are still that of the global binary (3.6gb). From there, I will load back the QVDs and the use app's resulting binary for downstream country-specific apps.

Is there a way to export into QVDs only the rows that Section Access allows me to?

I could perform a WHERE filter on the particular resident table with the country column but that would also require me to understand the complex join conditions across all the 57 tables for me to perform the subsequent INNER KEEPs.

Hi everyone,

I am using the enterprise version of Qlik Sense and from time to time, when I am working on the published application,  appears suddenly the error : "An error has occured. Access denied" and after I click on the close button, I can continue working on the sheet I was previously working, but some information might be missing, such as words or numbers. 

Does anyone know, why is this happening?

Thanks in advance.

Regards,

Ellie

I wanted to share my ‘ChunkSize’ experience in case it helps someone at some point in the future. I’m running QV11 SR2 and called support with a corrupted QVPR. They helped me restore it, and noticed that my ‘ChunkSize’ was set to 100. They asked me to set the value to 20 and we ended the call (after restarting services). I noticed that night that my QVDS tasks all ran much slower – about 5x slower – than normal. I contacted support the next day and they reset the value back to 100. After a restart everything was back to normal again. The chunk size was the only system change that happened, and I’m certain it caused the performance hit.

ChunkSize can be found in the QV Management Service Config file:

C:\Program Files\QlikView\Management Service\QVManagementService.exe.config

    <add key="QMSChunkSize" value="100"/>

Support said the version prior to mine (I won’t assume they mean QV11 SR1) had some issues with the chunk size being set high, so the solution was to lower it. This is why they told me to set it at 20. After I noticed my issues they asked around and found that my version was reported to work better with a larger setting (100).

Apparently the QVDS and the QVMS communicate via something called a work order (XML based perhaps?). The chunk size is the size of this message.

I figured I would share since I couldn’t find anything online about this setting.

Hi Guys, I'm working on a sales report on qlikview dashboard. I calculate average sales value upto previous month. it's working. But I want to fixed the value in the text box but that's not working. When I choose date or month from the field the average value is changed but I don't want any effect for the average value in the text box. I use a set analysis in the equation. Here is the equation:

=num((Sum({<Month-=,Mday-=,Month-={"$(=vCurrentMonth)"},Year={"$(=vCurrentYear)"}>}Gross_Value)/
(count(distinct {<Month-=,Mday-=>} Month)-1))/1000000,'###0.0')

where, vCurrentMonth=2019

Please help me ASAP, Thanks.

Posted this in a different forum but no luck there. Hoping this is another place to ask my question regarding section access.

I was able to get my section access to be working perfectly fine through all the great help received from this forum. Now, we decided to store our users in a separate table in our database and decided to pull the data from the db vs. doing an inline in the script. 

--------------- my script -------------

SECTION ACCESS;

LIB CONNECT TO ***

LOAD * INLINE [

ACCESS, USER_ID, ACCESS_ID
ADMIN, domain\andrew, 
USER, domain\dummyuser, 1
ADMIN, INTERNAL\SA_SCHEDULER,*,
];

SECTION APPLICATION;

LOAD * INLINE [

ACCESS_ID, DEPARTMENT

1, MARKETING

2, FINANCE

3, ACCOUNTING

4, IT

5, Other

];

---------- end --------------

Pretty much I am making the user "dummy" to only see the value 1 which is Marketing data only. This works fine. Once I brought in the same table but through the database (which stores the exact same data, except I had to create an additional column since an * is considered a varchar).

This shouldn't change anything but please correct me if I am wrong. But upon running the script this is the constant error I get and cannot get past this error. I tried reverting the script to go against the inline and am still getting an error for the script that was once working. I'm a bit lost and reaching out for some additional help or anything you guys may see that I am missing.

error - 

Thanks a bunch.