Hi, i have an expression below:

=count({<org_name -= {GetFieldSelections(org_name)}>}patient_region)

In this I am trying to insert a set analysis to ignore the current selection made on the [org_name] field. I keep getting an error. What is the proper expression for it?

Thanks in advance!

Client needs to do maintenance on the target DB and has asked for the Replicate tasks to be paused.  If I pause the tasks, can the Source database remain active and any activity will catch up when the tasks are restarted?  If so, do I need to start the tasks from a point in time or just resume?

This is last minute request for maintenance tonight and I want to be sure I manage the tasks correctly.  Any assistance is appreciated.

Thank you,

Mary

hi,

i have 2 different tables:

Example:

Table1:

Table2:

I want to have one filter where i search the name from table1 or table 2.

I've seen solutions but only with the data load editor, which we dont want to use if possible, because we are using the data manager 😕
Is there any way to do it in the frontend?

In sql it would be a simple ... where Table1.Name = X or Table2.Name = X

Hi,

executing CTE in Qlik Sense Desktop i have

 Executing non-SELECT queries is disabled

How to enable non-SELECT queries with Microsoft SQL Server Connector (no ODBC Connector).

Regards,

Antonio

Hi,

I am relatively new to Qlik and fully new to set analysis, thus I would appreciate your advice.

I was trying to get set analysis to get constant graph results, regardless of filters, that is why i used the 1 identifier:

if ({1<[Tab1] like {'ABC*'}>}, {1<[Tab1]>})

I have tried to rewrite it in different configurations as suggested in a few forum conversations, so far unsuccesfully.

Hi

I am facing an issue in mapping load script.

MappingTableAddr:

Mapping load 

CustomerID,

Address

from abc.qvd;

MappingTableCity:

Mapping load 

CustomerID,

City

from abc.qvd;

Table11:

BillDate,

CustomerID,

Applymap('MappingTableAddr',CustomerID,'NA') as Address,

Applymap('MappingTable'City,CustomerID,'NA') as City

from abc.qvd;

My raw data is 

I have null values for the bill date 1.4.21. I would like to copy the same address since the customer ID is same. I tried the above code but I still get NULL values. Any help.

Thanks in advance!