topic Re: Script help in QlikView

Script help

Thu, 22 Nov 2012 12:19:03 GMT

hi can someone help me please convert the folloowing into set analysis code

if (pers_race LIKE 'Black' AND pers_isowner LIKE 'Y' AND isNull(Comp_Deleted) AND isNull(Terr_Deleted) AND IsNull(Pers_Deleted) AND comp_status = 'WorkingWith' AND Terr_ChildCount = 0, count(PeLi_PersonId))

thanks alot

Re: Script help

Gysbert_Wassenaar — Thu, 22 Nov 2012 12:44:50 GMT

Try:

count({<pers_race={'Black'},pers_isowner={'Y'}>,Comp_Deleted-={'*'},Terr_Deleted-={'*'},Pers_Deleted-={'*'},comp_status={'WorkingWith'},Terr_ChildCount={0}>} Peli_PersonID)

The expression editor flags -= as wrong (underlined red), but that's a bug in the editor.

Re: Script help

Thu, 22 Nov 2012 13:13:40 GMT

i am a bit confused here so how can you write the one below which is comparing two fields?

if (netw_Secterr =Terr_TerritoryID AND Terr_ChildCount = 0 AND netw_eventfocus = 'Black' And isNull( netw_Deleted), count(netw_NetworkEventID))

Re: Script help

jonathandienst — Thu, 22 Nov 2012 13:43:54 GMT

You are aware that

If( <cond> , Sum(....))

is not the same as

Sum(If( <cond>, ....))

The first one, as per the orogonal post, does not lend itself to a set expression because the condition is outside the aggregation function...

Just my 2c - perhaps the OP meant a sum(if())...

Jonathan