topic Re: Scenario for Expression in Script in QlikView

Scenario for Expression in Script

dunnalahk123 — Sat, 16 Nov 2024 03:33:53 GMT

Hi,

Can some one help me here how can we write in script for below scenario

I have one Project ID for that we will have multiple Subtasks , out of that if one subtask is bad i want to exclude complete Project. how can i do it.

in below example one project has multiple Subtasks out of that if i have one Bad subtask at least (ExclusionProjectFinalFlag='1') then i want to exclude that Project completely from my report .

how ca i write in script, can some one help me here.

Best Regards,

Re: Scenario for Expression in Script

daanciorea — Thu, 16 May 2019 08:49:34 GMT

Hi,

Try load again your data with Resident statment and where ExclusionProjectFinalFlag = 1. Don't forget to drop your initial data.

Dan.

Re: Scenario for Expression in Script

anushree1 — Thu, 16 May 2019 09:11:27 GMT

Pleas try the below snippet:

Load * from tablename

where ExclusionProjectFinalFlag<>1;(use '1' if the flag is a character if numeric no quotes)

Re: Scenario for Expression in Script

dunnalahk123 — Thu, 16 May 2019 09:50:57 GMT

Hi,

Same i wrote , but it is not working.

why because

1 project has multiple subtask so if i write like above its just excludes only that subtasks which is ExclusionProjectFinalFlag='1' still that Project appears in the report.

my point is for project if one subtask has ExclusionProjectFinalFlag='1' that project itself should be excluded from the report.

Re: Scenario for Expression in Script

anushree1 — Thu, 16 May 2019 09:58:33 GMT

Ok Please try this:

Temp:

LOad Proj_id

from<Table Name > where ExclusionProjectFinalFlag='1'(quotes only if character);

Final:

Load Proj_id as ProjectID,

Other Col Names,,,,,

From <Table Name >

where not exists(Proj_id,ProjectID);

Re: Scenario for Expression in Script

daanciorea — Thu, 16 May 2019 10:00:58 GMT

Hi,

Then try ssomethinnk lile this:

A:
Load
ID_Proyect,
Max(ExclusionProjectFinalFlag) as ExclusionProjectFinalFlag
Redident YourTable Group By ID_Proyect;

B:
Load
ID_Proyect,
...
Resident YourTable;
Right Join(B)
Load
ID_Proyect
Resident A Where ExclusionProjectFinalFlag = 1;

Drop Tables YourTable, A;

Table B must contains only the proyects that there aren's bad subproyects.

Dan.

Re: Scenario for Expression in Script

sultanam — Thu, 16 May 2019 10:25:36 GMT

Hi,

You can try below.

A:

Load ProjectID

from your table;

B:

Load
*

from your table
where not exists(ProjectID) ;

Drop Table A;

Note : Please use the correct fields name.

Re: Scenario for Expression in Script

sultanam — Thu, 16 May 2019 10:27:59 GMT

Hi,

Sorry try below one.

A:

Load ProjectID

from table where Flag=1;

B:

Load *

from table where not exists(ProjectID);

Drop table A;