Everything you need to make your Qlik Community experience valuable.
Explore official Support and member created content.
Welcome Emmy award-winning Katie Linendoll as our emcee and world record-holding cave diver John Volanthen as our keynote speakers.
Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources
Share your best Qlik apps and discuss impacts with peers! Show your work and get recognized for innovative uses of Qlik technologies.
Get started on Qlik Community, find How-To documents, and join general non-product related discussions.
Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.
Qlik gives qualified university students, educators, and researchers free Qlik software and resources to prepare students for the data-driven workplace.
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.
Customer | Total Sales amt by sales person |
top 10 sales amt by sale person |
top 10 sales amt/Total sales amt |
cust1 | 1,000.0 | 800.0 | 80.0% |
cust2 | 800.0 | 500.0 | 62.5% |
cust3 | 600.0 | 300.0 | 50.0% |
cust4 | 700.0 | 100.0 | 14.3% |
cust5 | 200.0 | 180.0 | 90.0% |
cust6 | 500.0 | 400.0 | 80.0% |
cust6 | 100.0 | 60.0 | 60.0% |
Grand Total | 3,900.0 | 2,340.0 | 60.0% |
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!
If you want to know what's new across all of the products in our growing Qlik product portfolio.
Get the latest Support information about end-of-product support, new service releases, and general support topics.
Read all about Qlik solutions: scripting, data modeling, visual design, extensions, best practices and more.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
10+ hours of roll up your sleeves, immersive working sessions. A $1000 value included in your conference pass!
Subscribe to our Events and Webinar page so you do not miss an event
opportunity!
Join the "Welcome to Qlik" webinar and learn about the Qlik Ecosystem, such as Qlik Community, Learning, and Help.
There is more than one way to find upcoming events, look on the right side
of any Qlik Community forum!
Subscribe to our Events and Webinar page so you do not miss an event
opportunity!
Join the "Welcome to Qlik" webinar and learn about the Qlik Ecosystem, such as Qlik Community, Learning, and Help.
There is more than one way to find upcoming events, look on the right side
of any Qlik Community forum!