Top

Dear experts,

I recently started in team, that is responsible for QlikView and Qlik Sense and I don´t have much experiences yet with Qlik.

This morning I recognized a red flag on the QlikView QMC that says, that the "support of the product expires on 01.01.2025". We just updated the QV server version a couple of weeks ago to May 24 SR1 (Client Build Number: 12.90.20100.0)

Can anyone tell me, why this appears now and what I could do or need to do? If I check the internet, I can see, that releases  are normally supported for 24 month.

Thx in advance.

Dear experts,

I´m new to Qlik and therefore I do not have much experience with the tool. We are running a QlikView Server and figureds out, that there is an old server listed under QMC->Status->Services (I attached a sreenshot "Status-Services).

If I check QMC->System->Setup, I can see, that the server is listed in folder "License Server" (see attachment "Setup_license server_2")

But if I check QMC->System->Licenses, there is no entry  (see attachment "system_license_3")

My questions are:

- Is it possible to delete the unused server from the QlikView server and if yes, how can I do it?

- If I delete the server from QlikView server, would it cause any issue with the license service?

Would be great, if someone could help me,

Thx in advance

Good day everyone,

I have a user that is trying to share a Qlikview report via e-mail but all the time he tries it, instead of being redirected to outlook a browser blank page pops up. 

Could you guys help me solving it?

My sincere thanks in advance.

Hi Everyone.

Database system department has changed the database server and they have passed from a TLS 1.0/1.1 to a TLS 1.2 one.

We are working with a QS Enterprise august 2023 (supported version) and a OLE DB connection (Microsoft OLE DB provider for SQL Server) in a Windows 2016 server.

We have tried all possible kinds of OLE DB connectors QS offers but no one is working (connection errors) even if:

• We have created the regedit folders to enable the TLS 1.2 protocol (How to Check and Enable TLS 1.2 - 365 CloudIT).
• We have installed the OLE DB Driver for SQL Server (OLEDB Connection not working with TLS 1.2 - Qlik Community - 1717492).
• We have tried to create a Microsoft SQL Server connection, cause it allows to set a TLS 1.2 protocol; it's connecting but we can't use this kind of connection due to different data formats that are generating lots of errors (especially date formats in conditions).

DB system department has temporary enabled the TLS 1.0, so QS connection is now working but for security rules we have to pass to a TLS 1.2.

Next step we want to try is migrating our QS to a Windows 22 server, in order to create a PRE environment.

We are looking for more suggestions, before migrating QS (even if we are aware that creating a PRE environment is necessary).

Thanks in advance. Regards,

Alice B.

Hello
I have in my dashboard two dimensnions (fiscal year and month)
I have a calculation to make which is the total attrition budget which is on the latest available month of the fiscal year
My fiscal year starts on October
I managed to get the number per fiscal as shown below; but I need to repeat this value on all months of the fiscal year:
so I want to repeat the -198 from 2023-10 till 2024-09 and repeat the -20 from 2024-10 till today 202412

Good morning.
I am trying to make a report, where I can identify the contracts that rent properties and color the fields in red the properties or contracts that have not increased their rent each year that their contract is renewed, the profitability of the property increases each year.
So I need to identify with a red color the properties that have not increased their profitability after a year. and mark only the field where the increase in income is not displayed.

I am using a pivot report.

Could you tell me how I can apply those colors?

Annex image of an example.

I appreciate your support.
Greetings.

I'm willing to wager on that. Getting more Finance Profit Bot means using more of it where it matters most. Many wanderers respond they have no luck at all with doing this. Don't let your doubts prevent you from taking on that. I have been working with that since last week.

SHOP NOW => https://www.blockxtrade.com/finance-profit-bot-reviews/

Read More:

https://financeprofitbot.company.site/

https://financeprofitbotreviews.company.site/

Hello 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.

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.

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. 

I am trying to run a python code with 1 parameter using External program task in QMC.

We are migrating to new production server and on the previous server same exact code worked with no problem.

On the new server exact code, with exactly same setting gives "Process start returned null" error.

I have found a workaround using following configuration but would like to use previous tasks.

Hi everyone,

I’m Darshan Hiranandani, looking for advice on how to stay up-to-date with the latest updates and features in Google Analytics. I’ve noticed that I often find myself researching new changes only after they’ve already been released, and I’d like to be more proactive in keeping track of updates as they happen.

How do you all manage to stay informed about new features, updates, and best practices for Google Analytics? Are there any resources, newsletters, or communities you recommend for keeping up with the latest trends?

Looking forward to hearing your suggestions!

Kind regards,
Darshan Hiranandani

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 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:

Incremental Qvd is having below records:

My result would be like

We are using AutoNumber(Dim1&Dim2&Dim3&Volity Code) as KEY

we have added new field for comparison and field name is Weight

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

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 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;

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 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.