Aggregation problem

[#1]

HI Guys,

Hoping someone can help I've attached some sourse data, I'm trying to show the number of respondents which have responded for the first time split by wave like in the results sheet attached. It needs to be limited also so the leasing company matches vLeaseCo

I'm very stuck not sure where I'm going wrong !

[qlikoqlik]

HI Sarah

I did this in the script

ActiveEmp:
LOAD [ITA_E-mail],

     ITA_LeasingCompany,

     IT_CHACTIVe,

     ITA_Wave
FROM



(ooxml, embedded labels, table is [Sample Source
Data]);



ActiveSort:
Load [ITA_E-mail] as dd,max(ITA_Wave) as FirstActive, 1 as flag
Resident ActiveEmp where IT_CHACTIVe=1
Group by [ITA_E-mail]
order by ITA_Wave desc;

Thanks

Padma

[#3]

Wow that looks good I will give that a try thanks

[jolivares]

Mark as answered if it is done...

[#5]

Sorry I haven't managed to get it to work yet any ideas ? I need something in the front end ideally as factors are set after the reload

[MarcoWedel]

Hi,

in the front end you could create the first month active flag like:

hope this helps

regards

Marco

[#7]

Hi Marco Thanks that's really useful

What I wanted to get to was a text object with total figures for

suppliers active both waves

suppliers active latest wave only is it possible ?