topic Aggregation problem in QlikView

Aggregation problem

Fri, 15 Aug 2014 08:57:37 GMT

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 !

Re: Aggregation problem

qlikoqlik — Fri, 15 Aug 2014 09:55:50 GMT

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

Re: Aggregation problem

Fri, 15 Aug 2014 10:49:50 GMT

Wow that looks good I will give that a try thanks

Re: Aggregation problem

jolivares — Sat, 16 Aug 2014 23:22:22 GMT

Mark as answered if it is done...

Re: Aggregation problem

Thu, 28 Aug 2014 15:11:57 GMT

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

Re: Re: Aggregation problem

MarcoWedel — Thu, 28 Aug 2014 22:51:27 GMT

Hi,

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

hope this helps

regards

Marco

Re: Re: Aggregation problem

Fri, 29 Aug 2014 09:34:45 GMT

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 ?