Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Aggregation problem

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 !

6 Replies
qlikoqlik
Contributor II

Re: Aggregation problem

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;

Sort.PNG.png

Thanks

Padma

Not applicable

Re: Aggregation problem

Wow that looks good I will give that a try thanks

jolivares
Valued Contributor

Re: Aggregation problem

Mark as answered if it is done...

Not applicable

Re: Aggregation problem

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

Hi,

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

QlikCommunity_Thread_129604_Pic1.JPG.jpg

QlikCommunity_Thread_129604_Pic2.JPG.jpg

hope this helps

regards

Marco

Not applicable

Re: Re: Aggregation problem

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 ?