topic Flag creation in Script in QlikView

Flag creation in Script

grajmca_sgp123 — Mon, 07 Nov 2016 13:08:26 GMT

Hi Experts,

I would like to create one new flag with values Available/Over Booked.

Here below is my requirement .

If any one of project "duration" field is negative , I would like to create Flag value as "Over Booked" for whole set of Technology. If "duration" field has all positive values flag value should be "Available" for whole set of Technology.

Let me how can we achieve this requirement.

Technology	Project	duration	Available/Over Booked	Flag(required field)
Java	A	5	Available	Available
	B	10	Available
	C	1	Available
C	X	-5	Over Booked	Over Booked
	Y	4	Available
	Z	0	Available
	P	4	Available

Thanks in advance.

Re: Flag creation in Script

marcus_sommer — Mon, 07 Nov 2016 13:16:45 GMT

Maybe in this way:

load Technology, Project, duration from YourSource

left join (t)

load Technology, if(min(duration)<0, 'Over Booked', 'Available') as Flag

resident t group by Technology;

- Marcus

Re: Flag creation in Script

Gysbert_Wassenaar — Mon, 07 Nov 2016 13:20:49 GMT

Perhaps like this:

MyTable

LOAD

Technology,

Project,

duration,

If(duration >= 0, 'Available', 'Over Booked') as [Available/Over Booked]

FROM

...source data....

;

JOIN (MyTable)

LOAD

Technology,

If(Min(duration)<0, 'Over Booked', 'Available') as [Flag (required field)]

RESIDENT

MyTable

GROUP BY

Technology

;