Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have daily office visit data and a weekly census for that location. How would I do the following? I'm thinking I need to use a Total function but it doesn't seem to work.
Visits Syntax:
Count({<Year={$(yearselect)},Source-={'PSHR'},[Location Description]-={'Work From Home'},[Pay Status]={'Active'},Visit_Swipe={0}>} distinct [Employee ID])
Assigned Seats Measure Syntax:
Count( {<Year={$(yearselect)},Source={'PSHR'},[Location Description]-={'Work From Home'},[Pay Status]={'Active'}>} distinct [Employee ID])
Attached some sample data for reference.
I am using NPrinting May2023 SR2 version, org chart extension, dynamic tables with calculated dimensions in adhoc reporting are not not supported in excel, objects or tables are not rendering properly ,Do you have any solution?
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))
I see from earlier posts (2021-02-11) that it is not possible to convert bookmarks from QV to QS.
Did Qlik fix this issue or is it still not possible?
In source we have the data coming correct where as in target the array coulumns are occing as one column.
For example:
we have source columns as abc1,abc2, abc3, abc4, abc5 with values 19,0,0,2,4 in target data is loaded as abc with value 19;0;0;2;4.
For splitting each column I used below functions. please review.
abc1 : substr($abc1,1, instr($abc1,';')-1) = returns 1st value
abc2: SUBSTR($abc2, INSTR($abc2, ';') + 1 , INSTR($abc2, ';')-1) = doesnt return 2nd value instead returns 0;
Please help us in resolving this issue in qlik replicate.
Thanks in advance.
I am having my job running very well when Target Exec is set to localhost however when it is set to DataIntegration_RE_3(Environment:Development) it fails with the below given. I have gone through the documentation and made sure that the file org.talend.remote.jobserver.server.cfg has got the specific variables mentioned in the documentation (https://help.talend.com/en-US/remote-engine-user-guide-linux/Cloud/configuring-connection-between-talend-studio-and-talend-remote-engine) set correctly. Execution failed : org.talend.remote.commons.exception.ClientServerException: java.net.ConnectException: Server unreachable 10.52.0.56:8013, message: Connection timed out: connect [java.net.ConnectException: Server unreachable 10.52.0.56:8013, message: Connection timed out: connect] The version.txt in the remote engine has the following 2.12.5_Tipaas/tmc-engine/release%2FR2022-10-02_252_Engines/tipaas-remote-engine-build/master
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
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
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
Wondering about Qlik Talend Data Integration Sessions? There are 11, in addition to all of the Data & Analytics. So meet us in Orlando, June 3 -5.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik enables a frictionless migration to AWS cloud by Empresas SB, a group of Chilean health and beauty retail companies employing 10,000 people with 600 points of sale.
Qlik Luminary Stephanie Robinson of JBS USA, the US arm of the global food company employing 70,000 in the US, and over 270,000 people worldwide.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!