Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Welcome to
Qlik Community!
Recent Discussions
-
Rows comparision from Backend
Hello everyone, I am having 2 tables. one is for daily reload and second one is incremental qvd for daily qvd. Here we are having 5 fields, we are cap... Show MoreHello everyone,
I am having 2 tables. one is for daily reload and second one is incremental qvd for daily qvd.
Here we are having 5 fields, we are capturing daily data,if there is any change in 5 fields then those records are storing into incremental qvd .
This process we are doing by AutoNumber condition.
Now, If we want to add any new field to this list, instead of adding that field in If condition manually
is there any way to check if any change is happened in the records.Daily Qvd have these records:
Item Name Dim1 Dim2 Dim3 Volity Code Last Updated 123 10 15 7 C 12/26/2024 124 5 6 10 B 12/24/2024 Incremental Qvd is having below records:
Item Name Dim1 Dim2 Dim3 Volity Code Last Updated 123 10 15 7 A 12/24/2024 124 5 6 10 B 12/24/2024 My result would be like
Item Name Dim1 Dim2 Dim3 Volity Code Last Updated 123 10 15 7 A 12/24/2024 124 5 6 10 B 12/24/2024 123 10 15 7 C 12/26/2024 We are using AutoNumber(Dim1&Dim2&Dim3&Volity Code) as KEY
we have added new field for comparison and field name is Weight
Item Name Dim1 Dim2 Dim3 Volity Code weight Last Updated 123 10 15 7 A 30 12/26/2024 124 5 6 10 B 20 12/24/2024 AutoNumber(Dim1&Dim2&Dim3&Volity Code&weight) as KEY
Instead of checking field values manually by using AutoNumber whether it is changed or not is there anyway to automate or direct function to compare between rows and identify which is having duplicate records and which is having distinct records.
Thank you in Advance
-
Replacing null values and formatting field as numbers
In my data model, I aggregated accounts and assets by EmployeeId number. Many employees do not have assets/accounts, but because I want to retain ever... Show MoreIn my data model, I aggregated accounts and assets by EmployeeId number. Many employees do not have assets/accounts, but because I want to retain every employee in the data model, I left joined the summary statistics to the EmployeeId list. To clean the data, I want to replace the null values with 0 and then apply formatting.
The code I have below doesn't work correctly. The null values in the accounts field are replaced with zero, but they are formatted as text instead of numbers. In the assets field, the original values are formatted as numbers, not currency. And the previously null values are "$0.00" which I would expect. I played around with the num# function and changing the nesting order but couldn't get this to work. Any idea what might be going on or how I can fix it? Thank you for the help.
FinalCleanTable:
NoConcatenate
Load
EmployeeId,
num(if(isnull(Accounts), 0, Accounts), '#,##0.') as Accounts,
num(if(isnull(Assets), 0, Assets), '$#,##0.00') as Assets
Resident FinalTable;Drop Table FinalTable;
-
Cumulative Sum across periods with reset
Hi, I am trying to create a cumulative sum across various periods within a financial year but running into a few issues. Image of my data set below. ... Show MoreHi,
I am trying to create a cumulative sum across various periods within a financial year but running into a few issues. Image of my data set below.
In the above image you can see the activity is the same as the cumulative sum, but that shouldn't be the case.
The formula I have tried
- RangeSum(
Above(
Sum({
<PeriodID = {">=$(vLastYearStartPeriod)<=$(vLastYearEndPeriod)"}>
} [Transaction Amount]),
0,
RowNo()
)
)Keep in mind that another dimension is called account code. So, when it goes into a new account code, the cumulative sum should reset to whatever the activity number is.
-
qlik-embed web components with Qlik Sense Enterprise for Windows - error
Hi, I'm trying to replace our legacy qlik iframe embedding solution with the new qlik-embed solution. I'm using web components, with the qlik instan... Show MoreHi, I'm trying to replace our legacy qlik iframe embedding solution with the new qlik-embed solution.
I'm using web components, with the qlik instance being a self-hosted Qlik Sense Enterprise on Windows - version 14.187.17 - May 2024 Patch 11.
I have it setup like this:
in <head>:
<script crossorigin="anonymous" type="application/javascript" src="https://cdn.jsdelivr.net/npm/@qlik/embed-web-components@1/dist/index.min.js" data-host="my qlik instance url" data-login-uri="my qlik virtual proxy url for saml auth" data-cross-site-cookies="true" ></script>where I show the embed:
<qlik-embed ui="classic/app" app-id="25351469-02f7-4043-9549-968d0677fd4a" ></qlik-embed>based on documentation I would expect this to work, but I just get this error:
index.js:24 Qlik runtime system not found: https://<qlik instance domain>/qlik-embed/main.js
That URL does resolve a valid JS file.
-
QlikView Update when LEF is expired
Hi there, I quick question: is it possible to update QlikView Server after LEF has expired? Of course, you need to be able to download the installer, ... Show MoreHi there, I quick question: is it possible to update QlikView Server after LEF has expired? Of course, you need to be able to download the installer, but what happens when you validate the installation with an expired LEF?
Thanks in advance
-
Failed to open qvw File
Hi everyone. I have a Problem with opening from qvw files. Most of the users get an error and the other can open the file. Can someone help? Thnx -
Apply calculation in Inline Table
Hi AllI face a difficulty with how to bring calculation into inline table and then how to use it as measure within table object. The idea is to take f... Show MoreHi All
I face a difficulty with how to bring calculation into inline table and then how to use it as measure within table object. The idea is to take fields from DB table (in example below it is a "Numbers" table). And then in inline table "Test" create several dimetions and associate them with particular calculations. I need to do this to have possibility sow in pivot table different calculations aggregated by created dims.
But as long as I tried I have no luck with how to specify calculation correctly within "Test" table and then use them ad measure within pivot to achieve calculation results. I will appreciate any hint regarding this.Numbers:
Load* Inline [
F1, F2
1, 4
2, 5
3, 6
];test:
LOAD * INLINE [ParentLevel, ChildLevel, Calculation
'Total', 'First', 'Sum(F1)''Total', 'Second', 'Sum(F2)'
'Total', 'Third', 'Sum(F1-F2)'
'Row', 'Row High', 'Sum(F1)-20'
'Row', 'Row Low', 'Avg(F2)'
]; -
Cumulative YTD Calculation in Line Chart
Hello everyone, I would like to create a visualisation in Qlik Sense that calculates the cumulative number of incidents for each year. What sounds sim... Show MoreHello everyone,
I would like to create a visualisation in Qlik Sense that calculates the cumulative number of incidents for each year. What sounds simple at first, presents me with major challenges when developing a suitable key figure. The following criteria must be covered by the formula of the key figure:
- The calculation should start from zero on 1 January of each year
- The number of incidents (Count(IncidentID)) must be calculated cumulatively within a year
- The key figure must be presented in the form of a line chart
- A drill-down dimension with year, month and date serves as the dimension
- The value must not change if a date is selected
Two tables are available as a database for this, which I have mimicked in the attached sample application. One table, ‘Calendar’, contains the relevant date fields, while the ‘Incidents’ table contains the unique IDs of the incidents.
So far I have tested the following formula:
RangeSum(Above(Count(IncidentID),0,RowNo()))
The result is already very close to the target - the only problem is that the calculation does not start from zero on 1 January each year. Addtionally, it is calculated dynamically in the case of date selections.As a result, based on the sample data, I expect the chart to show 6 as the cumulative number of incidents for 31/12/2023, 0 as the cumulative number for 01/01/2024 and 8 as the cumulative number for 14/02/2024, for example.
I would be pleased if someone could help me. Many thanks in advance.
-
Section access reduction on one field with date range Historical data
Hello, I need to add section access where the reduction is on the Company field. However, I have other conditions: Group 1: Should have access to com... Show MoreHello,
I need to add section access where the reduction is on the Company field. However, I have other conditions:
- Group 1: Should have access to company GH when the date is before 2024/12 and should have access to GHM if the date is after 2025/01.
- Group 2: Should have access to GH only when the date is after 2025/01.
- Group 3: Should have access to all data.
Note that, we have date for both companies for both years 2025 and 2024
What are the best ways to do this ?
Thank you!
-
In my dashboard in Qliksense I have 13 sheet and I want to navigate to the sheet...
Hello All,In my dashboard, there are 13 sheets, so to Navigate my Landing page, if I create 13 buttons, then it's looking ugly. So give a solution tha... Show MoreHello All,
In my dashboard, there are 13 sheets, so to Navigate my Landing page, if I create 13 buttons, then it's looking ugly. So give a solution that from one button only or anything else, I should be able to navigate accordingly. I don't want to create 13 buttons for this.
Global Conference
Register for Qlik Connect before the ball drops on December 31, and save $500!
Qlik Reporting Service: A (Pixel) Perfect Update!
Qlik Reporting Service received a significant upgrade with several new features!
Trends 2025 Alert!
Join us on Jan. 15 for expert guidance on thriving post-AI with After AI: Reinventing Data, Insights, and Action Amidst the Noise.
Qlik Community How To's
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Your journey awaits! Join us by Logging in and let the adventure begin.
Customer Story
Accelerating Decision-Making with Qlik Insights
Qlik enhances decision-making with high-speed insights, as Mayborn Group integrates data from various functions across their global operations, gaining a competitive edge in the childcare industry.
Customer Story
Efficiency in Agriculture: Nortera's Qlik Triumph
Nortera leads agricultural manufacturing analytics and automation with Qlik, reducing short-shipment rates and annual savings in water consumption.
Customer Story
Revolutionizing aircraft production through Data Analytics
Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.
Location and Language Groups
Choose a Group
Join one of our Location and Language groups. Find one that suits you today!
Healthcare User Group
Healthcare User Group
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Japan Group
Japan
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Brasil Group
Brazil
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Blogs
Community News
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!