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.

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

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 :

• 1st Case - Group 1 : Space Role in Managed Space = Has restricted view
• 2nd Case - Group 2: Space Role in Managed Space =  Can View
• 3rd Case - No Group But only user id/name : Space Role = Can view + Can managed

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