I have Talend Studio trial version installed in my machine expiring in 4 days. Yesterday i received License key file and need help in integrating the key file to Talend studio.

Hello there.

I need to create a column in LOAD section to count how many times record has appeared before (including actual row).

I created a function called "UNIQUE-AUTO" on LOAD section

AutoNumber(Upper([Column1] & [Column2] & [Column3] & [Column4] & [Column5] & [Column6] & [Column7] & [Column8])) as "UNIQUE-AUTO"

This function aims to give a specific number for the concatenation of several columns.

So if I filter for the number 21454, I see that there are 5 occurrences in my database.

What I need is to create a function in SQL to find out how many times the record from UNIQUE-AUTO column appeared before. I.E, the values from the new calculated collum in SQL must show in the first line 1, the second line 2 and so on up to 5, as there are 5 occurrences for the number 21454.

Greetings.

In the QlikSense script, I have a table with some fields and a formula descriptor that defines the formula to be used for output. Is there a way to interpret the text in formula as a field and get the appropriate result?

The expected outvalue value is shown in column EXPECTED_OUTPUT_VALUE below along with the calculation

Hi all,

I have data as shown, i want to show the fields like country,company1,company 2 etc..,

How can i load this data in load editor ,can anyone help me with this

Hi guys.

I have several qvd files, which differ in the number and name of fields.

But I need to upload all the files with all their fields.

Is there a way to know if a file has a field or not, so that during the loading process, it does not generate an error when reading a file that does not have those certain fields?

Thanks and regards.

Hello, I am opening an existing qlik app using qlik.openApp(appId) then creating hypercubes to fetch data from qlik and use it in mashups

I have three challenges when trying to retrieve data using hypercube in a Qlik mashup:

1. I need to exclude a specific value while filtering data. I'm looking for an alternative to app.field.selectValues or selectMatch, something akin to the SQL NOT IN clause. For example, I want to get all records where the country is NOT IN "".

2. On my product comparison page, I need to fetch data for two products either sequentially or asynchronously. I have to apply multiple filters for the first product, create a hypercube to store that data, and then apply filters again for the second product, repeating the process. However, I've noticed that sometimes cube returns the same data for both products. This inconsistency is puzzling; about 50% of the time, it provides the correct, distinct data for the two products, but at other times, I receive identical data. I've experimented with various JavaScript methods to manage asynchronous behavior, such as promises and async/await, but the results remain unstable.

3. Occasionally, some values are returned incorrectly. At times I dont require any dimensions but just measures like SUM, Avg but here the values displayed in the Qlik app do not match what I get when querying in the mashup through hypercube. Refreshing or filtering again sometimes resolves the issue, but this behavior is also inconsistent, as the same code works at times.

For fetching data I am using app.createCube and to apply filters app.field().selectValues or selectMatch. I am a web developer and good with working with apis but not very famililar with qlik hypercube filtering. Any help would be greatly appreciated. Thanks!

Hi all

I have a requirement where expression being used in Qliksense bar chart and expression I need to implement as dimension in straight table?

I am attaching the expression in below image with variables included inside the set analysis. 

Immediate response will be appreciated  

•  Qlik Sense Business ,#straight table 

Hi,

Currently we are using JWT Proxy workflow with section access. We use qlik mashup api's to load the qlik app.

We would like to continue to do so, but the current issue we are facing is socket's disconnection while relaying the requests. We would like to remove our backend so that it can directly connect to qlik.

Is this something possible with M2M? I could not find any examples for M2M with mashup api's. We cannot use qlik embed since we would need to we-write the application itself.

@Jeffrey_Goldberg  Could you provide any input on this? as you suggested the initial approach for proxy when there M2M impersonation was not available?

Thanks,

Akshay