Hello, I'm having an issue with some data tables in Qlik Sense SaaS.  When users go to export tables to Excel, entries are going missing.  Every entry has a unique identifier, so I'm not sure why data would disappear during export.  Also, this is the first time we're having this issue even though we've been using these tables for months.  This problem goes away when I try to recreate the situation with test data, otherwise I would include an example.  

Any advice on how to identify the field or table that's causing this would be appreciated.

Hi All

I have a data load that uses AutoNumber to count the numbers of days of sickness. What I need it to do is only count the consecutive days and then reset. So if a person returns to work for a regular shift then goes back on sick leave I need the AutoNumber process to restart at 1. 

Maybe the AutoNumber is not the best approach but I cannot seem to work it out. 

if(Wildmatch([Pay_Type], 'Sickness'), AutoNumber(recno(),[EMP_Code] & [Pay_Type])) as Occurrence,

This is the data and the last field is the result of the expression above. Data Row 19 below 25/01/2022 shows Occurrence 7 but I need to to show as 1 due to the person working  5 regular/transfer shifts (17th to 24th) after previous 5 days of sickness occurrence. 

LOAD * INLINE
[

Date,EMP Code,Pay Type,Type,JOB TYPE,Hours Worked,Hours Not Worked,Sickness Occurrence
29/01/2022,S29536,Basic,Transfer,MNGRS,3,-,-
29/01/2022,S29536,Basic,Transfer,MNGRS,5,-,-
02/01/2022,S30299,Sickness,-,SALES,-,6,1
03/01/2022,S30299,Covid,-,SALES,-,8,-
06/01/2022,S30299,Covid,-,SALES,-,8,-
07/01/2022,S30299,Covid,-,SALES,-,8,-
08/01/2022,S30299,Covid,-,SALES,-,8,-
09/01/2022,S30299,Covid,-,SALES,-,8,-
10/01/2022,S30299,Sickness,-,SALES,8,8,2
13/01/2022,S30299,Sickness,-,SALES,8,8,3
14/01/2022,S30299,Sickness,-,SALES,-,8,4
15/01/2022,S30299,Sickness,-,SALES,-,8,5
16/01/2022,S30299,Sickness,-,SALES,-,8,6
17/01/2022,S30299,Basic,Regular,SALES,6,-,-
21/01/2022,S30299,Basic,Transfer,SALES,8,-,-
22/01/2022,S30299,Basic,Transfer,SALES,5.5,-,-
23/01/2022,S30299,Basic,Regular,SALES,6,-,-
24/01/2022,S30299,Basic,Regular,SALES,5.5,-,-
25/01/2022,S30299,Sickness,-,SALES,-,8,7
26/01/2022,S30299,Sickness,-,SALES,-,8,8
27/01/2022,S30299,Sickness,-,SALES,-,8,9
28/01/2022,S30299,Sickness,-,SALES,-,8,10
31/01/2022,S30299,Basic,Break,SALES,0.5,-,-
31/01/2022,S30299,Basic,Regular,SALES,2.5,-,-
31/01/2022,S30299,Basic,Regular,SALES,5.5,-,-
02/01/2022,S49649,Basic,Regular,SALES,6,-,-
05/01/2022,S49649,Basic,Regular,SALES,5,-,-
08/01/2022,S49649,Basic,Regular,SALES,5,-,-
09/01/2022,S49649,Sickness,-,SALES,-,6,1
13/01/2022,S49649,Sickness,-,SALES,-,6,2
14/01/2022,S49649,Annual Leave,-,SALES,-,6,-
16/01/2022,S49649,Annual Leave,-,SALES,-,6,-
20/01/2022,S49649,Annual Leave,-,SALES,-,4,-
21/01/2022,S49649,Sickness,-,SALES,-,6,3
23/01/2022,S49649,Sickness,-,SALES,-,6,4
24/01/2022,S49649,Sickness,-,SALES,-,6,5
29/01/2022,S49649,Basic,Regular,SALES,4,-,-

](delimiter is ',');

Many thanks in advance

Hi, Can some one suggest recommended settings/things to check to run QV11 report from access point. One of the report users complained about button functionality not working (all buttons in report). Even simple button action for setting a variable value is not working when report is opened via Access Point. We tried multiple things and no luck so far. The same functionality works fine to other users.

Here are some of the changes we did, appreciate any help in this regard, Thanks in advance!

Installed IE plug-in, checked IE compatibility mode,enabled certain internet options (activex objects), chose "Give System Access to Module Script"(Ctl+Shft+M) option (as some buttons have macros).

Note: this user has installed QV Desktop locally for other purpose

Hola, tengo un problema al aplicar la funcion aggr,

desde una tabla tengo pedidos y posiciones de pedido para un material tabla1, en otra tabla tengo el material y cantidad de piezas por paquete tabla2 ,

tabla1

tabla2

ocupo la funcion aggr para contar los paquetes de material es decir la cantidad de veces que tengo el material en mi tabla2, pero produce diferencias y agregar una columna de cantidad de paquetes disponibles debería resultar como la tabla3,

alguien sabe como lo puedo solucionar o otra alternativa para realizar lo mismo?

los resultados no son los correctos, las tablas estan unidas por el campo material

tabla3

Hello, I have a problem when applying the aggr function,

from a table I have orders and order items for a material, and in another table I have the material,

Table 1

table 2

I use the aggr function to count the material packages, that is, the number of times I have the material in my table2, but it produces differences and adding a column with the number of available packages should result in table3,

Does anyone know how I can solve it or another alternative to do the same?

the results are not correct, the tables are joined by the material field

table3

I've created a pivot table and I do not want the columns with weekend dates to display. How would I remove them? ( I don't care if there is data on the weekend dates so I don't want them to show)

-thank you

Hi,

I am trying to extract the code which starts with 'PA9' from a string in column OTHERS as below and make a new column/field for the code.

OTHERS

~PA9235 testing for qlik

PA92222 testing

test123~PA92325~test

due to the unfixed code length and location, i am unable to use subfield() for this.

Is there any other way for this?

As shown in the photo, the dates in the "current selections" are shown to me as a number and not in date format (picture 1), it is possible to put them in date format as I see them when I go to select them (picture 2)

Hi Team,

i have 3 excel files 

data

data1

data2

in each excel file 4 spread sheets 

 note : in manual  load into data   Qlikview  12 qvds

in my  requirement in future multiple sheets getting that's reason i want  load data  into  dynamiclly   

in   3 excel files different filed names 

below attachment's

Thanks ,

Rajasekhar Reddy