Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
I have 3 environments Dev, UAT and Production and my objevtive is to store a script file in each of these envirnmenyt to help me to set some envirnmental related variables - the benefit being that these are outside of my load script so that I can promote dashboards through the envirnments with little fuss.
So for example I hope to hold the connection name in the script and refer to it as $(vConnection) etc.
I understand that I need to create a text file for my script which I have done (Environment.txt) and this is stored in the root of the Space I have (Live - PP) my connection name is called 'PP-prod'
In my Load script I have added:
$(Must_Include='lib://Live - PP:PP-prod/Environment.txt');
I have also tried:
$(Must_Include='lib://:PP-prod/Environment.txt');
$(Must_Include='lib://Live - PP:/Environment.txt');
$(Must_Include='lib://Live - PP:PP-prod/DataFiles/Environment.txt');
as well as the above with the file named Environment.qvs
I get the error
$(MUST_INCLUDE= *** cannot access the local file system in current script mode. Try including with LIB path.
Can anyone advise what I might be doing wrong?
Thanks
Mark
Hello everyone,
I have the following question:
Let's say a user belong to two different groups (in my case it is AD group).
Let's say that :
In that case is qlik capable of giving the right to the group/users who has the most rights (in that case it would be the 3rd Case)
Thank you
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!