Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Recently SAP has announced change in their Terms & Co which does not permit (although no hard stop yet) SAP connection type: ODP through RFC.
Are there any plans for upgrades of SAP connector ? Or it is already using different connection type and therefore its "future-proof" ?
Thank you in advance,
I would like to know how I can find out the username and password for my Postgres database, as my data is out of date in the operations monitor dashboard, and so I cannot know the amount of access to each dasboard we have.
In the beginning, all was simple. I have a graph of Count(Orders) over time.
I have a set of 8 categorical variables that all could be used to filter the data and/or to produce a stacked surface or bar chart, but some have many categories and the chart wouldn't be readable. My goal therefore to highlight only one category of one variable at a time, while still being able to filter on other variables. I thus display two data series: highlighted + rest. This works - but just nearly.
I figured I could use two variables v.HighlightField and v.HighlightValue. The first series would display Count({$<[$(v.HighlightField)]={'$(v.HighlightValue)'}>} Orders), the other one the rest.
I use a first VizLib Variable Input to set v.HighlightField, and a second one to set v.HighlightValue. [If you're curious: it's dynamic values are defined as: Pick(Match(v.HighlightField, '', [Field name 1], [Field name 2], ...), [Value list 1], [Value list 2], ...)]
Now when I set a value of v.HighlightField and a value of v.HighlightValue in the dropdown boxes and subsequently change the v.HighlightField, the value of v.HighlightValue stays as it is. I end up with an incompatible combination of field and value.
How do I clear the latter variable when the former changes? This would do the trick.
Or maybe you know a completely different solution? One big variable with all field names and all values? Meh. Dummy fields to use in the set expression?
Hi Team,
We (Client A for Example) want to carry on an Upgrade for z/OS V2.5 in coming Weeks and QLIK V6.6 is in our System and we are aware that this version is not Compatible with z/OS V2.5.
Now, we would like to know if QLIK V6.6 will be a Show Stopper if we skip this Product's upgrade and perform our z/OS V2.5 Upgrade.
Please Clarify.
Hi All,
I need to display the overlap call on same day and same customer with different positionid. For example, we have four calls for two days. But we need to display the overlap call (light orange highlighted) in the output.
One positionid started the call with the customer at 9:30 AM whereas different position cannot start the call with same customer. We need to find this type of scenarios.
Thanks in advance.
Hello!
I am working on loading a data set looking at patient eligibility for a certain insurance. For this data set, I have a patient ID, start date of eligibility, and stop date of eligibility. See example of data below:
I would like to create a "Yes/No" field in the load script for each patient ID on whether or not they are eligible for the insurance for each month. For example, all the months between 3/1/2022 and 12/31/2022 would say "Yes" for eligibility for patient ID 4, but all the months between 12/31/2022 and 4/1/2023 would say "No" for eligibility for patient ID 4. We thought about using a "For Each" loop, but it seems inefficient given the size of our data set. What would be the best way to achieve this result?
Solution for implementing Retry option in Talend. If one of the step failed in talend due to connection error, try this step once again and proceed.
please suggest solution for implementation
Hi all,
How can I move a namespace for an element to the root structure of the XML? Now the xmlns:dt namespace is shown on each and every dt:dt element.
This is what I have:
This is what I want:
Namespace setup:
XML properties
Attribute name:
I couldn't find anything specific in the docs for this. I am sure there must be a straightforward way, but I can't wrap my head around this.
Hopefully someone has an insight on how to achieve this, or has managed to get it working before. Every input is greatly appreciated.
Thanks,
Reno
I have data has column names of pick1, pick2, ..., pick5. But I want to make a new list, 'pick' and put these five columns as factors of 'pick', so that I can create a filter pane and get linked. Same as cost1, cost2, cost3, cost4 should belong to a new field, 'cost' , and get linked to the main table.
Now I click the filter panes, but nothing gets selected.
mainTable:
load*inline [
week,'num of pick, pick1, pick2, pick3, pick4, pick5, cost1, cost2, cost3, cost4, hrSum
1, 3, apple, banana, strawberry, NA, NA, 10, 20, 30, 40, 200
2, 5, durian, grapes, apple, dragonfruit,orange, 20, 25, 0, 20, 300
3, 1, fig, NA, NA, NA, NA, 5, 10, 0, 15, 500
4, 2, lemon, gratefruit,NA, NA, NA, 10, 3, 5, 0, 1000
5, 3, dragonfruit, gratefruit, fig, NA, NA, 10, 20, 5, 4, 200];
colname1:
load * inline [
pick,
pick1,
pick2,
pick3,
pick4,
pick5];
colname2:
load * inline [
cost
cost1
cost2
cost3
cost4];
Hello,
I'm trying to filter lines of a table that has multiple dimensions and only one expression that I use for filtering.
The field's values are something like this:
And the end product has to be something like this:
I believe that the correct expressión is this one:
Count ( Distinct {<form_order={"max(<[No. Proceso]>form_order)"}>} [No. Proceso])
Do you have any idea why this isn't working?
Thanks!
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.
Help us improve your Qlik experience by participating in our customer survey! The survey will be live from May 27 - June 14.
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 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.
Nortera leads agricultural manufacturing analytics and automation with Qlik, reducing short-shipment rates and annual savings in water consumption.
Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.
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!