Hi Team,

Could you please give some idea how to achieve multiple to address in for one email based on filter option in excel. I have followed below steps but not able to achieve

Receiving below warning in N printing side

Not find any selected items

I am creating a Pivot table under which I have eight measures, I need to create one custom label for for 3 measures another label for 2 measures and one more label for last 3measures. Is it possible ?

something like this 

Hi Community, 

we get the error Invalid escape sequence (valid ones are \b \t \n \f \r \" \' \\) when we click "Guess schema". 

We don't change the query and we get it in every job.

We are use a Microsoft SQL Server and Microsoft Server 2016 Datacenter. 

I tried to reproduce the error. I don't get the error. 

Talend Version: 6.3.1.20161216_1026 

I hope you have any ideas how we can fix that.

Thanks & Regards

Selina

When we load data through Qlik replicate, In Source we have a fields containing multiple values, Seperated by ;

For Example,

Field Name in source:  Tax

Value : 10;12;4

in target we want it to be flattened,

Tax1 field should have the value 10

Tax2 field should have the value 12

Tax3 field should have the value 4

We have written a expression and its working, is there any other simple maner if we can solve this issue, giving the logic we are using currently.

Tax1 :

 substr($TAX,1,instr($TAX, ";")-1)

Tax 2:
substr(substr($TAX,instr($TAX, ";")+1,length($TAX)),1,
instr(substr($TAX,instr($TAX, ";")+1,length($TAX)), ";")-1)

Tax 3:
substr(substr($TAX,instr($TAX, ";")+1,length($TAX)),
instr(substr($TAX,instr($TAX, ";")+1,length($TAX)), ";")+1,length($TAX))

The two, subject numeric fields figure into a finance report which also contains static text and many more numeric fields. The latter set of numeric fields are dynamic and their values change automatically as data in the App changes; and these field values appear just fine after the sheet is made Public to a User who has Private Analytics Content Creator, Shared Space Creator and Steward rights

The two, subject fields differ from the many additional numeric fields in that they are populated with measures using two separate input variable controls. Once these variable inputs are manually input, their values appear just fine in the Text & Image chart. However, they disappear when the sheet is made Public to the same User.

Can anyone explain the problem and how to fix it?

Thanks in advance!
Oliver

Hi all,

I have a dashboard with a filter of the field event_name and I selected all the events with the words amnesia 2024 in it. But I need to create a table to display all the events with the words amnesia 2023 in it. How could I do it?

Just in case it helps, I have 2 fields called event_code and a previous_event_code so the events of 2024 and 2023 are related that way.

I tried this but didn't work: 

={<year_event=, month_event=, event_code=p(previous_event_code), event_to_compare=, event_name= >} event_name

Many thanks!!

Hi guys, I have an input table with the % of comission for each Product Type Sale for each SalesMan. 

The table looks like this (in the real case the SalesManID is dynamic, it's not only for 4 salesman) :

And I'd like to get an output of a desired table like this :

Could anybody help me please? I don't know if crosstable it's the best option, I'm trying to do it but with no results.

PD : I've attached the example in excel, in order to make it easier for everyone to understand.

Kind regards, Marcel.

Hello All, I want to create same like below in Qlik sense
Data Detailed report is Heading and 4 links at right are hyperlinks, instead of hyperlink I created button
I want show exactly like in picture

Plese help
Thanks!