Discussion Board for collaboration on QlikView Scripting.
I am wondering if there is a way to take in the first 3 columns in the below tables, and get an output of the 4th.
Basically each case has a list of related entities, that produce multiple rows in the table. If one of the entities for a case
is an american entity, then I want to have a flag in each row of that case saying it is an american case.
Any ideas of how this can be done?
Maybe some kind of for loop?
Go to Solution.
Load case,Entity,[American Entity] from source;
Left join (T1)
Load case, if (Wildmatch(concat (distinct [American Entity]),'*Y*'),'Y','N') As [American case]
Resident T1 Group by case;
Doubt: 4th case should be 'N', right?
Can you be little more specific and what is the output that you are expecting...
How is American Case evaluated, what is the logic here? do u have another data table that holds that info??
Hi, so the first 3 columns are already provided (which states whether is is american or not) and I want to create the 4th column, which basically tells you if that case has atleast 1 american entity or not.
Yes Sethu, sorry Los Angeles should have a Y, thank you for the help, I'll try that
Hi, does American entity need to be in square brackets?
Yes, it has to be in square brackets because it has space.
We can get the result we need with the appropriate expression without resorting to rewriting the script:
We can take out all dimensions except for the Case and get this:
Hi, is that inside the load script or an expression in the front end?