topic Set analysis in Script in QlikView

Set analysis in Script

cristianj23a — Wed, 25 Nov 2020 16:16:04 GMT

Hi.

Can someone help me enter this code to the Script please

=Aggr(

Num(Count(distinct{<DíaSemana={'*'}-{'dom'},%FILTRO_ACTIVOS={'ACTIVO'},[T554T.Clase absent./pres._AWART]-={'1003','1013','1015','1020','1022','1025'},PA0000.Fecha = {"$(='<=' & date(NOW(),'DD/MM/YYYY'))"}>}PA2001.Día),'###,###'),[PA0000.Número de personal_PERNR],[T554T.Clase absent./pres._AWART],Año,Mes)

Re: Set analysis in Script

sunny_talwar — Mon, 27 Nov 2017 01:29:31 GMT

May be like this

LOAD [PA0000.Número de personal_PERNR],

[T554T.Clase absent./pres._AWART],

Año,

Mes,

Count(DISTINCT [PA2001.Día]) as Count

Resident .....

Where Len(Trim(DíaSemana)) > 0 and DíaSemana <> 'dom', %FILTRO_ACTIVOS = 'ACTIVOS' and not Match([T554T.Clase absent./pres._AWART], '1003','1013','1015','1020','1022','1025') and [PA0000.Fecha] <= Today()

Group By [PA0000.Número de personal_PERNR], [T554T.Clase absent./pres._AWART], Año, Mes;

Re: Set analysis in Script

cristianj23a — Tue, 28 Nov 2017 13:07:46 GMT

Thank You Sunny.