Hi Qlikers,

I want set expression for sum of sales with dates from starting of last month till end of last month.

So, if today is 12/07/2024

I want sum of sales from 01/01/2023-30/06/2023 since we are in between of current month.

Set expression please.

Regards,

Hi Team,

We have 7 CDC tasks running in Transactional apply mode with different SCN's and Schemas. PFB Transaction Offload Tuning:

Total transactions memory size exceeds (MB): 1024
Transactions duration exceeds (seconds): 60

Since we were not provided ASM privileges and logs were getting stored outside ASM in Backup folder.

Previously the data is accumulating on the Source Disk and waiting until source commit. So, we've requested for increase in Memory and virtual processors along with Network bandwidth. Currently we've got Memory - 64GB, virtual processors - 16 and Network bandwidth from source - 50mbps allocated. Now the data is getting stored in Target - On Disk, we've added buffer parameters to the task as below mentioned:

"common_settings": {
"stream_buffers_number": 20,
"stream_buffer_size": 100,

Source - Oracle

Target - Bigquery [commit mode is enabled]

Still we can see the increase in Latency for all the tasks. Any suggestions on how can we bring down the latency and speed up the log processing time?

This Techspert Talks session covers:

• Using the Qlik Sense QPI tool
• Upgrading a Stand-Alone Database
• How to resolve common issues

Chapters:

• 01:02 - Intro to PostgreSQL Repository
• 02:51 – Prerequisites
• 03:24 - What is the QPI tool?
• 05:09 - Using the QPI tool
• 09:27 - Removing the old Database Service
• 11:27 - Upgrading a stand-alone to the latest release
• 13:39 - How to roll-back to the previous version
• 14:46 - Troubleshooting upgrading a patched version
• 18:25 - Troubleshooting upgrade security error
• 21:15 - Additional config file settings
• 22:52 - Q&A: Are Initial Releases good to run?
• 23:29 - Q&A: When is next release of QPI tool?
• 24:00 - Q&A: Which versions have security issues?
• 24:36 - Q&A: Is version 16 recommended?
• 24:55 - Q&A: What order should upgrades be done in?
• 25:30 - Q&A: Will QS May 2022 work with latest PostgreSQL?
• 25:55 - Q&A: Are settings saved with an upgrade?
• 26:42 - Q&A: Is the upgrade process different if on D drive?
• 27:25 - Q&A: Are there any certificate concerns?
• 27:47 - Q&A: Can the Repository password be changed?
• 28:08 - Q&A: Why the error about running 9.6 after upgrade?
• 28:42 - Q&A: How to upgrade QS WITH the bundled repository?
• 29:30 - Q&A: Is upgrading PostgreSQL needed with QS 2024?
• 30:18 - Q&A: Can we run a Test environment with the same license?

Resources:

• Upgrading and unbundling the Qlik Sense Repository Database using the Qlik PostgreSQL Installer
• Installing or upgrading PostgreSQL using the Qlik PostgreSQL Installer
• Backing up a Qlik Sense site
• Changing the Database Superuser Password without Qlik Sense Installed
• PostgreSQL Download site

@Sebastian_Linser 

what role does a user need in order to be able to publish from my sheets they have created in an app so the sheet can be accessed by others? I don't want to give them ability to publish apps or modify any base sheets, but as a user with no elevated role, I do not have publish in the right click menu.

I've spend several days trying to get right the path format that the 'Open File' connector takes when Sharepoint is chosen. The 'Site ID' seems pretty straightforward, with the LookUp option. However, I tried filling in the path several different ways and none worked; URL coded, relative, starting with a '/', starting with the first folder, double URL coded... nothing seems to work. I actually created a flow in Power Automate just to get these different path types.

Has anyone successfully connected to a sharepoint site to open a file? If so, how did you write the path?

During the last 2 weeks, our Qliksense production environment encounters a serious performance issue.

Symptoms:

- In mornings it takes quite a while to open an app. On screen the message "initializing" is displayed for a long time, and then, after a while, it shows "App is opened" for a while.

- The HUB screen shows an error message after a couple of minutes, stating something like "Error has occurred, connection timed out because of inactivity".

- Once the app finally opened, it works as expected (not very slow).

- Our test environment (other server) works fine (no errors, less users, but same amount of data).

- After the qlik services have been restarted, the system works fine again.

- Next morning, the system is slow again, and needs to be restarted all over again.

- Nprinting and Qlik tasks are running without issues.

Anyone has a clue as to where we should look to investigate/solve this issue?

I have 2 relevant tables that are loaded in the load script. Below is how they look in the data model:

I use these to create a table to show which employes assigned to the differe groups. This works for most part, except that when an %MDW_ID is not entered in the source file (but only a name is for example), the table goes completely wrong:

as you can see, the 'Aantal'  in the left column has many time the same number while each number should be in there only once. this is how the source file looks like:

Many rows where the field "ID-nr" is empty.

under 'Name' there is one person who is in the table twice. While he isnt even member of group 2.00 (but only assigned to group 'Staf' and also to group R1.80. How is it possible his name shows up in a table which should only show members from group 2.00?

I expect it has something to do with the field %MDW_ID because that is the linked field. And this employee is also in the list without a mention of his %MDW_ID.

However, I would expect the table would simply only show all the lines that have 2.00 in the group field. But this is not how it is working apparently. Can someone explain to me how it works?