Load

"JOB" AS [Position ]
, If(
WildMatch([JOB],'*DRIVER*', 'Driver')
,[JOB]) as [Position1]

I have Positions as "motorcycle driver", MVC driver, MTR driver, i want to replace everything and name them as "DRIVER" when data load.

Hello,

The requirement is like

if the user selects Jan 2022 the start date should be 31/12/2021 (start of the month [minus] 1 day) and the end date should be the end of the month ie. 31/01/2022.

Hi there,

I am trying to create a table that excludes some information based on the value in a field from some Excel documents I uploaded. To elaborate: I uploaded 4 different Excel files that show how up-to-date some assets on a website are, each one from a different date (one is from July 15th of 2021, another from October 2021, another from December 2021, and the last from January of 2022).

I gave each dataset a column labelled "Date of Collection" to differentiate each asset from the assets with the same names in the other files (7/15/2021 for the dataset from July 2021, 10/26/2021 for October's, etc.), and for the first sheet in my app, I was hoping to have a table with different bins to show how far out of date each asset was at the time the dataset was downloaded.

I've attached a photo of my Qlik sheet so far--the correct number of assets is 4,591 like in the KPI visualization, but notice that the total number of assets in the right column of the "Number of Datasets Out of Date, by Days" table is pulling all 14,808 assets from all 4 datasets. Here is also the code I initially tried putting into the Expression field in the properties tab:

Count({<[Date of Collection]={'7/15/2021'}>}[Date of Collection])

Any insight you may have is appreciated; let me know if I need to clarify anything. Thank you for your help!

I'm seeing warnings and failures during our Veeam backup operations (sqlserver).  I'm guessing Replicate has issues when Veeam truncates the log files as part of its backup strategy.   What is the best way to configure replication when using a third party backup solution such as Veeam?

During the backups we get these a a few other errors/warnins...

mssql_approve_table_full_logging_setup(...) failed in checking PK presence for table identified by ID '1954106002'

LSN '001f611b:00003584:0003' could not be retrieved as it is located in the backup logs, while the endpoint is configured to access the online logs only

Task 'Production PHI Replication' encountered a recoverable error

Hi!

A Qlik Sense trial customer complains about the fact that there are unsigned PowerShell Scripts used in the installation process and the installation manual explicitely says that it needs them. To install Qlik Sense, one has to explicetely bypass such an execution policy.

- Why is that needed?

- What are the scripts needing this and what do they do?

- Is it planned to change this?

Their company policy does not allow the execution of unsigned scripts.

Thank you!

Henning

We have a requirement where we need capability to allow multiple users work on the same sheet (not view only, on lines of collaboration). I looked up on help here and all I see is links to Qlik Cloud(https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Spaces/working-cloud-hub.htm).

I am unable to find any link for Qlik Sense Enterprise. We are using Qlik Sense Enterprise February 2021.