Hello,

I have a wide table and I'm looking group certain columns together into three groups (Location, Personnel And Skills). For example, by selecting Location it will filter the table to only Location columns (Zip code, Address, City).

Columns: Zip Code, Address, City - Location

Columns: Job, Gender - Personnel

Columns: Sales Experience, Merchandising, Management - Skills

Any help on how to do this is appreciated. Thank you!

Hello,

in set analysis I want to ignore active filter but not variable base on filter.

I try to ignore Dealer, but Dealer define variable vDistrictDealer. Do you have same idea for this?

Max(Aggr(Sum({< Fakt = {'Def'}, Year = {"$(=Year(vMaxDatZap))"}, [District] = {'$(vDistrictDealer)'}, Dealer= >}[#Reg]), [District],[Brand]))

Thank you

Hey everyone, I'm at wits end with this problem. Any help is greatly appreciated!

Scenario:
- Determine average response time from customer -> support agent, and average response time from support agent -> customer, for each case id in the dataset. 

Dataset example:

So support response times would look at the time difference between message types 5 or 8 (support replies), and 1, 2, or 3 (customer questions). 
Customer response times would look at the time difference between message types 2 or 3 (customer replies), and 5 (support answers).

Has anyone had experience answering a similar problem in their work?

Hello

I have a series of measure that have the following format

KPI_A.Monthly

KPI_A.Target

KPI_A.Accumulative

KPI_A.EOY

KPI_B.Monthly

KPI_B.Target

KPI_B.Accumulative

KPI_B.EOY

KPI_C.Monthly

… etc …

I also have a table with the root name of the measures

KPI_Key

KPI_A

KPI_B

KPI_C

…

1) 1st Method

If I inject this table inside a variable (KPI_Analyzed_Key), I can (with a drop-down selector) select a KPI_Analyzed_Key and then display all the associated measure using this expression:

[$(KPI_Analyzed_Key).Monthly]

And it works perfectly, I’ve got the monthly value for the selected KPI

2) 2nd Method

Using the same approach, I want to display all my measure in the same table… I would like to have something like that

However, I cannot manage to get it …

I’ve tried to duplicate the same formula as previously:

[$(KPI _Key).Monthly]

but its not working.

Any clue ?

I ran into a VERY strange behavior in Qlik Sense set analysis. I'm hoping someone here can explain why set analysis is producing different results on identical data set.

The app that demonstrates the issue is attached.

Context

I have one table that looks like this:

Here's the script for that table:

table_temp:
Load *
Inline [
id|name|name_qa_results|super_qa_results
1|name_1|Match|Match
2|name_2|Match|Match
3|name_3|Match|Match
4|name_4|Match|Match
5|name_5|Match|Match
6|name_6|Match|Match
7|name_7
8|name_8
9|name_9|Match|Match
10|name_10|Match|Match
11|name_11|Match|Match
12|name_12
13|name_13
14|name_14
15|name_15
16|name_16|Match|Match
](delimiter is '|');

table:
NoConcatenate
Load id
	, If(Len(Trim(name_qa_results)) = 0, Null(), name_qa_results) as name_qa_results
    , If(Len(Trim(super_qa_results)) = 0, Null(), super_qa_results) as super_qa_results
Resident table_temp;

Drop Table table_temp;

Then I have an expression in a text object that counts IDs that have a 'Match' value in super_qa_results field or an id number 7, like this:

Count({<super_qa_results = {'Match'}> + <id = {7}>} distinct id)

This expression produces accurate count which is 11:

The Problem

However, if I create an identical table that has two other tables associated with it and one of the associated tables has only one of all possible IDs, then the same expression produces the wrong count.

Here's what the data model for the second table looks like:

and here's the script to generate the second table along with the linked tables:

table_temp_2:
Load *
Inline [
id_2|name_2|name_qa_results_2|super_qa_results_2
1|name_1|Match|Match
2|name_2|Match|Match
3|name_3|Match|Match
4|name_4|Match|Match
5|name_5|Match|Match
6|name_6|Match|Match
7|name_7
8|name_8
9|name_9|Match|Match
10|name_10|Match|Match
11|name_11|Match|Match
12|name_12
13|name_13
14|name_14
15|name_15
16|name_16|Match|Match
](delimiter is '|');

table_2:
NoConcatenate
Load id_2
	, If(Len(Trim(name_qa_results_2)) = 0, Null(), name_qa_results_2) as name_qa_results_2
    , If(Len(Trim(super_qa_results_2)) = 0, Null(), super_qa_results_2) as super_qa_results_2
Resident table_temp_2;

link:
Load Distinct id_2
	, name_2
Resident table_temp_2
;

Drop Table table_temp_2;

dbOwner:
Load *
Inline [
id_2|db
16|db_1
16|db_2
16|db_3
16|db_4
](delimiter is '|');

and here's the screenshot of same text object with same expression (except it referencing fields from the second table, of course) generating wrong results:

Both table and table_2 have identical data, yet when I add two other tables to be associated with table_2, the set analysis starts to produce wrong results.

Any idea why set analysis is producing different results in this example?

One of our source systems is going through an upgrade.  'Most' of the time the updates go through our data warehouse before they come to Qlik (Cloud).  However, I have discovered we have a built a direct data connection to that source system.

Is there a monitoring app that can help me track down if that connector's ever been used in the Cloud?

I checked the reload analyzer and that seems like a good place, but can someone confirm that's the best source?

Thanks in advance!

Hi Experts

I am using tREST component to extract the online book data and decode the json data and write the data on the console. When I excecated the job i don't get any error but when i check the console i get the error as

Missing property in path $['results']

I tested the below open link on the postman with necessary secrete keys its worked fine. But i dont know this error.

Please see the attachment. Kindly help in solving the issue.

Thanks and Regards

Vijay

Did Qlik Cloud change anything this last month regarding variables created in load editor which are used in frontend?

For example, variables created in load editor:

Let vFoobar = 'Foobar';
Let vName = 'John Doe';
Let vEmpty = '';

... are suddenly not working in frontend anymore:

Name: vFoobar
Definition: Foobar
Value: -

Name: vName
Definition: John Doe
Value: Error: Garbage after expression: 'Doe'

Name: vEmpty
Definition:
Value: Error: Invalid or Empty expression.

Before, value was identical to its definition for string variables. But now I get these errors. This new behavior is breaking my apps. Is no one else having this issue? I couldn't find any information about this in the community.

As stated in the title, I installed Talend Real-time Big Data Platform 8.0.1. From previous posts, Talend states that the elastic components listed here are available to RTBDP license installs.