I have a field 'MeasureNo ' , 'MeasureValue' , 'WorkOrder'

in field  'MeasureNo' contains data  '1' , '2', '3' ,'4', '5', ' Tank'

I only need MeasureValue where MeasureNo = 1,2,3,4,5

Now I tried the formula but the value is incorrect:

Sum({<MeasureNo={1}, MeasureNo={2}, MeasureNo={3},MeasureNo={4},MeasureNo={5} > } (Aggr(if(Max(MeasureValue) <= CuMax and Min(MeasureValue) >= CuIMin ,Count(WorkOrder)),WorkOrder)))

Sometimes (inconsistent) I get a warning about an exception during content resolution while processing request with id ......... Check engine logs for details. Error: Access to path ........... is denied. 

This is followed by another message: 

Failed generation of report .......... for user .............. ERROR: Exception during content resolution while processing request with id ...................... Check Engine logs for details. ERROR: Access to the path .............................. is denied.

What can I do to make this task reliable and generate the reports more consistently?

Hi, 

while replicating data from SQLServer to MYSQL, am facing the below issue.

Failure in starting (with TXN consistency...) Failure validating initial LSN 'anywhere existance' mssql_lsn_anywhere_validator(...)Failed in looking at Active TLOG lsn_exists(...)Failed in statement execution for looking at Active TLOG RetCode: SQL_ERROR SqlState: HY000 NativeError: 9003 Message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The log scan number (60:376:5) passed to log scan in database 'sample1' is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup. Line: 1 Column: -1 Failed (retcode -1) to execute statement: 'select top 1 [Current LSN] from fn_dblog('0x0000003c:00000178:0005','0x0000003c:00000178:0005')'

Say I have a field called account number and it is  "12398760234535345" but I want to convert it into "123-9876-023" in the script area. How would I do that? 

Data is coming from excel, I would change the edited data to [Account Number] AS Account_Number

How to load the data of latest date, then rename the sheet with latest data?

Datasource:

currently I need the data of "DC TJ Inventory_20230319",

Load

******

FROM [DC TJ Inventory_*.XLSX]
(ooxml, embedded labels, table is Sheet1)
Where max(TextBetween(FileName(),'_','.') )

But this does not work. How to script this?

Then I need to rename the sheet like this, how to realize it? Many thanks.

Hi 

When I am loading below pivot table from excel, the respective dimension details are not showing as in in qliksense.

In qliksense I have taked two filter object one for Department dimension and another is for OBJ_ID.
If you can see both of the OBJ_ID associated with one department as information technology.

So, If I select OBJ_11 then it is showing respective department as information technology but when I am selecting OBJ_12 none of the department is displaying.

I am using an Oracle DB as source endpoint and replicate into a Microsoft SQL Server 2019 target endpoint.

The documentation explicitly states that qlik replicate will not fire any triggers in the target DB.

How do I keep track of changes and react to new/changed data?

I need to process new data as soon as it is replicated into my target db, with minimum delay.

I have set the following  expression:

(
Sum({<Month={'$(=Max([Month], 'YYYY-MM'))'}>} Revenue)
/
Sum({<Month={'44927'}>} Revenue)
)
-1

where {<Month={'$(=Max([Month], 'YYYY-MM'))'}>} is Current Month

How can I set a similar expression for calculating Previous Month?  I tried this but it doesn't work:

{<Month={'$(=Max([Month]-1, 'YYYY-MM'))'}>}

Hi everyone,

I am trying to show  sales amount of total by customer and also sum of top 10 sales person's sales amount. then calculating the percentage like-top 10 sales amt/Total sales amt.

I need to calculate all the 3 measures.

I have sales person as well in dataset but do not want to show in table.

I used rank function but failed to do that.

Please provide your help. sample of data are given below.