Ask a Question

Welcome to
Qlik Community!

Recent Discussions

Sort By:

Connectivity & Data Prep

MSOLEDBSQL - ApplicationIntent (Qlikview)

We have upgraded the OLEDB SQL driver on the QlikView Publisher. Now the new connections to the data source are connecting with MSOLEDBSQL.1 provider... Show More

We have upgraded the OLEDB SQL driver on the QlikView Publisher. Now the new connections to the data source are connecting with MSOLEDBSQL.1 provider. This is all working fine but Application Intent parameter is not working. The source database is SQL server in Always On configuration. When the QlikView is connecting to the listener DB node it is not redirecting the request to the secondary nodes based on the parameter ApplicationIntent=ReadOnly. The QlikView version is May 2024. Can anyone help with this.
Show Less

By viz301 2025-01-22 / 12:57 AM

0 0 4

Show percentages on Stacked Bar chart

Hello, I would like to show the percentages for each of the dimension values instead of the sheer values. How can I do this in this chart? Here an ex... Show More

Hello, I would like to show the percentages for each of the dimension values instead of the sheer values. How can I do this in this chart?

Here an excerpt of the data

Risorsa	Conformità	Risorsa
User1	Conforme	100
User1	Non Conforme	48
User2	Conforme	3
User2	Non Conforme	1
User3	Conforme	47
User3	Non Conforme	40
User4	Conforme	105
User4	Non Conforme	13

Show Less

Qlik Replicate

Stop all tasks on Qlik Replicate?

Hello everyone, I currently have a Qlik Replicate instance with dozens of tasks running CDC operations. Is there a command to stop and start all tasks... Show More

Hello everyone, I currently have a Qlik Replicate instance with dozens of tasks running CDC operations. Is there a command to stop and start all tasks at once? Thank a lot.
Show Less

By kellychou 2025-01-22 / 12:32 AM

0 0 11
Qlik Enterprise Manager

Fuzzy Matching/string similarity in Qliksense

Is fuzzy matching possible in Qliksense with 60-70% string similarity? For Eg. I have 2 tables. Feild1: F1 From Source1; Field2: F2 from Source2; ... Show More

Is fuzzy matching possible in Qliksense with 60-70% string similarity?

For Eg.

I have 2 tables.

Feild1:

F1

From Source1;

Field2:

F2

from Source2;

Suppose in Field1, I am having 'IBM & SALARY COMPLETE PROJECTS' and in Field2 I will be having 'IBM INDIA PVT LTD'. I want to join/link Field1 and Field2 with 60% similarity between the strings.

Please let me know if it's feasible in QlikSense.

Show Less

By Tan1 2025-01-21 / 10:17 PM

3 0 39
QlikView App Dev

Requires the Total value of this condition.

Want the total value as shown in the red box. In this condition, what should I do? This is the code. What should I do?if(if(([Average (Left point)]+[... Show More

Want the total value as shown in the red box. In this condition, what should I do?

This is the code. What should I do?
if(if(([Average (Left point)]+[Average (Middle point)]+[Average (Right point)])/3 > SpecMax or
([Average (Left point)]+[Average (Middle point)]+[Average (Right point)])/3 < SpecMin,'Rej.','Acc.')='Rej.' and If(
Max(Aggr(If(RangeMax(LeftPointA, LeftPointB, LeftPointC, LeftPointD, MiddlePointA, MiddlePointB, MiddlePointC, MiddlePointD, RightPointA, RightPointB, RightPointC, RightPointD) > SpecMax + (RangeSum(SpecMax, SpecMin) / 2) / 2
OR
RangeMin(LeftPointA, LeftPointB, LeftPointC, LeftPointD, MiddlePointA, MiddlePointB, MiddlePointC, MiddlePointD, RightPointA, RightPointB, RightPointC, RightPointD) < SpecMin - (RangeSum(SpecMax, SpecMin) / 2) / 2,1, 0),
WO_WorkOrderNo, Timestamp
)
) = 1,
'Invalid data',
'Valid data'
) = 'Valid data',Count(Aggr(WO_WorkOrderNo,Timestamp)))

Show Less

By Paknanarn23 2025-01-21 / 10:46 PM

3 0 53
Qlik Cloud Data Integration

Application performance

hello guys. i'm just wondering how do you guys deal with large datasets that require multiple aggregations and treatements cause for me the loading t... Show More

hello guys.

i'm just wondering how do you guys deal with large datasets that require multiple aggregations and treatements cause for me the loading time takes forever and sometimes fails to complete and using the application becomes quite laggy i tried to resort to making views for the aggregations and import them but the more i make the slower app becomes for example:
Marque_Tom:
LOAD
[Marques],
Q35_DES,
Marques_TOM;
SELECT
Q35 as Marques,
Q35_DES,
Count(Q35) as Marques_TOM
FROM DataShare.dbo.FAIT_Q35
Group By Q35_DES,Q35;
became like this
[Marque_TOM]:
SELECT Marque,
Vague,
Code,
"Marques_TOM"
FROM "Market_Study".dbo."Marque_TOM";

it's just an example i removed aggregations from the data loading part and yes if it was this alone it would not be a problem but i have plenty more and it made it very slow cause it keeps creating correspondence keys and basically impossible to use i hope you help me
Show Less

By RyugaHideki 2025-01-18 / 03:48 AM

7 1 139

New to Qlik Analytics

Calculated fields in Script load / table columns by month

Hi everybody! I'm new to Qlik and I stumbled upon a problem in script load. I need to calculate 4 fields and show them in the table columns. please ... Show More

Hi everybody!

I'm new to Qlik and I stumbled upon a problem in script load. I need to calculate 4 fields and show them in the table columns. please help me to show them in table by Month like Jan 2023 , Feb 2023, and so on.

I have data from Jan 2019 to present but here i am created inline sample table.

I have logic for these calculations and they are static for Jan 2023. it worked fine in KPI's but I don't able to show them in the table dynamically for every month. The logic of the calculations should be like for Jan 2023 :

Calculation 1 :

P Release Date is before start of month

Deleted On is blank

PO Release Date is blank

Calculation in KPI: Count({$<[P Release Date]={"<=1/1/2023"}, [Deleted On]={-},[PO Release Date]={-}>}[P Release Date])

Calculation 2 :

P Release Date is before start of month

Deleted On is blank

PO Release date is after start of month

Calculation in KPI: Count({$<[P Release Date]={"<=12/31/2022"}, [Deleted On ]={-},[PO Release Date]={">=1/2/2023"}>}[P Release Date])

Calculation 3 :

P Release Date is before start of month

Deleted On is after start of month

PO Release Date is blank

Calculation in KPI: Count({$<[P Release Date]={"<=1/1/2023"}, [Deleted On]={">=1/1/2023"},[PO Release Date]={"-"}>}[P Release Date])

Calculation 4 :

P Release Date is before start of month

Deleted On is after start of month

PO Release Date is after start of month

Calculation in KPI: Count({$<[P Release Date]={"<=1/1/2023"}, [Deleted On]={">=1/1/2023"},[PO Release Date]={">=1/1/2023"}>}[P Release Date])

Calculation 5 :

Add 1, 2, 3, and 4.

Let's have an example:

main:
load * inline [
P Release Date, Deleted On, PO Release Date
12/21/2022, -, 1/18/2023
12/23/2022, 2/27/2023, -
12/27/2022, -, -
1/4/2023, 1/24/2023, -
1/4/2023, -, 1/17/2023
1/4/2023, -, 2/28/2023
1/4/2023, -, 11/30/2023
1/6/2023, -, 2/9/2023
1/6/2023, -, 2/16/2024
1/11/2023, 5/10/2023, -
1/17/2023, 3/17/2023, -
1/17/2023, -, 4/11/2023
2/2/2023, -, 2/7/2023
2/2/2023, -, 6/21/2023
2/6/2023, 6/6/2023, -
2/15/2023, 9/11/2023, -
2/15/2023, -, 3/14/2024
3/2/2023, -, 5/3/2023
3/2/2023, -, 8/16/2023
3/2/2023, -, 9/22/2023
3/6/2023, -, 1/2/2024
3/30/2023, 4/11/2023, -
3/30/2023, 6/7/2023, -
3/30/2023, 8/7/2023, -
3/30/2023, -, 4/20/2023
3/30/2023, -, 8/29/2023
];

Output Result (in the table):

	Calculation 1	Calculation 2	Calculation 3	Calculation 4	Total of calculation 1,2,3, and 4
Jan 2023	0	1	1	0	2
Feb 2023	1	4	3	0	8
Mar 2023	1	3	4	0	8

Do you have any ideas, please?

Show Less

437

Qlik Replicate

IBM Db2: After full load no changes are captured for tables that contain danish ...

Hello, As the title says, after full load no changes are captured for tables that contain danish letter or none ASCII characters. The other tables are... Show More

Hello,

As the title says, after full load no changes are captured for tables that contain danish letter or none ASCII characters. The other tables are working fine. We also have global rules that replace table name and column name with ASCII characters on the destination. The other tables within same task are captured and no error or warning are shown in the logs.

We are using Qlik Replicate 2024.5.0.144.

Source: IBM Db2 Database to Logstream (DB version: 7.3)
Destination: Logstream to Kafka

Example table names:
TRPFØ00
TRPSÆ00

The journal is enabled on those tables too.

ODBC Drivers:
Client Access ODBC Driver 13.64.25.00
iSeries Access ODBC Driver 13.64.25.00
Attunity Replicate AIS ODBC Driver 3.5 (Unicode) 6.00.00.31

What can the issue be?

Show Less

By PatricNyander 2025-01-21 / 11:13 PM

0 0 27
App Development

Using indirect selection in Set Analysis to get the SUM of amount spent

Hi,This expression below correctly gives the number of reactivated customers after a gift campaign targeting dormant customers: Expressoin 1: =count... Show More
Hi,

This expression below correctly gives the number of reactivated customers after a gift campaign targeting dormant customers:

Expressoin 1:
```
=count(DISTINCT{
(
<[Campaign Customer]={1},ORDER_DATE={"<$(vDateDormantAfter)"}>
-
<[Campaign Customer]={1},ORDER_DATE={">=$(vDateDormantAfter)<$(vCampaignDate)"}>
)
*
<[Campaign Customer]={1},ORDER_DATE={">=$(vCampaignDate)"}>

}PHONE_NUMBER)
```
Now, I'm trying to get the amount spent in our stores after they have been reactivated using the following expression:

Expression 2:
```
=Sum(
{<
[Campaign Customer] = {1},
ORDER_DATE = {">=$(vCampaignDate)"},
PHONE_NUMBER = P({
(
<[Campaign Customer]={1},ORDER_DATE={"<$(vDateDormantAfter)"}>
-
<[Campaign Customer]={1},ORDER_DATE={">=$(vDateDormantAfter)<$(vCampaignDate)"}>
)
*
<[Campaign Customer]={1},ORDER_DATE={">=$(vCampaignDate)"}>
} PHONE_NUMBER)
>}
ORDER_WITHOUT_TAX_AMOUNT
)
```
this gives a number bigger than expected, so I created a Stright Table and added this expression to the dimension:
```
=Aggr(
    Only({
        (
            <[Campaign Customer]={1}, ORDER_DATE={"<$(vDateDormantAfter)"}>
            - 
            <[Campaign Customer]={1}, ORDER_DATE={">=$(vDateDormantAfter)<$(vCampaignDate)"}>
        )
        * 
        <[Campaign Customer]={1}, ORDER_DATE={">=$(vCampaignDate)"}>
    } PHONE_NUMBER),
    PHONE_NUMBER
)
```
This returns the correct phone numbers but it also returns "NULL", and by adding the expression that returns the sum of the amount spent to the table, it turned out the larger than expected amount is coming because of the "Null" value in the dimension. this can be fixed by excluding null in the table properties but how can I do the same for the expressoin 2 ?
Show Less
By AHMB 2025-01-21 / 12:04 PM

3 0 64
Move to SaaS

data types issues in Qlik SaaS cloud

Hi there, we have recently noticed that if any filed that has both num and text values are being considered as text only instead of text and num. we h... Show More

Hi there,

we have recently noticed that if any filed that has both num and text values are being considered as text only instead of text and num. we have observed this for handful of fields is there a way to address it in the load script or by using any predefined variables.

Thanks in Adavance!

Regards,

Raju
Show Less

By Raju_6952 2025-01-03 / 05:57 AM

5 0 124

High Five

Meet Alex

Our featured member for January 2025

Leaderboard

JandreKillianRIC

marcus_sommer

MatheusC

durgesh22

rwunderlich

Popular Resources

View All

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.